Compare error “Oracle Error 4063: ORA-04063: package body "OWNER. SP_DEQ_PKG" has errors” (4296975)

The following errors are observed in desvr log when compare failed:

desvr    2018-06-20 13:01:10.216266 19202946 258 [1] Oracle Error 4063: ORA-04063: package body "OWNER.SP_DEQ_PKG" has errors

desvr    2018-06-20 13:01:10.216266 19202946 258 [1]

desvr    2018-06-20 13:01:10.235355 19202946 258 [1] Error 4063 calling OCIStmtExecute (de_select_prepare_to_fetch,L1418)

desvr    2018-06-20 13:01:10.236408 19202946 258 [1] Error 1 calling de_select_prepare_to_fetch in de_batch_setup

desvr    2018-06-20 13:01:10.241470 19202946 258 [1]

Furthermore, when attempting to manually recompile the package in the database, the folloiwng errors are observed (shown here is the partial output):

SQL> alter package SP_DEQ_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY SP_DEQ_PKG:

LINE/COL ERROR

-------- -----------------------------------------------------------------

12/6 PL/SQL: SQL Statement ignored

12/13 PL/SQL: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier

60/21 PL/SQL: Item ignored

60/31 PLS-00201: identifier 'DBMS_LOB' must be declared

74/7 PL/SQL: Statement ignored

74/14 PLS-00320: the declaration of the type of this expression is

incomplete or malformed

79/7 PL/SQL: Statement ignored

79/20 PLS-00320: the declaration of the type of this expression is

incomplete or malformed

LINE/COL ERROR

-------- -----------------------------------------------------------------

95/7 PL/SQL: Statement ignored

95/36 PLS-00320: the declaration of the type of this expression is

incomplete or malformed

117/7 PL/SQL: SQL Statement ignored

117/14 PL/SQL: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier

133/21 PL/SQL: Item ignored

133/31 PLS-00201: identifier 'DBMS_LOB' must be declared

146/7 PL/SQL: Statement ignored

....