Upgrade Patch 6678700 Is Failing for ibeorgtb.sql & arorgdef.sql
Hi,
Upgrade Patch 6678700 Is Failing for ibeorgtb.sql & arorgdef.sql
Upgrading our 11.5.10.2 environment to
12.1.1. Upgrade Patch 6678700 Is Failing for ibeorgtb.sql &
arorgdef.sql. Below is the error.
FAILED: file ibeorgtb.sql on worker 2.
FAILED: file arorgdef.sql on worker 5.
From worker logs
sqlplus -s APPS/***** @APPL_TOP/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/***** @/oAPPL_TOP/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))))