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 JUNE 21, 2023
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.
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