My Oracle Support Banner

R12: AP/XLA: Generic Data Fix (GDF) Patch 30080042 to Delete Orphan Records in XLA Tables for Payables (Doc ID 788135.1)

Last updated on DECEMBER 07, 2023

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Oracle Payables - Version 12.2.5 to 12.2.5 [Release 12.2]
Oracle Payables - Version 12.2.6 to 12.2.6 [Release 12.2]
Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.


The Period Close Exception Report shows events that are holding up the close, but aren't attached to any transactions.
These Orphan transactions must be removed to allow period close.

To close a period

  1. From a Payables responsibility navigate to "Accounting" -> "Control Payables Periods"
  2. Enter in a ledger name at the prompt
  3. Click "Find"
  4. Scroll to the period in question
  5. Change the Period Status to "Closed"
  6. Click "Save"
  7. If there are any transactions blocking the close you will receive a "APP-SQLAP-10304: You cannot close this period because exceptions exist."
  8. Click "OK"
  9. Click "Exceptions"
  10. Click "Review"
  11. A message giving the concurrent request_id submitted will appear
  12. Click "OK"
  13. Click on "View" -> "Requests"
  14. Click "Find"
  15. Select the row with the request_id given
  16. Click "View Output"
  17. Orphans will show under the "Other Exceptions" section


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

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