My Oracle Support Banner

R12:CE: How to Cancel Duplicate Cash Flows for a Specific Cashflow_Bank_Account_Id? (Doc ID 2945166.1)

Last updated on JUNE 06, 2023

Applies to:

Oracle Cash Management - Version 12 and later
Information in this document applies to any platform.

Goal

Need to cancel or remove duplicate Cash Flows for a specific cashflow_bank_account_id that shows CASHFLOW_STATUS_CODE = 'CREATED' when there is another cash flow with CASHFLOW_STATUS_CODE = 'RECONCILED'. Both transactions have the same TRXN_REFERENCE_NUMBER in ce_cashflows table.

Note:

The duplicate cash flows should not be accounted neither reconciled.

However, the Status of the CE_CASHFLOW_ACCT_H showing ACCOUNTED is ok if the associated Event is set to EVENT_STATUS_CODE = N and PROCESS_STATUS_CODE = P.

 

 

Solution

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