My Oracle Support Banner

R12: AP: When Accounting For Payment Receive The Following Error 0 This Line Cannot Be Accounted Until The Accounting Event That It References Has Been Fully Accounted For Payment (Doc ID 2377240.1)

Last updated on JUNE 21, 2023

Applies to:

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


When it is trying to run Create accounting for Check the following error occurs:

Error Code: 0, Error message: This line cannot be accounted until the accounting event that it references has been fully accounted. Please ensure the accounting events for the transaction with the following identifiers for the application Payables have been accounted: invoice_id: xxxxx


When attempting to account the invoice, the following error occurs.

APP-SQLAP-10000: occurred in Inv_Sum_Actions_Account.accnt_final_post with parameters (&PARAMETERS) while performing the following operation: &DEBUG_INFO


The following SQL returns records for the Invoice_ID mentioned in the error messages


The issue can be reproduced at will with the following steps:
1. Responsibility Payables Manager
2. Navigation: Menu > View > Requests > Submit a New Request... > Single Request
3. Select from List of Values (LOV) > Create Accounting program
4. Provide the End Date parameter > [B] Submit
5. Notice that transaction (invoice or payment) is not accounted.




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

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