This content has been marked as final. Show 3 replies
Right after I posted my question here, I talked to another consultant friend and he said that the method to do what we need would be to actually update the underlying standard views like PO_HEADERS_XML and PO_LINES_XML. The modification would be done to columns like GLOBAL_ATTRIBUTE1 etc in the view to return the value you want to print, and then reference them in the custom template.
You are forced to customize the standard views because Oracle does not provide a way to reference a custom data definition in the Document Types setup. You are forced to use one of the templates (custom or standard) attached to the standard data definition. So you can use a custom template to layout the fields the way you want, but all the fields need to be come from the standard data definition.
If there are alternative non-invasive ways to do what we did, please let me know. Or do provide feedback on what is said above.
Hey can you please reply how you achieved this..thanks in advance
Ask your IT Oracle programmer to modify the PO_HEADER_XML view, and include the attribute1..n columns from the PO_VENDORS / PO_VENDOR_SITES_ALL / PO_VENDOR_CONTACTS depending on which DFFs of the suppliers have been enabled.
Once the DFFS are available in the script, the PO Print RTF file can be modified to conditionally print the terms and conditions