Skip to main content

Do you know how to do bulk deletion of Oracle Cloud HCM absence enrollment

Today we are going to see how to delete the absence enrollment of workers in bulk.
Create Fast Formula of Type “Person Selection”

Include List of person numbers for which Accrual Enrollment needs to be deleted. Below is the formula text for sample 2 person numbers

Formula Text:
/*******************************************************************
PERSON_SELECTION
Person Selection rule used to limit the process
************************************************************************/
/*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
DEFAULT for PER_ASG_PERSON_NUMBER IS '-1'
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
l_output = 'N'
l_per_number = PER_ASG_PERSON_NUMBER
if (
l_per_number = '1234' OR
l_per_number = '12345'
)
then
( l_output = 'Y' )
return l_output
/*================ FORMULA SECTION END =======================*/

Go to Absences and Click on Task Pane. Click on option “Schedule and Monitor Absence Processes”
Click on “Withdraw Accruals and Balances” (Run Button)
Parameter Details:
Run as test
Check it if it is for test purpose. If checked the accrual enrollments will not be deleted. If unchecked the accrual enrollments will be deleted.
Include trace statements in audit log
Check it if logs are needed
Processing Option
Enrollment Deletion
Person Selection Rule
Select the Person Selection Fast Formula Which we created
Absence Plan
Select the corresponding Absence Plan
 
Select the appropriate parameters and click submit.

Initially do a test run with logs enabled and validate the deletion of enrollment and then do the final run.
Please post your questions and feedback in the comments section.

Comments

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

Do you know how to generate output using eText Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using eText Template in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Word Document and save it as type "Rich Text Format" Add a format setup which is given below <TEMPLATE TYPE> FIXED_POSITION_BASED <OUTPUT CHARACTER SET> UTF-8 <NEW RECORD CHARACTER> Carriage Return Add a Header table which is given below. For headers, give the header name within quotes ex: 'Emplid'. For headers, use the level DATA_DS which is the top level and appears only once in the XML <LEVEL> DATA_DS <POSITION> <LENGTH> <FORMAT> <PAD> <DATA> <COMMENTS> <NEW RECORD> DATA_DS Alpha ‘Emplid’

Do you know how to cancel the Work Relationship using HDL in Oracle Cloud HCM?

In this blog, we are going to see how to cancel the Work Relationship using HDL (HCM Data Loader) Please make sure you have taken the back up of all the necessary data before cancelling the Work Relationship To cancel the Work Relationship, we use HDL Source Key method. Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|FUSION|1234|WRK_1234|Legal_Employer|1234|2018/02/01|E|Y In the above template, we do not know the values of the source keys SourceSystemOwner SourceSystemId PersonId(SourceSystemId) Use below query to fetch the SourceSystemOwner Query: select source_system_owner from hrc_integration_key_map where surrogate_id = period_of_service_id   -- pass period_of_service_id corresponding to Work Relationship Use below query to fetch the SourceSystemId Q

Do you know how to generate output using Excel Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using Excel Templates in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Excel file and save it as type "Excel 97-2003 Workbook" (.xls) I have created 3 tabs "Summary", "Detail" and "XDO_METADATA" XDO_METADATA tab is mandatory. Place the below text in XDO_METADATA tab Version ARU-dbdrv Extractor Version Template Code Template Type TYPE_EXCEL_TEMPLATE Preprocess XSLT File Last Modified Date Last Modified By Data Constraints: In the "Detail" tab create Header row as shown below Now add the XDO tags Select the blank &quo