OracleAppsDNA

XML Data of AP Check Payments – Format Payments Instructions in R12

Generally after running Payment Process Request, we can get the XML data in the log file of ‘Format Payment Instructions with Text Output’ using which we can develop/debug the rtf/eText template using XML Publisher.

Not only in the log file but also the XML data is stored in IBY_TRXN_DOCUMENTS table.

Below is the SQL Statement can be used to get the XML output.

SELECT   document
  FROM   iby_trxn_documents
 WHERE   payment_instruction_id = :l_payment_inst_id;
 
Exit mobile version