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

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

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.

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