My Oracle Support Banner

R12: CE/ECC: When Trying to Reconcile Transactions, Error: "Reconciliation Process FailedApplication" (Doc ID 3010536.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.


When trying to reconcile transactions using Cash Management (CE) command center, the following error occurs:

Reconciliation process failedApplication: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("AR"."AR_CASH_RECEIPT_HISTORY_ALL"."TRX_DATE") ORA-06512: at "APPS.CE_AUTO_BANK_CLEAR1", line 2884 ORA-06512: at "APPS.ARP_CASHBOOK", line 1085 ORA-06512: at "APPS.ARP_CR_HISTORY_PKG", line 423 ORA-06512: at "APPS.ARP_CR_HISTORY_PKG", line 283 ORA-06512: at "APPS.ARP_CASHBOOK", line 563 ORA-06512: at "APPS.CE_AUTO_BANK_CLEAR1", line 2816 ORA-06512: at "APPS.CE_AUTO_BANK_CLEAR", line 928 ORA-06512: at "APPS.CE_ECC_MANUAL_RECON", line 944 ORA-06512: at "APPS.CE_ECC_MANUAL_RECON_W", line 385 ORA-06512: at line 1 ;


Steps to reproduce:

1. Navigate to Cash Management Manager

2. Open CE command center

3. To to available transactions

4. Try to reconcile transactions


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.