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
Last updated on FEBRUARY 07, 2018
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Posted event is missing in xla_events for receipts.
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.
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