R12:AP: Cancelled Invoice With Event Status Marked As NP Appears In Period Closure Exception Report (Doc ID 2978647.1)

Last updated on OCTOBER 04, 2023

Applies to:

Symptoms

The Period Close Exception Report shows the cancelled invoice events which is already marked as N and P 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.