My Oracle Support Banner

Recommendation Status Mismatch In OBIEE Reports (Doc ID 2660069.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.


Recommendation status mismatch in OBIEE Reports.

We pull the recommendation reports, some of the recommendations still shows as submitted but its accepted / rejected already in IM. The new status is not updated here.

We checked all the events processed in DW_STAGE. When we try to query in DW_STAGE table we can see multiple accepted events came into dw_stage for same request, but both of them are not updated.

Multiple accepted events is not an issue, events are processed successfully even in DW_STAGE.

Example article PR1234's recommendation status is submitted in OBIEE report, but it is in accepted status in IM.

We can see status mismatch between IM and OBIEE.

When we checked DW_Stage table for PR1234 we can see two events for RecommendationApproved with milliseconds difference.

If ODI is processing real time without any backlog, this issue will not occur.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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