OBIA 11g:FA13-1810: ManagerHierarchyAssignmentPVO Key in ODI doesnt match ETL PK
(Doc ID 2505971.1)
Last updated on FEBRUARY 25, 2020
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 to 18.104.22.168.1 [Release 11g]
Information in this document applies to any platform.
Current VO used in Position Dimension and Hierarchy has a primary key defined on Assignment ID, but in ETL we are using the PersonId and Effective From
date as Primary Key (W_POSITION_D), So when for a given Person Id, for the same effective dates, a new assignment is assigned as primark assignement,
SDS table will have duplicates in SDS table.
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