Hey guys.
I have a problem here.
I'm trying to create a custom template based on the standard purchase order layout.
So far I have made the steps.
- I was in the administrator responsibility of the XML publisher
- I entered the Model menu
- I duplicated the standard purchase order model.
- I changed the custom template po_standard_xslfsl file, creating a new column.
until then beleza. I showed 2 times the description of the item in the table.
My problem is that in the column I created I need to show the long description of the item, located in the LONG_DESCRIPTION field of the MTL_SYSTEM_ITEMS_TL
table
I saw that it generates the PDF In the PACKAGE PO_COMMUNICATION_PVT probably in the POXMLGEN function
But will I need to modify this core function?
or how to change only the data definition file related to the template?
Does anyone have any idea?
VLW staff.
XML PUBLISHER - Customize Layout default Purchase Order
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Yes, in XML Publisher there in the template you edit what is the Definition related to the template. And it was already!
Go on the Template tab, choose your template and click Update to change it!
Go on the Template tab, choose your template and click Update to change it!
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Dude, now that I'vê seen you're using an XSL.
It is easy to change when the file is an RTF and has a Device Definition in XML ...
But in these cases of XSL that is the case of the PO, I'm trying find out how it does it.
It seems that you have to edit the views XML, example: po_headers_xml.
hence the program in java rides the data according to the view. Try to add this new field In the view and run your template to see if it will work ... Then warn you
In addition it has all other views:
PO_LINE_LOCATIONS_XML, PO_Distribution_XML and PO_RELEASE_XML
I found this tip, but I did not find the poxpostd_xml.rtf
It is easy to change when the file is an RTF and has a Device Definition in XML ...
But in these cases of XSL that is the case of the PO, I'm trying find out how it does it.
It seems that you have to edit the views XML, example: po_headers_xml.
hence the program in java rides the data according to the view. Try to add this new field In the view and run your template to see if it will work ... Then warn you
In addition it has all other views:
PO_LINE_LOCATIONS_XML, PO_Distribution_XML and PO_RELEASE_XML
I found this tip, but I did not find the poxpostd_xml.rtf
R12 PO output can be created or modified by using BI Publisher. The following are the steps that need to be taken.
1. Download the Standard PO xml file from /po/12.0.0/patch/115/publisher/defs. Name of the file is PO_STANDARD_P.xml
2. Download the staqndard template either from the application or from the directory /po/12.o.o/patch/115/publisher/template/US. Name of the file is POXPOSTD_XML.rtf
3. Use BI pulisher to modify or recreate the template and name it with a custom name
4. Register the template in the application. Template datasource must be set to Standard Purchase Order Data Source
5. Update Document type: Purchase Order Standard by navigating to Purchasing->Setup->Purchasing->Document Types. Update the Document Type Layout to the name of your custom template from the standard value of Standard Purchase Order Stylesheet.
6. Test your output by running the concurrent program PO output for communications
7. The standard PO xml output can be modified by modifying the views PO_HEADERS_XML and PO_LINES_XML, for example the standard PO xml does not have value for vendor contact email, for this to be included in the xml modify PO_HEADERS_XML to add column PVC.EMAIL where PVC is PO_VENDOR_CONTACTS table.
- madmax
- Rank: DBA Pleno
- Posts: 293
- Joined: Wed, 13 Dec 2006 5:02 pm
- Location: São Paulo
- Contact:
________________________________
Douglas - Madmax.
Douglas - Madmax.
What Tomas said is correct, but I'll give you a tip.
Rotate this SELECT in sqldevelopers
will appear 2 RTF and XLS files in XLS Click In the File_Data field field, the XLS file will appear to change then Close the file will appear a message to save xdo_lobs.file_data Click Yes
then click Post Changes and Commit Ready .
I hope I have helped.
Rotate this SELECT in sqldevelopers
SELECT FILE_DATA, DBMS_LOB.GETLENGTH(FILE_DATA),
FILE_NAME, LAST_UPDATE_DATE
FROM XDO_LOBS
where file_name LIKE 'XXOMBRN%' -- nome do Report
FOR UPDATE
will appear 2 RTF and XLS files in XLS Click In the File_Data field field, the XLS file will appear to change then Close the file will appear a message to save xdo_lobs.file_data Click Yes
then click Post Changes and Commit Ready .
I hope I have helped.
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I found this link, which can bring some information. http://chandramatta.blogspot.com/2010/0 ... ce-po.html
What I do not understand is the following:
Doubt 1:
* There is no Concurrent Program linked to this report "PO_STANDARD_XSLFO" -> "Standard Purchase Order Stylesheet".
Then: Who executes this report? How does it run? (I'll take a look at the purchase order approval program. There he triggers this report and sends to the email)
doubt 2:
* How do you know what the parameters of this report ? (When we have XML and an RTF is all well defined at the beginning of XML)
What I do not understand is the following:
Doubt 1:
* There is no Concurrent Program linked to this report "PO_STANDARD_XSLFO" -> "Standard Purchase Order Stylesheet".
Then: Who executes this report? How does it run? (I'll take a look at the purchase order approval program. There he triggers this report and sends to the email)
doubt 2:
* How do you know what the parameters of this report ? (When we have XML and an RTF is all well defined at the beginning of XML)
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Doubt 1
Concurrent is the PO OUTPUT FOR COMMUNICATION [POXPOPDF) inside it, one of the parameters is the "Purchase Order Layout", where You choose between the layouts of the po. It is based on this Value_Set: PO_SRS_POXPOPDF_PO_TEMPLATE.
But this is just a concurrent that calls a Java Concurrent Program ..
to fiddle on the data, you have to mess with the XML views.
My problem is that I want to create a new date definition and then I do not know what parameters that this date definition must have.
PS: I'm doing this modification here too.
Concurrent is the PO OUTPUT FOR COMMUNICATION [POXPOPDF) inside it, one of the parameters is the "Purchase Order Layout", where You choose between the layouts of the po. It is based on this Value_Set: PO_SRS_POXPOPDF_PO_TEMPLATE.
But this is just a concurrent that calls a Java Concurrent Program ..
to fiddle on the data, you have to mess with the XML views.
My problem is that I want to create a new date definition and then I do not know what parameters that this date definition must have.
PS: I'm doing this modification here too.
Personal Opa
Someone reached
Package PO_COMMUNICATION_PVT ?
I am prone to believe that the information comes by the function poxmlgen
but the code is so intricate ... passes through so many that I was kind of confused.
and worse I do not identify the fields of the report.
My idea is.
He sends the results by this function and the XML of the layout if using the same name as the field receives the values ??...
But it is complicated = (
Someone reached
Package PO_COMMUNICATION_PVT ?
I am prone to believe that the information comes by the function poxmlgen
but the code is so intricate ... passes through so many that I was kind of confused.
and worse I do not identify the fields of the report.
My idea is.
He sends the results by this function and the XML of the layout if using the same name as the field receives the values ??...
But it is complicated = (
Oops Gori.
Looking at the link you passed seems to be what I need =) http://chandramatta.blogspot.com/2010/0 ... ce-po.html
I can see if I can modify a view here to return what I need.
I just did not see where he calls these views
Looking at the link you passed seems to be what I need =) http://chandramatta.blogspot.com/2010/0 ... ce-po.html
I can see if I can modify a view here to return what I need.
I just did not see where he calls these views
select * from PO_HEADERS_XML;
select * from PO_LINES_XML;
select * from PO_LINE_LOCATIONS_XML;
select * from PO_DISTRIBUTION_XML;
Back ....
I changed the view ... adding an extra table to get a field of it.
I created a new Device Definition
I copied the files that were on the original Definition Definition PO_Standart_Po.xsd and PO_standart_Po.xml for this new Definition Definition that I created.
I added the field in the LINES_ROW Part
item_long_description was the field I added to the view po_lines_xml
and in the Template I put the call to item_long_description ...
Well ... It did not give a mistake in the view .... I'm waiting for the business analyst to test by changing the definition of the templates po and test In the application ...
I changed the view ... adding an extra table to get a field of it.
I created a new Device Definition
I copied the files that were on the original Definition Definition PO_Standart_Po.xsd and PO_standart_Po.xml for this new Definition Definition that I created.
I added the
<xs:element ref="ITEM_LONG_DESCRIPTION"/>
item_long_description was the field I added to the view po_lines_xml
and in the Template I put the call to item_long_description ...
Well ... It did not give a mistake in the view .... I'm waiting for the business analyst to test by changing the definition of the templates po and test In the application ...
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I will have to also change the releases report (releases).
At first, it will be + or- the same thing ... then notice if I have any difficulty.
At first, it will be + or- the same thing ... then notice if I have any difficulty.
Oops.
Finally I did the test.
worked here.
In the end I needed to modify only related view.
In my layout had item_description. I went to PO_LINES_XML and changed Query from this view to include the long description.
An important thing I have seen in these tests was that you need to run a concurrent for if you change the layout. This concurrent is available for the responsibility of Publisher just below the layout control options.
I was having a problem because it changed the layout and at the time of testing was still the same ... with this concurrent it updates and when I will test take the new change made.
personal vlw.
Finally I did the test.
worked here.
In the end I needed to modify only related view.
In my layout had item_description. I went to PO_LINES_XML and changed Query from this view to include the long description.
An important thing I have seen in these tests was that you need to run a concurrent for if you change the layout. This concurrent is available for the responsibility of Publisher just below the layout control options.
I was having a problem because it changed the layout and at the time of testing was still the same ... with this concurrent it updates and when I will test take the new change made.
personal vlw.
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
For CONCURRENT name is: XML Publisher Template re-generator
I think only has to run it if you change a file XSL.
: -O
I think only has to run it if you change a file XSL.
: -O
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 22 Feb 2011 11:01 am
- Location: Juiz de Fora
Gentlemen, good morning!
Sorry for reviving this topic but I want to say how much I am grateful to you for the valuable information!
I have already seen customizations from the purchase order in which the consultant has changed to the communication package and several Java classes. More than 30 objects were sent through patch.
With the information contained herein I was able to do the less intrusive way possible by modifying the smallest number of possible core objects (in this case only to the view).
In the newer IEBS release (12.1.3) There is also an option in the Competitor PopOxpdf program to regenerate the document in the database, a common request of clients who do not want to rise revision after modifying only one comment in the document of the OC.
Once again, thank you all! It's exceptional as I did everything here was written and I had no problem, everything simply worked! Excellent my friends!
Hugs, cordially,
Renan.
Sorry for reviving this topic but I want to say how much I am grateful to you for the valuable information!
I have already seen customizations from the purchase order in which the consultant has changed to the communication package and several Java classes. More than 30 objects were sent through patch.
With the information contained herein I was able to do the less intrusive way possible by modifying the smallest number of possible core objects (in this case only to the view).
In the newer IEBS release (12.1.3) There is also an option in the Competitor PopOxpdf program to regenerate the document in the database, a common request of clients who do not want to rise revision after modifying only one comment in the document of the OC.
Once again, thank you all! It's exceptional as I did everything here was written and I had no problem, everything simply worked! Excellent my friends!
Hugs, cordially,
Renan.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 17 guests