Patch 14052234: 11i - Causes CE_BANK_STATEMENT_LOADER to Become Invalid
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
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:
0