Solved

[Data migration] Migrate the work location

  • 17 November 2022
  • 4 replies
  • 200 views

Badge +3

Hello,

I am trying to migrate the work location for the emplyee file. I tried it via template EmployeeWorkLocation, but I didn’t manage. The two-step job works fine, but the field “work location” is empty.

I am using the Cloud version 22R1

I appreciate any help on the subject!

Kind regards,
Aleksandra 

icon

Best answer by MMcK 18 November 2022, 11:11

View original

4 replies

Userlevel 4
Badge +9

Hi! In order to better help you, 

could you add some screenshots of your two jobs you created?
Maybe the column is not mapped?

Maybe the modify setting is not set?

 

so some screenshots of the 2 jobs would be great!  

Badge +3

Hello,

Yes of course, I attached the screenshots of both jobs, template and IFS screen.

Thank you in advance,

Aleksandra

Userlevel 2
Badge +10

Hi

I believe the problem is the fixed value of SEQ_NO in the migration job.  It needs to be set with EMPLOYEE_WORK_LOCATION_SEQ.NEXTVAL

 

 

The above job works fine in 21R2, I haven’t tried it in 22R1.

I hope this helps you.

Badge +3

Hello,

Indeed, it was the problem with sequence number. Thank you very much!

Aleksandra

Reply