You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

HDL Error - The assignment and work terms should be inactive from the next day after the termination

Summary:

Hello,

I am getting the above error using these lines below, does anyone see anything inaccurate below?

Thank you so much!

METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|ActionCode|DateOfBirth|StartDate

MERGE|Worker|NRV|4718|4718|2022/10/17|HIRE|1963/03/18|2022/10/17


METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonNumber|NameType|LegislationCode|EffectiveStartDate|FirstName|LastName|MiddleNames|Suffix|KnownAs|EffectiveEndDate

MERGE|PersonName|NRV|PN4718|4718|GLOBAL|US|2022/10/17|MICHAEL|BOB|SMITH|||4712/12/31


METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ActualTerminationDate|OnMilitaryServiceFlag|PrimaryFlag|RehireRecommendationFlag

MERGE|WorkRelationship|NRV|WR4718|4718|ABC|2021/02/08|E|HIRE|2022/06/29|N|Y|Y

MERGE|WorkRelationship|NRV|WR4718-2|4718|ABC|2022/10/17|E|REHIRE||N|Y|Y


METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|PersonNumber|LegalEmployerName|BusinessUnitShortCode|ActionCode|AssignmentNumber|JobCode|DateStart|EffectiveStartDate|EffectiveEndDate|WorkerType|EffectiveLatestChange|EffectiveSequence|AssignmentCategory|AssignmentStatusTypeCode|AssignmentType|PrimaryWorkTermsFlag|DefaultExpenseAccount|ExpenseCheckSendToAddress|DepartmentName|NormalHours|Frequency|FullPartTime|GradeCode|HourlySalariedCode|LocationCode|ManagerFlag|PersonTypeCode|PeopleGroup|PermanentTemporary|WorkAtHomeFlag

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!