R12 Generic Data Fix (GDF) Patch 17956201 - Delete Unprocessed Budgetary Accounting Events Hindering Payables Period Closure (Doc ID 985228.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Some unprocessed Budgetary Accounting Events exists in the system which would prevent period closure. The affected invoices would be listed as Unaccounted.
Reversal Pairs in the Invoice Distributions, both of which have not been encumbered, but at least one of them has a BC event stamped.

Steps to reproduce:

1. Log into Oracle applications using a Payables responsibility.
2. Open the Invoice Workbench
   (N) Invoices > Entry > Invoice
   
3. Create a Payables Invoice in Encumbrance Subledger Accounting Method.
   
4. Validate and account the invoice
   
5. The following <Note> occurs:
   "Online accounting could not be created for this transaction. Please inform your system administrator that the Create Accounting program has encountered an internal error."
6. The invoice distributions which have been approved, is marked as Encumbered but the corresponding BC event has not been Accounted
7. Next, discard an invoice line
8. From a Payables responsibility navigate to "Accounting" -> "Control Payables Periods"
9. Enter in a ledger name at the prompt
10. Click "Find"
11. Scroll to the period in question
12. Change the Period Status to "Closed"
13. Click "Save"
14. If there are any transactions blocking the close you will receive a "APP-SQLAP-10304: You cannot close this period because exceptions exist."
15. Click "OK"
16. Click "Exceptions"
17. Click "Review"
18. A message giving the concurrent request_id submitted will appear
19. Click "OK"
20. Click on "View" -> "Requests"
21. Click "Find"
22. Select the row with the request_id given
23. Click "View Output"
24. The invoice is reported under "Unaccounted Invoices" 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.