Symptoms
US_czsdrule_ldt.log shows below error
CURRENT SESSION_ID is : 670165893
CURRENT EDITION_NAME is : ORA$BASE
Uploading from the data file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdrule.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsdrule.lct(120.6.12020000.1), /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdrule.ldt) to staging tables
Dumping LCT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsdrule.lct(120.6.12020000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdrule.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (CZ_RULES 1 , CZ_RULES 999 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error during uploading. ORA-06550: line 431, column 15:
PL/SQL: ORA-04098: trigger ‘APPS.CZ_RULES_T2′ is invalid and failed re-validation
US_czsdxpnd_ldt.log shows below error CURRENT SESSION_ID is : 670165896
CURRENT EDITION_NAME is : ORA$BASE
Uploading from the data file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdxpnd.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsdxpnd.lct(120.2.12020000.1), /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdxpnd.ldt) to staging tables
Dumping LCT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsdxpnd.lct(120.2.12020000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsdxpnd.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (CZ_EXPRESSION_NODES 16 , CZ_EXPRESSION_NODES 502 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error during uploading. ORA-06550: line 358, column 24:
PL/SQL: ORA-04098: trigger ‘APPS.CZ_EXPRESSION_NODES_T2′ is invalid and failed re-validation
US_czsduitl_ldt shows below error.
CURRENT SESSION_ID is : 670165894
CURRENT EDITION_NAME is : ORA$BASE
Uploading from the data file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsduitl.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsduitl.lct(120.3.12020000.1), /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsduitl.ldt) to staging tables
Dumping LCT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/czsduitl.lct(120.3.12020000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/cz/12.0.0/patch/115/import/US/czsduitl.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (CZ_UI_TEMPLATES 1 0 , CZ_UI_TEMPLATES 200101 0 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error during uploading. ORA-06550: line 257, column 15: PL/SQL: ORA-04098: trigger ‘APPS.CZ_UI_CONT_TYPE_TEMPLS_T2′ is invalid and failed re-validation
Solution:
1.Execute below commands
sqlplus apps
SQL> drop trigger CZ_RULES_T2;
SQL> drop trigger CZ_EXPRESSION_NODES_T2;
SQL> drop trigger CZ_UI_CONT_TYPE_TEMPLS_T2;
SQL> @$CZ_TOP/patch/115/sql/cztrigs2.sql
2. Validate if above triggers are valid:
SQL>select OWNER,OBJECT_NAME,OBJECT_TYPE,status from all_objects where OBJECT_NAME like ‘&a’;
CZ_RULES_T2
CZ_UI_CONT_TYPE_TEMPLS_T2
CZ_EXPRESSION_NODES_T2
3. Restart failed workers using adctrl Option 2 Tell worker to restart a failed job
Metalink Reference:
Patch 31856789 fails at czsdxpnd.ldt, czsdrule.ldt and czsduitl.ldt, Unable to Compile CZ% Invalid Objects After Database Upgrade ( Doc ID 2930404.1 )
Orama.blog 