Search This Blog

UTL File Processing

In ORACLE PL/SQL programs to write or read any kind of data from the file to the system and vice versa we will make use of the oracle standard API UTL FILE . To use this
feature first user have to create both logical and physical directories in the
data base server. If we are writing into the file then the user should have the
write privilege and to read user should have the read privilege to the
directory. This UTL_FILE package or API is owned by SYS user.1. Create the Directory As Below.

Oracle EBS provided a standard functionality to print the PO report directly from the PO form itself by clicking tools menu and view PDF option. Once we select that option output will be rendered in PDF format in the browser instantly.

Internally it will run the concurrent program 'PO Output For Communication'. This concurrent program is of JAVA type which will uses the seeded package 'PO_COMMUNICATION_PVT' for generating the XML data and later this XML data will be processed and formatted by using the XSL template of data definition 'Standard Purchase Order Data Source' in case of standard PO's.

Oracle by default will provide one standard BI publisher template for this. In case if we want to have custom layout for this report we can build a new template for the same data definition and this template has to be used while doing the setup for PO Document types.

Creating Custom Template and Setup this for PO Document type:
To create the…