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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!