OBIA 796 POSITION HIERARCHY DOESN'T SUPPORT BACKDATED CHANGES FOR EBS SOURCE (Doc ID 1155586.1)

Last updated on NOVEMBER 14, 2014

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] to 7.9.6.3 [AN 1900] [Release V7]
Information in this document applies to any platform.
This issue is applicable to any EBS Data source.
21st May 2013 - Checked for Relevancy


Goal

Position Hierarchy does not support backdated changes in OBIA 7.9.6/7.9.6.1. When a backdated change occurs in EBS HR application, ETL mapping SIL_POSITIONDIMENSIONHIERARCHY fails with ORA-00001 Unique Constraint violation ON W_POSITION_DH_U2.

Solution

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 hundreds of Community platforms