EFFDT_NOKEY and EFFSEQ_NOKEY Not Populated in SJT_PERSON When Job Data Is Updated (Doc ID 1986813.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

HCM 9.2 Security

The fields EFFDT_NOKEY and EFFSEQ_NOKEY are not populated in SJT_PERSON when the employee's Job data is updated. However, these fields are updated when running the Refresh Trans. SJT Tables process (navigation: Set Up HCM > Security > Core Row Level Security > Refresh Trans. SJT Tables).

Steps:
1. Using DEMO data, test with Empl ID KU0050.
2. Note that at the beginning of the test EFFDT_NOKEY and EFFSEQ_NOKEY are currently populated in record SJT_PERSON.
3. Update Job Data for KU0050 by modifying the Department.
4. Note that EFFDT_NOKEY and EFFSEQ_NOKEY are no longer populated in record SJT_PERSON.
5. Run the Refresh Trans. SJT tables process.
6. Note that EFFDT_NOKEY and EFFSEQ_NOKEY are now populated in record SJT_PERSON.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms