Patch Application Error: Applying Patch 6678700 Fails ibeorgtb.sql and arorgdef.sql with ORA-01722: invalid number (Doc ID 1541809.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Upgrading our 11.5.10.2 environment to 12.1.1. Upgrade <Patch 6678700> Is Failing for ibeorgtb.sql & arorgdef.sql with the following error:



  FAILED: file ibeorgtb.sql on worker 2.
  FAILED: file arorgdef.sql on worker 5.

From worker logs

sqlplus -s APPS/***** @/opt/applmgr/ebsbox/apps/apps_st/appl/ar/12.0.0/patch/115/sql/arorgdef.sql &un_ar &pw_ar
Connected.
modify (org_id default to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10))))
  *
ERROR at line 2:
ORA-01722: invalid number

sqlplus -s APPS/***** @/opt/applmgr/ebsbox/apps/apps_st/appl/ibe/12.0.0/patch/115/sql/ibeorgtb.sql &un_ibe &pw_ibe
Connected.
modify (org_id default to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10))))
  *
ERROR at line 2:
ORA-01722: invalid number



Due to this issue, you cannot complete the upgrade process.

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