My Oracle Support Banner

ORA-20001:Primary Address already exists in date range Fusion Integration (Doc ID 2436455.1)

Last updated on APRIL 19, 2019

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, RUP10, Fusion Integration


While trying to integrate primary address type in EBS through OOB Integration for the employee who is already having primary active address in HCM EBS, throwing error for Worker Address Integration

ORA-20001:Primary Address already exists in date range



STEPS
The issue can be reproduced at will with the following steps:

  1. Integrate primary address type in eBS through OOB Integration for the employee who is already having primary active address in eBS
  2.  Error is seen for Worker Address Integration

Also, another error can be seen in the following scenario:

  1. Trying to update primary address in HCM EBS
  2. Integrate address type in HCM EBS through OOB Integration for the employee who is already having two active address in HCM, one being Primary and other NonPrimary
  3. Error is seen for Worker Address Integration

ORA-20001: A non Primary Address cannot exist without a corresponding Primary Address.
The Date change has left a Non Primary Address without a corresponding Primary Address.

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.