AR_00103 Receipts Workbench: Posted Event is Missing in XLA_EVENTS for Receipts - The Data is Present in XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS and also in GL tables (Doc ID 1530612.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

Posted event is missing in xla_events for receipts.

Analysis
=========
Reviewed the data for the receipt and found the following.

a) The receipt is created in REMITTED status.
b) The receipt is applied to an invoice.
c) The receipt is posted to GL.

RA_ID              AMT_APP           STATUS            EVENT_ID
=========================================
26280             154800              UNAPP             3457900

Reviewed the data for the receipt and found that it is posted to GL.

Reviewed the data for EVENT_ID 3457900 and found the event is not present in XLA_EVENTS.
The data is present in XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS and also in GL tables.

It seems as though the data in XLA_EVENTS have been deleted.

The receipt also has duplicate entities.

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