Oracleshare

Customize Oracle Disbursement Separate Remittance Advice Formats Report

This is an Oracle Fusion Payables seeded report for Remittance advice output format against Supplier’s AP invoice payment. Although Oracle provides this standard seeded…

You are creating a template in xslt 1.0, but this template has been built in xslt 2.0 before

You may get above error message when you to edit Oracle BI RTF which uses xslt tags in Windows word. By default, BI Publisher…

Oracle Fusion xml data source file for Disbursement Separate Remittance Advice Formats Report

This is a seeded report for the Remittance advice output format against Supplier’s AP invoice payment. The delivery of the this report output can…

Oracle BI Desktop Error: Java version has value ‘1.8’, but ‘1.7’

After Oracle BI desktop is installed, you may get above error when you load XML source file and preview the report in any particular…

Oracle BI Desktop RTF tag shows value ref:xdoXXXX

RTF template for Oracle report contains XML data tag which maps to the data source tag value (XML tags). Sometime these xml data tags…

Script for Creating a Credit Memo (AR)

DECLARE l_return_status varchar2(1); p_count NUMBER; l_msg_count number; l_msg_data varchar2(2000); l_batch_id number; l_cnt number := 0; l_batch_source_rec ar_invoice_api_pub.batch_source_rec_type; l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; l_trx_salescredits_tbl…