How to fix the Oracle error ORA-41664: invalid consumption policy for the primitive event?

In this post, you’ll learn more about the Oracle ErrorORA-41664: invalid consumption policy for the primitive event with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-41664: invalid consumption policy for the primitive event

Reason for the Error ORA-41664: invalid consumption policy for the primitive event

An attempt was made to use EXCLUSIVE consumption policy for a primitive event when the composite event is configured for RULE consumption policy.

How to fix the Error ORA-41664: invalid consumption policy for the primitive event ?

You can fix this error in Oracle by following the below steps

Correct the rule class properties and try again.