Event Group and Event Action for Recalculation of Run Balances

This topic shows how you can create an event group and associate it to an event action to recalculate run balances.

When you create or update a balance definition or feed, you must consider if the change impacts future payroll calculations and reports only, or if there's a requirement to recalculate the balances retrospectively.

If you need to recalculate the balance amounts, such as the retropay calculations, you've the option to run the Generate Run Balances process. The Generate Run Balances process ensures that the retrospective balance change doesn't cause performance issues.

Use event groups to identify the type of changes that require the Generate Run Balances process to be submitted automatically.

Let’s consider an example where you want to track balance definitions and balance feed changes impact balance calculations and stored balance values for run balance dimensions.

When an event in your group is triggered, a balance change event notification is triggered so that the Generate Run Balances process is automatically submitted.

This example EventGroup.dat file creates a single Event Group component and associates it to the Event Action. For the Generate Run Balances calculations, the EventGroupType attribute value must be A.

Create Event Action Group

METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|BaseFlowName(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowInstanceName(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterNameOne(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterValueOne(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterNameTwo(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterValueTwo(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterNameThree(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|FlowParameterValueThree(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|ScheduleSkip(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|ScheduleInterval(PAY_EVENT_ACTIONS_DDF=ORA_PAY_SUBMIT_FLOW_ACTION)|EventActionName|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionTypeCode|ActionSubmission|LegislativeDataGroupName

MERGEIEventAction|ORA_PAY_SUBMIT_FLOW_ACTION|Generate Run Balances|NK THREAD_{FLOW_NAME}|Legislative Data Group Identifier|{LEGISLATIVEDATAGROUP_ID}|Process End Date|{SYSTEM_DATE}|Balances To Include|ORA_PAY_ALL_INVALID_BAL|N||NK_EA_CRFL_3|1950/01/4712/12/31|ORA_PAY_SUBMIT_FLOW_ACTION|SYNC|CRFL RRF LDG US1

Create Event Group

MERGE|EventGroup|NK_EG_CRFL_3|NK_EG_CRFL_3|A||CRFL RRF LDG US1

Indicate the type of events within the Event Group

MERGE|DateTrackedEvent||DT_INSERT||NK_EG_CRFL_3|oracle.apps.hcm.payrolls.balances.setup.protectedModel.entity.BalanceFeedDEO|CRFL RRF LDG US1

MERGE|DateTrackedEvent||DT_ZAP||NK_EG_CRFL_3|oracle.apps.hcm.payrolls.balances.setup.protectedModel.entity.BalanceFeedDEO|CRFL RRF LDG US1

MERGE|DateTrackedEvent|SCALE|DT_CORRECTION||NK_EG_CRFL_3|oracle.apps.hcm.payrolls.balances.setup.protectedModel.entity.BalanceFeedDEO|CRFL RRF LDG US1sMERGE|DateTrackedEvent|SCALE|DT_UPDATE_COLUMN||NK_EG_CRFL_3|oracle.apps.hcm.payrolls.balances.setup.protectedModel.entity.BalanceFeedDEO|CRFL RRF LDG US1

Associate your Event Action to the Event Group