R12: AP: SQL to extract information related to invoice (Doc ID 2364232.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Goal

In EBS R12, by using Diagnostic Tools,
A function to collect various data collectively is provided.

Note "R12.0.6+ : Oracle Payables Invoice Data Data Collection Test" (Doc ID 732163.1)
Note "EBS Payables Invoice and EBTax Analyzer" (Doc ID 1529429.1)

Data can be effectively extracted using the diagnostic tool.
However, if you are unable to use it for some reason, please extract the data of the target transaction using the SQL in this Note.

The SQL below is the EBS standard SQL used in the diagnostic tool.
By referring to this SQL concatenation condition, you can check the relation between tables and the WHERE condition necessary for data extraction.

Please also use SQL of this Note to understand the structure between tables.

11i has the following script
Standalone APList - Payables Data Collection Test (Doc ID 148388.1)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.