R12: AP: SQL to extract information related to invoice

(Doc ID 2364232.1)

Last updated on MARCH 08, 2018

Applies to:

Oracle Payables - Version 12.1.0 and later
Information in this document applies to any platform.

Goal

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

Note 732163.1 - R12.0.6+ : Oracle Payables Invoice Data Data Collection Test
Note 1677861.1 - How to Use the XML Version of the Payables APList [VIDEO]

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms