BI Publisher

What do I do? My bank requires data not in the Oracle Payments Disbursement Payments Instruction Extract?

Author: Jonathan LeBlanc Date: April 18th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12

In a previous post, I spoke of an organization that needed to create a custom BI Publisher template to accommodate their Canadian bank’s proprietary file format for EFT files in R12.  What I didn’t mention was that some of the required data was stored in descriptive flexfields within Oracle.   Descriptive flexfields are not included in the Oracle Payments Funds Disbursement Payment Instruction Extract data which is the standard data definition for AP funds disbursement.

As is the case with many organizations, they were concerned that they would have to modify the standard programs to accommodate their bank’s requirements.  Their minds were put at ease when they learned that Oracle provided a standard API which allows organizations to add additional fields (i.e. XML Tags) to the XML extract.  This standard PL/SQL package was the IBY_FD_EXTRACT_EXT_PUB.

The standard XML file that is generated by the Payment Instruction Extract is organized into 4 hierarchical groups:

1. Payment Instruction – The payment instruction group encompasses the entire file.
2. Payment – The payment group represents a payment to a specific supplier.
3. Document Payable – The document payable group represents the individual invoices that are being paid to the supplier within the payment.
4. Document Payable Line – The document payable line group represents the lines within the invoice being paid to the supplier.

» Read More