RECONCILE NETTED SETTLEMENT AGAINST A LINE ERRORS AVAILABLE_EVENT.UPDATE_ROW PRO
(Doc ID 1363740.1)
Last updated on JULY 10, 2020
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.
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.
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.
The issue has the following business impact:
Due to this issue, users cannot reconcile Netted Treasury Settlement Transaction.
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