EAR9.2: Unpost Payment or Maintenance Worksheet is Running in Budget Status Error With Exception E97. (Doc ID 1991145.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Symptoms

On : 9.2 version, Revenue Est & Commit Cntrl

ACTUAL BEHAVIOR
---------------
Unposting a Payment or Maintenance Worksheet is running in budget status Error with exception E97 (Budget Definition not Found).
As a result of this the Collected Revenue is not reversed and journal generator is not generating journals for Unpost transactions.

EXPECTED BEHAVIOR
-----------------------
Unposting a Payment or Maintenance Worksheet should not be running in budget status Error with exception E97 (Budget Definition not Found).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Enable commitment control for Billing, General Ledger and Receivables.
2. Make sure Fund Code is set to Always Inherit for Inheritance Group 'Receivables and Billing'.
3. For the Ledger Group used make sure to enable 'IntraUnit Balancing Entries' and make Fund Code a balanced chartfield.
4. Open Budget Definition for revenue and make sure Control Option = Track w/o Budget. Account, Department and Fund Code are required chartfields.
5. Open the Receivables Options, enable ‘Synchronize Budget Date’ and disable ‘Budget Date Override’.
6. Enter and post a budget journal for the revenue budget..
7. Create a new bill for just 1 line.
8. Enter Rev Distribution for Account, Department and Fund Code (same as budget).
9. Enter AR Offset.
10. Change status to RDY and save changes.
11. Run Finalize and Print Invoices.
12. Run Load Invoices to AR.
13. Run Create Accounting Entries.
14. Run Request Budget Check.
15. Verify Recognized Revenue is updated.
16. Run AR_UPDATE to post item.
17. Create a regular deposit.
18. Build payment worksheet.
19. Apply Payment.
20. Run AR_UPDATE.
21. Verify item is closed.
22. Verify Collected Revenue is updated.
23. Navigate to Accounts Receivable > Receivables Update > Unpost Groups > Payment Group and Unpost payment.
24. Run AR_UPDATE.
25. Collected Revenue is NOT reversed! This is wrong.
26. Navigate to Accounts Receivable > Receivables Update > Revenue Estimates > Review Transactions by Item.
    • Unpost transaction is running in Budget Status Error. PS_KK_EXCPTN_TBL.EXCPTN_TYPE = E97.
27. Navigate to Commitment Control > Review Budget Check Exceptions > Revenues > Revenue Estimate. Budget Exception is ‘Budget Definition not Found’.
28. The source of the problem is in PS_AR_CC_TRAN_TBL where BUDGET_DT is blank for all Unpost transactions.
    • When BUDGET_DT is blank, all transactions will run into budget error E97 (Budget Definition not Found).
    • Journal generator is not able to generate journals if the commitment control transaction is in Error.
29. Run journal generator for Billing. Journal is generated and posted.
30. Run journal generator for AR_PAYMENT. Journal is generated and posted.
31. Run journal generator for AR_MAINT (this is the Unpost). 0 Journals created. Journal generator is not able to generate journals if the commitment control transaction is in Error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Collected Revenue is incorrect and users are not able to generate and post journal for the Unpost transaction.

Cause

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