Payables and Cash Management - EBS (MOSC)

MOSC Banner

Invoices and XLA_EVENTS

edited Apr 26, 2018 5:10AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Due to space constraints, and Oracle having no purge process, we had to clear out space in the XLA tables. Unfortunately we went a little overboard and cleared out too many records in the XLA_EVENTS table. While we've been recovering the table, AP continues working.  We have found a handful of records in the XLA_EVENTS table where there are two distinct EVENT_IDs that point to the same invoice distribution.

My theory is that the (much) lower numbered EVENT_ID was the original ID and has been restored now.  But while it was missing, create accounting managed to create a new EVENT_ID for the distribution. In order to fix this we would need to start by copying the differing information (EVENT_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE and REQUEST_ID) from the newer record into the original, recovered record. Once completed we would need to delete the newer record.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center