My Oracle Support Banner

Accounting Error: Reversed Receipts fails Accounting Program (XLAACCUP ) with error: The following REVERSAL events could not be processed (Doc ID 1073836.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:XLAACCPB - Create Accounting
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE: XLAACCUP - Accounting Program
Report: ARXRECON.RDF - AR Reconciliation


Symptoms

Unable to close a period due to 2 unprocessed reversal receipts showing on XLAACCUP - Accounting Program log file.

Here is an example:

*****************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
Event 84731 of ledger 2021
Event 84430 of ledger 2021
*****************************************************************



Review of the problem receipts show the following:

  1. Receipt payment schedule shows actual_date_closed and gl_date_closed are incorrect for receipt
  2. Review of receipt shows reversal row in AR_CASH_RECEIPT_HISTORY_ALL.gl_date is less then the maximum application gl_date (AR_RECEIVABLE_APPLICATIONS_ALL.gl_date)
  3. Review of receipt shows reversal row in AR_CASH_RECEIPT_HISTORY_ALL.trx_date is less then the maximum application apply_date (AR_RECEIVABLE_APPLICATIONS_ALL.apply_date)
  4. Review of xla_events.EVENT_TYPE_CODE shows duplicate RECP_REVERSE  and one of the events is posted.

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
 5. Datafix
 Feedback
References


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