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

MOSC Banner

Patch 14052234: 11i - Causes CE_BANK_STATEMENT_LOADER to Become Invalid

edited Apr 25, 2013 7:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 9 commentsAnswered ✓
Hi,
Ran adadmin, which ended in error. Please find below the error message.

OWNER
==============================
OBJECT_NAME
================================================================================================================================
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE         CREATED         LAST_DDL_TIME   TIMESTAMP           STATUS  T G S
============================== ========== ============== =================== =============== =============== =================== ======= = = =
APPS
CE_BANK_STATEMENT_LOADER
                                  133994                PACKAGE             22=DEC=01       17=AUG=08       2005=03=26:14:03:57 VALID   N N N

APPS
CE_BANK_STATEMENT_LOADER
                                  147064                PACKAGE BODY        22=DEC=01       24=APR=13       2013=04=24:12:46:55 INVALID N N N

SQL> show error
Errors for PACKAGE BODY APPS.CE_BANK_STATEMENT_LOADER:

LINE/COL ERROR
======== =================================================================
1779/2   PL/SQL: Statement ignored
1779/12  PLS=00201: identifier 'G_LAST_VAL1' must be declared
1787/2   PL/SQL: Statement ignored
1787/12  PLS=00201: identifier 'G_LAST_VAL1' must be declared
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