Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Error updating Assignment with new Grade and Position - :HRC_FK_ATTR_UNABLE_TO_RESOLVE2
Summary
All records errored, when we used HDL to update employee assignments with newly loaded Grades and PositionsContent
All records errored, when we used below HDL to update employee assignments with newly loaded Grades and Positions.
METADATA|Assignment|ActionCode|AssignmentNumber|AssignmentId|WorkTermsAssignmentId|BusinessUnitShortCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|GradeCode|JobCode|PositionCode|ReasonCode
MERGE|Assignment|JOB_CHANGE|E1125796|300000069160005|300000069159869|Pressure Management|2017/12/01|4712/12/31|1|Y|PRM01.US.44|VP.Ops.Mgmt.Ex|PRM.200830.Ex|GRP_CHNG
METADATA|WorkTerms|AssignmentNumber|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId|ActionCode
MERGE|WorkTerms|ET1125796|300000069159869|2017/12/01|4712/12/31|1|Y|300000069159802|JOB_CHANGE
ERROR Message:
oracle.apps.hcm.common.core.HcmException: JBO-HRC:::HRC_FK_ATTR_UNABLE_TO_RESOLVE2: