PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How do I use multiple effective dates in parent child relationship?

I have a need to have multiple records use effective dated logic in a parent-child relationship.  Consider the following:

Parent Record:

   EMPLID   (Key)

   EFFDT     (Key)

   ACTIVE_FLAG

Child Record1:

   EMPLID   (Key)

   EFFDT     (Key)

   EMPLID2  (Key)

   ASOFDATE (Key)

   EFF_STATUS

Child Record2:

   EMPLID   (Key)

   EFFDT     (Key)

   EMPLID2  (Key)

   ASOFDATE (Key)

   DEPTID     (Key)

My page looks like this:

The Problem is this:  I can insert rows at level 1 (note the scroll without a border), however, at level two (and three) I get an error that I must be in Correction Mode to change current or history records.  I assume this is because I have ASOFDATE instead of EFFDT at level 2.

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