Fusion EMEA HR Legislation – Caring Responsibility UK Legislative Field Values History in the Back End Tables
(Doc ID 2942535.1)
Last updated on MAY 02, 2023
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.10.0 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
There is seeded field "Caring Responsibilities" for United Kingdom found under Person Details.
When the same field is checked (meaning "Yes"), or no value is seen as being flagged from UI (meaning "No"), the expectation is for the same status to be mirrored exactly from the back end tables.
But, its returned only for latest row which actually matching last update done by user from the UI, otherwise the rest of history rows values are fetched as blank.
Example:
| Person management (UI) "Caring Responsibilities" field status |
Effective Start Date | Effective End Date | Table - PER_PEOPLE_LEGISLATIVE_F Field - PER_INFORMATION18 |
| Is not checked (by default) | 30.11.2015 | 31.03.2019 | null |
| Is checked (by user) | 01.04.2019 | 24.11.2022 | Y |
| Is not checked (by user) | 25.11.2022 | 31.12.4712 | N |
EXPECTED BEHAVIOR
-----------------------
If the same field is not ticked from UI, then it should fetch as 'N' and not blank (null).
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Person management.
2. Under Legislative Information, click Edit - Correct.
3. Check and then update "Caring Responsibilities" field status.
4. Query PER_PEOPLE_LEGISLATIVE_F table for PER_INFORMATION18 field values.
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 |