My Oracle Support Banner

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 11.1.1.10.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

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.

 

Cause

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
Symptoms
Cause
Solution
References

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