Wednesday, February 3, 2016

APList - Payables Invoice Data Collection Test

When users open a SR with Oracle Support for data issue, they frequently ask for APList report. Really, it is a standard diagnostic test in R12 Payables (SQLAP). It gets the name maybe because its back-end xml file is called APListXml.xml. I copy steps from Doc ID 732163.1 here to skip logging into Oracle Support website each time when need it:
  1. Log onto Oracle E-Business Suite
  2. Connect to responsibility Application Diagnostics
  3. Select the Diagnose menu option
  4. Click button Select Application and select Application "Payables"
  5. Scroll down to group "Invoice"
  6. Select test name "Invoice Data", then click on EXECUTE on the bottom
  7. Input Parameters (* required)
    • Responsibility Id (LOV) *    <== grant a super user resp. to yourself first if you do not see one on the LOV
    • Search Criteria (LOV)  
    • Supplier Name (LOV)  
    • Invoice Id (LOV) *  
    • Include GL Tables (Yes or No) (LOV)  
    • Include Related Data (Yes or No) (LOV)  
    • Max Rows Displayed

No comments: