Friday, November 8, 2013

Adding new fields in PO Output for Communication

It is not easy to customize PO_COMMUNICATION_PVT.POXMLGEN. If you customize it then you have to customize the workflow which references this procedure and also the Java concurrent program. So, try to avoid customization of PO Output for Communication program. 

To add new fields in PO Output for Communication Program, we have following options:

1. Look if the fields you are trying to add are already available in the XML data generated by the program.
2. If not all the fields are available, try to populate the missing fields in attribute columns so that you can reference those in your template.
3. This is not recommended, but you can try to modify the logic behind the views PO_HEADERS_XML, PO_LINES_XML, PO_DISTRIBUTIONS_XML which fetch the data for this program.

Also, for the ability to use RTF Template you can follow metalink note 378031.1 which gives you the details of a patch to be applied. You can also refer to the metalink note 387670.1 for more info.