Blog / Category
XML Publisher
7 articles in this category
Debug Common Errors in SFTP-Based File Transfer Integrations
Use Case: This integration debugging script and approach is used to analyze and resolve common runtime errors in SFTP-based file transfer services, especially d…
Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…
How To Set and Get the Variable value in RTF Template
Sometimes have a requirement to run the running total in XMLP Report and set the record per page by Variable declaration. Step to follow, Add the form field in…
Restrict Number Of Rows Per Page in XML/BI Publisher
Process to restrict number of rows per page in xml reports by using following command Let us take example if you want show 5 records per page you can use follow…
Bursting Control file using filter condition
Below is the command we can use filler in XML Publisher Data Template. <?xml version=”1.0″ encoding=”UTF-8″?> <xapi:requestset xmlns:xapi=”http://xmlns.oracle.c…
Remove Entire column in RTF Template
By using following tag we can remove entire column in RTF. <?if@column:ORG_ID!=XXX?>Sales Order/Cust PO<?end if?>
XML Publisher Report in Oracle Transportation Management (OTM)
Please follow the below steps to create XML Publisher Report in Oracle Transportation Management: Query Template Format Template Report Adding to SHIPMENT_MANAG…