Human Capital Management - EBS (MOSC)

MOSC Banner

Employee History Assignment Loading

edited Jan 20, 2017 3:40PM in Human Capital Management - EBS (MOSC) 4 commentsAnswered

Dear All,

I am working on employee assignments to upload their history data. Employee are exist and Ex-employee. I need a script to upload current and ex-employee history assignment.

I am using data track functionality in my script but it's only update one line of the 1st assignment not create or insert new lines.

Need to instert below lines into assignment table for ex-employee.

1.     01-jun-2000 to 28-jul-2004

2.     29-jul-2004 to 15-oct-2004

3.     16-oct-2004 to 08-sep-2013

==============

Current Dates are exists

1.     01-jun-2000 to 30-jun-2013

2.     01-jul-2013 to 6-sep-2013

3.     08-sep-2013 to 20-mar-2014.

========================

declare

  -- Local Variables

  lc_dt_ud_mode      VARCHAR2(100) := NULL;

  ln_assignment_id   NUMBER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center