How to Retrieve the XML Extract for Oracle Cloud ERP Payment and Funds Disbursement Reports
Retrieving the XML extract for payment file reports and related funds disbursement outputs is a common need when customizing or troubleshooting Oracle Cloud ERP.
Why Is This Useful?
Template Development: Designing or troubleshooting BI Publisher layouts often requires a real-life XML sample.
Custom Processing: If you need to transform or use payment data elsewhere, fetching the raw XML is ideal.
Customisation Steps
Here’s two methods you can use to retrieve the XML you need.
01.
Query the Database
You can directly query the database table IBY_TRX_DOCUMENTS to extract the XML for a payment file. Use the following SQL statement, replacing :payment_instruction_id with your actual Payment Instruction ID:
SELECT itd.document_clob
, itd.document
, itd.payment_instruction_id
, itd.doctype
, itd.doc_content_type
FROM iby_trxn_documents itd
WHERE itd.payment_instruction_id = :payment_instruction_id
AND length(itd.document) > 0
AND itd.doctype = 100
02.
Run a Payment Batch with ‘Data (XML)’ Output
Modify your BI Publisher template for payments so the default format is set to ‘Data (XML)’:
Log in to the BI Publisher server with admin privileges.
Navigate to the Payments reports section.
Edit the Disbursement Payment File Formats.
Use the “View a list” option to see available formats.
Set the “Default Format” to Data (XML) on one of the templates (e.g., Japanese Zengin format for example or testing).
Run a payment using this format—the output will be generated as an XML file.
These methods ensure you can continue to develop and support custom payment solutions efficiently.
Need some assistance?
Ready to bring clarity to customer, supplier and employee communications? With BI Publisher, we specialise in customising customer, supplier, and employee-facing documents such as invoices, purchase orders, payslips, and statements to meet your exact branding, compliance, and operational needs. From layout design to data logic enhancements, we help you deliver clear, consistent, and impactful outputs across your organization. Contact us today to discover how our expertise in BI Publisher can streamline your document processes and elevate your business communications.
