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

Last updated on JANUARY 26, 2024

Applies to:

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

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