Useful AP disgnostic scripts

[admin]

The following metalink document contains very useful scripts for AP module.

Subject: Payables Data Collection Test
Doc ID: Note:148388.1 Type: SCRIPT
Last Revision Date: 06-MAR-2007 Status: PUBLISHED

Oracle Payables

Payables Data Collection Test

Purpose
The read-only diagnostic script displays in a tabular format all the invoice information, including related prepayment, payment, and PO information along with accounting information and GL Details.

The script can be run using the eBusiness Oracle Diagnostics Framework or a standalone script run via sql.

To download the Standalone, please download the following ZIP file that contains:

APListh.sql (HTML version 1.20)
APListt.sql (Text version 1.20)
CoreApiHtml.sql (version 1.27)
CoreApiTxt.sql (version 1.25)
APList_readme.txt CR: 284760