Benefits Delete Script Leaves Abandoned Enrollment Rows
(Doc ID 2913693.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Advanced Benefits - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
After running the Ben Delete Script (del_pil_oab_le.sql) on a person, there are still abandoned rows in the benefits tables.
The Benefits Delete script should remove all Benefits data.
There are two scripts available for deleting Benefits data:
Script Name Inputs Description
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
del_pil_oab_le.sql - person_id This script deletes everything up to the system date.
del_pil_oab_le_effective_date.sql - person_id This script does the same as above,
- effective_date but looks into the future for rows to remove - based on the life event input entered.
Please refer to the following note for further reference on these scripts:
- How Can an Employees Benefits Data be Purged in Oracle Benefits ? (Doc ID 1964809.1)
There are two scripts available for deleting Benefits data:
Script Name Inputs Description
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
del_pil_oab_le.sql - person_id This script deletes everything up to the system date.
del_pil_oab_le_effective_date.sql - person_id This script does the same as above,
- effective_date but looks into the future for rows to remove - based on the life event input entered.
Please refer to the following note for further reference on these scripts:
- How Can an Employees Benefits Data be Purged in Oracle Benefits ? (Doc ID 1964809.1)
After running the script, these 2 queries (run for specific people) identified the abandoned rows:
Query 1:
(identifies if a person has life events on their record, which after running the script - they shouldn't):
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 |