RECONCILE NETTED SETTLEMENT AGAINST A LINE ERRORS AVAILABLE_EVENT.UPDATE_ROW PRO
(Doc ID 1363740.1)
Last updated on OCTOBER 18, 2021
Applies to:
Oracle Treasury - Version 12.1.2 to 12.2.8 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
When attempting to reconcile from Open Interface Netted Treasury Settlement Transaction following Error occurs:
AVAILABLE_EVENT.update_row procedure raised unhandled exception
ORA-01403: no data found
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01403.
STEPS:
The issue can be reproduced at will with the following steps:
1. Navigate to the Bank Statement Lines window put cursor on Receipt Type line and click Available.
2. In the Available Transactions window:
a. select Open Interface
b. Check Receipt (M) and Payment (Q)
c. Click on Find
3. Select transaction of Cash Type, click Reconcile and the error appears.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot reconcile Netted Treasury Settlement Transaction.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |