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
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