My Oracle Support Banner

Benefits Delete Script Leaves Abandoned Enrollment Rows (Doc ID 2913693.1)

Last updated on JANUARY 21, 2023

Applies to:

Oracle Advanced Benefits - Version 12.2.10 and later
Information 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)



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


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