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 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