My Oracle Support Banner

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.

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


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