Useful AP disgnostic scripts
Posted: Thu Mar 15, 2007 10:19 am
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
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