Latest: Treasury Settmenets AutoReconciliation Open Interface Transactions, By Date And Amount And Transaction Number

(Doc ID 1287525.1)

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms