AR GDF: AR_DFS_RCT_UNAPP_APP_DIFF_EV.sql AR_00258 Subledger Accounting: Subledger Period Close Exceptions Report Shows Unprocessed Receipt Events (Doc ID 1550723.1)

Last updated on JUNE 06, 2022

Applies to:

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

Symptoms

BEST PRACTICES:

Run the Receivables Period Close Analyzer before closing the period to proactively identify this issue, as well as many other issues that will prevent you from closing the period.
If you post to multiple EBS subledgers, use the EBS Period Close Process Analyzer for a smoother period close.

Receipt Applications are created with different event_id's preventing them from being accounted.
For example the UNAPP row in AR_RECEIVABLE_APPLICATIONS_ALL has different EVENT_ID than corresponding APP row.
Due to this issue, the Create Accounting won't process UNAPP row and cause issue while closing the period.
UNAPP event_id is not picked and processed by Create Accounting leaving it as Unposted / Unprocessed.
Due to it, period cannot be closed as there are unposted data.

It happens when the receipt create event is locked by create accounting and at the same time user is trying to apply/unapply the Invoice, system is generating two different events against APP-UNAPP row.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a Receipt and run Accounting.
2) At the same time ,apply and unapply transactions from Receipts.