XML Output for AP Check Payments in R12

XML Output for AP Check Payments is part of the log file of Format Payment concurrent Program. Usually we look at the log file and use the XML tags from the log file. When the volume of payments made are high, the XML tags are truncated in the log file. So you wont be able to get the entire XML tags. So how do we get it??

IBY_TRXN_DOCUMENTS Table stores the XML generated during the Format Payment Instruction program. The following SQL Statement can be used to get the XML output.

[sql]

SELECT   document
  FROM   iby_trxn_documents
WHERE payment_instruction_id = :l_payment_inst_id;

[/sql]

You can open the output in TOAD / SQL Developer.

The XML output can be used for various purposes. You can use it for debugging or developing and testing check printing program.