My Oracle Support Banner

OBIA 11g: How To Reconcile Fusion Assignment Events From OTBI To Events In OBIA (OAC) (Doc ID 2640588.1)

Last updated on MARCH 25, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.
Fusion Applications source

Goal

Have conducted some extensive reconciliation exercises between Fusion and OAC, where accounted for transformations done by OBIA's ETL (e.g. If an Assignment has a 0 Headcount but has a Primary Flag of 'Y', the OOTB of ETL from OBIA will transform it to 1) and have matched high-levels to low-levels of granularity across a variety of subject areas.

When reconciling events, have noticed that there were some discrepancies between Fusion and OAC (e.g. Data Migration events in Fusion more than ~4,000 than in OAC). I am satisfied that the assignments themselves match between the two systems.
However, we would like to know if it's possible to go to a deeper grain and conduct a reconciliation at the event-level.

We are able to do 1-to-1 at an assignment level (e.g. assignments numbers, headcount, headcount by grade etc.), but the business wants us to reconcile the events on the assignment (e.g. changing manager, getting promoted, getting transferred, getting terminated etc.). So technically this would be a lower-level of granularity than reconciling the assignments 1-to-1 between Fusion and OAC.

How would you advise us to complete this activity?
-or -
Is the logic used by OBIA too complex for this to be completed 1-to-1 between Fusion and OAC?

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!


In this Document
Goal
Solution


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