R12 Autoreconiliation Program ends in error ORA-01722: invalid number ORA-06512 APPS.CE_AUTO_BANK_REC
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.
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.
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