OBIA 11g: 'ORA-20000: Error creating Index/Constraint W_HR_PERSON_LEG_DS_U1' in Cases of Rehired, Conversion From Contractor To Employee, or Conversion From Intern to Full Time Employee (Doc ID 2149837.1)

Last updated on AUGUST 14, 2017

Applies to:

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

Symptoms

BiApps ver : 11.1.1.8.1 version, DataWarehouse.

HR Analytic ODI: Various incremental load error.

Having a repetitive issue with HR incremental load.

When there is a case of rehired, conversion from contractor to employee, or conversion from intern (person type employee) to Full time employee got error

 

Changes

 

Cause

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