Upgrade Script ar120lccpa.sql Failing With ORA-01722: Invalid Number (Doc ID 1567200.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Attempting to run the upgrade script ar120lccpa.sql and receive the following error:

ERROR
-----------------------
sqlplus -s APPS/***** @/tupo3i/apps/apps/apps_st/appl/ar/12.0.0/patch/115/sql/ar120lccpa.sql &un_ar &batchsize 1 16

DECLARE
*
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at line 26

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