R12:AP Error 0 This Line Cannot Be Accounted Until The Accounting Event That It References Has Been Fully Accounted For Payment - Data Fix For AID_EVENT_MISSING_IN_XE.SQL

(Doc ID 2377240.1)

Last updated on APRIL 04, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Accounting Issues in AP
On: Instance PROD

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

EXPECTED BEHAVIOR
-----------------------
0
  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

STEPS
-----------------------
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 payment is not accounted.



Changes

 

Cause

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