My Oracle Support Banner

R12: XTR: Treasury Settlements AutoReconciliation Open Interface Transactions, By Date And Amount And Transaction Number (Doc ID 1287525.1)

Last updated on JULY 10, 2020

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.


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

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


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

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