u6678700.drv: FAILED: file cskbctxp.sql

Action Plan to avoid cskbctxp.sql job issue:

Issue:

declare
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 45

Cause:

Below objects were missing :

SQL>select owner,object_name,object_type,last_ddl_time,status from dba_objects
where object_name like upper('%cs_kb_f_ctx_pkg%');

Solution:

To implement the solution, please execute the following steps:

Run the following sql to create the missing objects

sqlplus apps/paswd @$CS_TOP/patch/115/sql/cskfctxs.pls APPS
sqlplus apps/paswd @$CS_TOP/patch/115/sql/cskfctxb.pls APPS

Restart the failed Worker using the adctrl utility in a second Shell session and continue.