My Oracle Support Banner

ODI: Processing Recommendation Events In Wrong Order Leads To Wrong Information In DW_REPORTING (Doc ID 2377404.1)

Last updated on MARCH 25, 2018

Applies to:

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

Goal

When a recommendation is submitted and subsequently approved or rejected on the same day, it happens that the RecommendationApproved or RecommendationRejected event is processed before the RecommendationSubmitted event (other batch_num).
When this happens, the information in DIM_REC and FACT_RECOMMENDATION for this recommendation is not right.
DIM_REC: CURRENT_STATUS is reset to Submitted, DATE_COMPLETED or DATE_REJECTED is reset to NULL, COMPLETED_USR_ID or REJECTED_USR_ID is NULL
FACT_RECOMMENDATION: USR_COMPLETED_KEY is reset to 0.
 

Solution

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

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


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