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 report…
Read MoreHow 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 RTF…
Read MoreRestrict 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…
Read MoreBursting 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.com/oxp/xapi” type=”bursting”> <xapi:request select=”/METADATA/ROWSET/ROW”> <xapi:delivery> <xapi:email server=”XXXXXXX” port=”XX” from=”DoNotReply@XXXXXX.com” reply-to=”DoNotReply@XXXXXX.com”> <xapi:message id=”email1″ to=”${TO_MAIL}”…
Read MoreRemove 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?>
Read MoreXML 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_MANAGER Report Group Now report appears under Shipment Management…
Read More