My Oracle Support Banner

HCM Data Load Issue: Update Manager - JBO-27127: The Effective Date Operation for Entity AssignmentSupervisorDEO will Introduce Gaps or Overlaps (Doc ID 2891215.1)

Last updated on AUGUST 22, 2022

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.22.04.0 version, Data Load

When attempting to Update Manager via HDL load:

METADATA|WorkTerms|SourceSystemId|SourceSystemOwner|ActionCode|ReasonCode|PrimaryWorkTermsFlag|PersonTypeCode|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|BusinessUnitShortCode|PersonNumber|JobCode|DepartmentName|LocationCode|DefaultExpenseAccount|ExpenseCheckSendToAddress|ManagerFlag|HourlySalariedCode|NormalHours|Frequency|AssignmentNumber
MERGE|WorkTerms|
METADATA|Assignment|SourceSystemId|SourceSystemOwner|ActionCode|ReasonCode|WorkTermsAssignmentId(SourceSystemId)|PrimaryAssignmentFlag|PersonTypeCode|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|BusinessUnitShortCode|AssignmentStatusTypeCode|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PersonNumber|JobCode|DepartmentName|LocationCode|DefaultExpenseAccount|ExpenseCheckSendToAddress|ManagerFlag|HourlySalariedCode|NormalHours|Frequency|AssignmentNumber|GradeCode|PositionCode
MERGE|Assignment|
METADATA|AssignmentSupervisor|AssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|ManagerAssignmentId(SourceSystemId)|ManagerId(SourceSystemId)|ManagerType|PersonId(SourceSystemId)|PrimaryFlag
MERGE|AssignmentSupervisor


the following error occurs.

ERROR
-----------------------
An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: JBO-27127: The effective date operation for Entity AssignmentSupervisorDEO will introduce gaps or overlaps. key=oracle.jbo.Key[1XXXX 2022-08-18 4712-12-31 ].

Error on Entity : AssignmentSupervisor

Changes

 

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
Changes
Cause
Solution


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