How-TO: Get XML file for AP Check Print Program

Here in this post I would like to tell my way of getting the XML for a Format Payment Instruction Program or other words AP Check Print Program.

For every new Format Payment Instruction program run, the XML is getting stored in IBY_TRXN_DOCUMENTS table (at least in R12.0.6). We need to either query this table and get the last created record column DOCUMENT to get the XML or if you know the payment instruction ID, then you can query by payment instruction ID.

Since the column DOCUMENT is CLOB column, your TOAD may not show this column value. In my case I used SQLDEVELOPER to get the value of this column.

Good luck. Here is the query,

SELECT DOCUMENT
FROM IBY_TRXN_DOCUMENTS
WHERE PAYMENT_INSTRUCTION_ID = :P_PAYMENT_INSTRUCTION_ID;