You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

cancelled invoice appearing in supplier balance

Hi Team,

We are facing issue with the Supplier Balance Aging Report. Customer created two payable invoices (INVOICE_1 and INVOICE_2) in August 2025, both were cancelled in November 2025. When running the Supplier Balance Aging Report as of 30-Sep-2025, INVOICE_1 appears in the report, but INVOICE_2 does not. 

We have tried to check the logic for canceled invoices in the report, which uses the temporary table (ap_invoice_aging_gt) and the package (AP_APINVAGE_XMLP_PKG) to retrieve data. We also checked the ALL_SOURCE table to see the logic inside the package but could not find any relevant details there. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!