Ad_zd and wf_event valid but still shows invalid ot dropped

Posted by Mohsin Patel on Oct 12, 2021; 5:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Ad-zd-and-wf-event-valid-but-still-shows-invalid-ot-dropped-tp10344.html

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