Evaluation Context Objects Are Invalid
Sign in

Evaluation Context Objects are Invalid

Following DB objects of type Evaluation Context are invalid.

 

AQ$_WF_NOTIFICATION_OUT_V
AQ$_WF_JAVA_DEFERRED_V
AQ$_WF_ERROR_V
AQ$_WF_DEFERRED_V

AQ$_WF_JAVA_ERROR_V

 

Sol:

1. Connect as applsys
connect applsys/<password>

-- This step should validate the evaluation context
exec dbms_rule_adm.create_rule_set('TEST','<evaluation context name>');

-- After using the test rule set, drop it
exec dbms_rule_adm.drop_rule_set('TEST');

Apply the same commands for every invalid evaluation context's

2. Verify if the evaluation contexts are valid
select object_name, object_type, owner, status
from dba_objects
wherew status = 'INVALID'
and object_type = 'EVALUATION CONTEXT';

prevnew
start_blog_img