GLXIQFUN Funds Inquiry Form Does Not Reflect Journal That Has Funds Reserved. Unreserve Errors: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403 (Doc ID 2138392.1)

Last updated on NOVEMBER 25, 2024

Applies to:

Symptoms

ERROR
-----------------------
Unreserving the Journal Batch produces the following error:

CONTROL.unreserve_funds procedure raised unhandled exception
--------------------------------------------------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403.

STEPS
--------
1. Go to General Ledger responsibility
2. Navigate to Journals > Enter
3. Create one journal entry and check funds. Funds Passed
4. The Second journal entry with some funding lines from the first journal entry has insufficient funds
5. Using a Funds Override responsibility , override funds in the second journal.
6. Verify both first and second journal.
7. Using Funds override responsibility, unreserve the first journal.
It has status funds required and no GL BC Packets record.
For the second journal the status is Funds Passed but no records in GL BC Packets.
8. Try to unreserve.
9. The error occurs.

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.