Ad_zd and wf_event valid but still shows invalid ot dropped

[Mohsin Patel]

Hi Emran

We need your help. This is PROD and we are getting the below error and all the WF Service Components are down right now. They dont start or dont stop either. All objects are valid.

SQL> begin
wf_event.listen(p_agent_name => 'WF_DEFERRED');
end;
  2    3    4  /
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped package body "APPS.AD_ZD"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD"
ORA-06512: at "APPS.WF_EVENT", line 1605
ORA-06512: at "APPS.WF_EVENT", line 1209
ORA-06512: at line 2


SQL> select owner,object_name,object_type from dba_objects where object_name in ('WF_EVENT','WF_BES_CLEANUP','AD_ZD');

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------ ------------------------------
APPS                 AD_ZD                          PACKAGE
APPS                 AD_ZD                          PACKAGE BODY
APPS                 WF_BES_CLEANUP                 PACKAGE
APPS                 WF_BES_CLEANUP                 PACKAGE BODY
APPS                 WF_EVENT                       PACKAGE
APPS                 WF_EVENT                       PACKAGE BODY

6 rows selected.

Please help Emran Sir

Regards
Mohsin

[ErmanArslansOracleBlog]

ORA-04068 can be a result of compilation. It may be an expected behaviour in specific cases.
I mean, in most cases incidences of ORA-4068 and its associated errors are correct,

Read the following for further details ->

Troubleshooting PL/SQL Program Unit Invalidation Related Errors (e.g. ORA-4068, ORA-4065, ORA-6508, PLS-907) (Doc ID 2298084.1

Are those objects valid? Those objects that you see in the Oracle error stack, I mean.

If they are valid; since this is workflow related, you may need to bounce the Workflow Containers..
If this action doesn't solve the issue, bounce the database.

Additional reference : Workflow Services Getting Down (Doc ID 2697359.1)

Additional reference : http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-04068-existing-state-of-packages-has-been-discarded-td7030.html