Database Objects (RULE SET) In RIB AQ Database Become Invalid (Doc ID 1300869.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

Some of the Database Objects (DBA_OBJECTS) of type RULE SET come up with 'INVALID' status in the Retail Integration Bus Advance Queuing (RIB AQ) database.

This issue is observed in the following scenarios:

A) After cloning of one RIB instance from other instance / environment.
     Before cloning they may work fine but after cloning of  the RIB AQ database, they come up with invalid objects.

B) Exporting / Importing of RIB AQ schema from one RIB environment to other.

C) After re-installing RIB also, facing the same issue. Below are the steps which are followed:

1. Delete RIBAQ User and TAFR hospital (TAFRHOSP) User
2. Delete all the oc4j instances
3. Re-create All oc4j instances
4. Re-create RIBAQ and TAFRHOSP Schema
5. Re-install RIB

Full compilation of database packages, types, and synonyms also may not help.

With this invalid rule sets, messages will not get processed and also adapters may tip down.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.