My Oracle Support Banner

Transactions Workbench: Orphan Records in XLA Tables When Deleting Incomplete Invoice With Rules (Doc ID 731392.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Receivables - Version 12.0.5 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.


Attempting to delete Invoices created with rules and find orphan records in the XLA_EVENTS table.

Responsibility:  Receivables Manager
Navigation: Transactions > Transactions
Enter in Header of Invoice with Rules and ensure that you use LOV from invoicing rule (Advance or Arrears) and save.  
Delete the invoice that was just created.

With the latest code, when a Transactions with Rules (Advanced or Arrears) is deleted only, the XLA_EVENTS table reference is not removed causing orphan records within the table.

Unable to close period when you have orphan records in xla_events table.


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
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.