My Oracle Support Banner

R12 Autoreconiliation Program ends in error ORA-01722: invalid number ORA-06512 APPS.CE_AUTO_BANK_REC (Doc ID 1511196.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


In Oracle Cash management 12.1.3

Patched environment with latest recommended patches from AUG-12.

The Autoreconciliation program is ending in error as a result of a space in the Statement Line Transaction Number.
Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.CE_AUTO_BANK_REC", line 508
ORA-06512: at line 1

Statement on Non Patched Environment
 AutoReconciliation completes ok
 Statement on Patched Environment
 AutoReconciliation completes in Error

This issue does not occur in an environment where Cash Management Recommended Patch Collection AUG-2012 patch has not been applied.


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
 Patch Wizard
 Have more questions?

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