Invoices and XLA_EVENTS
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.