My Oracle Support Banner

Latest: Treasury Settmenets AutoReconciliation Open Interface Transactions, By Date And Amount And Transaction Number (Doc ID 1287525.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms


1.  Not possible to reconcile the open interface transactions by date and amount, even though bank account configuration and transactions have the criteria to reconcile by Date and Amount.
1). If the Bank account is enabled for Treasury Use and
2). Setups at Bank account as: Treasury enabled, DATE AND AMOUNT Match for
Open Interface
3). Then It fails to Match based on DATE AND AMOUNT with Open Interface
Transactions:FROM CE.CE_999_TRANSACTIONS_V.

2. Treasury transactions were not getting auto-reconciled as they were failing with an error 'Duplicate Open Interface transactions' even though they were not duplicates.
3. When you try to Reconcile a Treasury Settlement you get:
AVAILABLE_EVENT.update_row procedure raised unhandled exception
 ORA-01403 : no data found
 FRM-40735 : ON-UPDATE trigger raised unhandled exception ORA-00604

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.