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 OCTOBER 28, 2024

Applies to:

Symptoms

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

Changes

Cause

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