XML PUBLISHER - Customize Layout default Purchase Order

[LordElfo]

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.

[dr_gori]

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!

[dr_gori]

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

Select all

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]

What Tomas said is correct, but I'll give you a tip.

Rotate this SELECT in sqldevelopers

Select all

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]

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)

[dr_gori]

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.

[LordElfo]

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 = (

[LordElfo]

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

Select all

select * from PO_HEADERS_XML; 
select * from PO_LINES_XML; 
select * from PO_LINE_LOCATIONS_XML; 
select * from PO_DISTRIBUTION_XML;

[LordElfo]

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

Select all

<xs:element ref="ITEM_LONG_DESCRIPTION"/> 

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 ...

[dr_gori]

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.

[LordElfo]

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.

[dr_gori]

For CONCURRENT name is: XML Publisher Template re-generator

I think only has to run it if you change a file XSL.

: -O

[Renan Castro]

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.