Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Upgrade Patch 6678700 Is Failing for ibeorgtb.sql & arorgdef.sql

edited Nov 21, 2012 3:07AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

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))))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center