R12: AP: SQL to extract information related to invoice
(Doc ID 2364232.1)
Last updated on JUNE 27, 2019
Applies to:Oracle Payables - Version 12.1.0 and later
Information in this document applies to any platform.
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document