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 NOVEMBER 03, 2023
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.04.0 and laterInformation 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 |