Error importing Employee records

(0) Share

Report

Posted on by syed baber

11,633

Hi All,

I am trying to import Employee records and updating Financial dimensions for Employee, but when I am running import getting below error:

Results. Cannot edit a record in Employee detail (HcmEmploymentEmployee). 'Expiration' column cannot be updated in change tracking mode.

Please note that only financial dimension fields were updated, but it is giving above error regarding some dates field. Does anyone have any clue about this error and how to resolve this ?

Thanks,

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Human Resource data entity has some restriction

Best think to do is, just delete all the fields from the file and just keep your value what you want to update in the data entity with employed identification number such as personal number.

Try to import.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report
Copy link

Link copied!

Hi Baber,

I found an old thread on same related issue, check that out please to get any hint. Check on LCS as well for any hotfix.

community.dynamics.com/.../results-cannot-edit-a-record-in-worker-titles-hcmworkertitle-expiration-column-cannot-be-updated-in-change-tracking-mode

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report
Copy link

Link copied!

I was thinking of doing the same thing, but thought I would check first. Let me try this.

Was this reply helpful? Yes No
Sadiq Syed 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Baber,

Did you manage to address this issue?

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report
Copy link

Link copied!

Sadiq,

In order to update the Financial dimension for employee, we need to use the HcmEmployment entity. So first we need to import the employees using worker entity and then use the Employment entity to update the Financial dimension and start date for employees. This sequence should work.

Let me know how it goes.

Thanks,

Baber.

Was this reply helpful? Yes No
Sadiq Syed 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks Baber,

Looks like I was doing something wrong earlier, I am able to run the PATCH action to update employee data including dimensions.

PATCH:

[Based URL]/data/EmployeesV2(PersonnelNumber='000813',EmploymentLegalEntityId='USMF',EmploymentId='000000931')

From the payload, I only had to remove Party and Name fields. I am even able to terminate the employee using this same entity.

Was this reply helpful? Yes No