Invalid Package CSI_MASS_EDIT_PUB After Applied Patch 14772562:R12.CSI.B (Doc ID 1522014.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 12.1.3 version, Support Codes

After applied patch 14772562:R12.CSI.B recieved invalid package CSI_MASS_EDIT_PUB
with the following error

ERROR
-----------------------
334/4 PL/SQL: SQL Statement ignored
336/44 PL/SQL: ORA-00942: table or view does not exist
3027/3 PL/SQL: SQL Statement ignored
3027/10 PL/SQL: ORA-00942: table or view does not exist
3049/2 PL/SQL: SQL Statement ignored
3050/7 PL/SQL: ORA-00942: table or view does not exist
3054/2 PL/SQL: SQL Statement ignored
3055/7 PL/SQL: ORA-00942: table or view does not exist
3152/12 PLS-00341: declaration of cursor 'INSTANCES_FOR_CREATE_CSR' is
  incomplete or malformed


LINE/COL ERROR
-------- -----------------------------------------------------------------
3153/3 PL/SQL: SQL Statement ignored
3275/8 PL/SQL: ORA-00942: table or view does not exist
3288/26 PL/SQL: Item ignored
3296/20 PL/SQL: Item ignored
3296/34 PLS-00302: component 'K_COV_LINE_TBL' must be declared
3353/3 PL/SQL: Statement ignored
3353/6 PLS-00364: loop index variable 'L_INSTANCE' use is invalid
3365/3 PL/SQL: Statement ignored
3365/6 PLS-00364: loop index variable 'L_INSTANCE' use is invalid
3377/3 PL/SQL: Statement ignored
3377/6 PLS-00364: loop index variable 'L_INSTANCE' use is invalid


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Applied patch 14772562:R12.CSI.B

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.