This discussion is archived
2 Replies Latest reply: Dec 4, 2012 8:29 PM by 977591 RSS

ExceltoCI to insert a new effdt row in JOB_DATA component

977591 Newbie
Currently Being Moderated
Hi All,

We are trying to use ExceltoCI to insert a new effdt row in JOB_DATA component. But it is not working when the BU is changing. I believe it is caused by we need to assign BU prior to other SETID enabled field like Department, locations, jobcodes, etc. But unfortunately, in the JOB record/table the Business Unit is after DEPTID, LOCATION, JOBCODE field which causes the assignment of BU value is happened after assignment of DEPTID and LOCATION ect. So I am getting invalid departments, locations, jobcodes error. Since I am not aware of a way to change the load sequence by using ExceltoCI.

Any idea about how I can accomplish this for using ExceltoCIs or it is impossible? Thank you very much in advance.
P.S. I know it is quite simple to use AE+CI to do this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points