My Oracle Support Banner

Effective date for Marital Status In Personal Data Page Is Saved As The 'AS OF DATE' (Doc ID 2582889.1)

Last updated on OCTOBER 24, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When an employee changes marital status in the personal information page (Self service, Personal information), the "As of date" entered here also gets saved as the Effdt in the personal data Effdt record of the employee (PERS_DATA_EFFDT).
This creates an issue when the As of date is past date and employee has a row greater than this date already in the personal record.
When saving the transaction from Self service, employee's entered as of date should not be considered as the Effdt also for PERS_DATA_EFFDT record.
To rows added to Biographical history grid should have the effective date of the change and not the date of "As Of Date" field.

STEPS
-----------------------

1. An Employee Xyz has existing below information -

EFFDT MARITAL - STATUS AS OF DATE
01.01.2019  UNKNOWN  01.01.2019

2. Employee realizes information is not up to date, changes this from self service and keep as of date as 09.12.2018, status as married. Change performed on 05.16.2019.

3. Now employees' marital status record will be as -
EFFDT MARITAL - STATUS AS OF DATE
01.01.2019 UNKNOWN 01.01.2019
09.12.2018 MARRIED 09.12.2018

Where the top most row still shows it as unknown, while the recent data is that employee is married as of 2018. If the Effdt in the record would be kept as current date the employee data would look like -
EFFDT MARITAL STATUS AS OF DATE
01.01.2019 unknown 01.01.2019
05.16.2019 married 09.12.2018

Thus showing the most recent row of may 2019, as married.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.