- Generate the XML Tags from “PO Output for Communication”
- Based on the generated XML we need to develop a Custom RTF template.
- Once the Template is Developed it needs to be assigned in the Purchasing setup to get picked when “PO Output for Communication” is ran.
- Steps to Generate the XML Tags from “PO Output for Communication”
- Choose the `PO Output for Communication’ as report name.
- In the parameter section please enter the following parameters and submit the request.
- Print Selection = All
- Buyer name, Employee Number: Choose the buyer name (who created the PO)
- Purchase Order Numbers From = PO Num
- Purchase Order Numbers To = PO Num
- Test = Debug (Running with Test flag as ‘Debug’ will only produce XML output if
the PDF had not been generated successfully previously.)
- Leave all other parameters as blank.
Note: The document should be in status Incomplete otherwise it won’t generate the readable XML.
- The report will be completed with error status, but log file of the request will show the XML generated by this program run.
- Custom RTF Template Devlopment.
- Based on the generated XML tags we need to develop an custom rtf template and map the required Fields accordingly.
- If any additional Custom Tags needs to be enabled and used on the “PO Output for Communication” then there a provision given by oracle as part of Custom Hook Package “POXMLGEN”.
- Mapping the Custom Template to Standard Program.
- Navigate to Purchasing > Setup > Organizations > Purchasing Options> tab Control > set “PO Output Format” = PDF
- In Purchasing > Setup > Purchasing > Document Types > find Document Type “Purchase Order – Standard”. Then find the Document Type Layout ‘Standard Purchase Order Stylesheet’ which is actually Template Definition.
- Go to XML publisher and find the data definition ‘Standard Purchase Order Data Source'(PO_STANDARD_PO) and Define your own template definition using the data definition and attach the custom template file.
- Change the new template name in the document type.
Recent Posts
