Retro Pay Setup in Oracle HRMS Payroll

 Enable dynamic triggers:

1. Navigate to the Dynamic Triggers window.

2. Enable any dynamic triggers that the application generates. It is important to enable these triggers to ensure your payroll processing updates each database table correctly. The recommended minimum list of triggers to enable for the Retro-Notifications report is as follows:

Table Name Trigger Type

PAY_ELEMENT_ENTRY_VALUES_F Update

Press Find

 

PAY_ELEMENT_ENTRIES_F Update

Press Find

PAY_ELEMENT_ENTRIES_F Insert

PAY_ELEMENT_ENTRIES_F Delete Trigger

Define an Event Group:

1. Navigate to the Table Event Group window. (Global HRMS Manager-->Other Definitions --> Event Groups)

2. Enter a name for your Event Group, for example, Retro-Notification Events.

3. Select Retro as your event groups type.

4. Save your entries.

5. Select the events that will produce notification if retrospective changes occur. Specify the following    information to identify the type of update and the database table to which it applies:

• Update Type

• Base Table Name

• Column Name

For example:

Update Type	Table	Column Name
DateTrack Correction	PAY_ELEMENT_ENTRY_VALUES_F	SCREEN_ENTRY_VALUE
DateTrack Update	PAY_ELEMENT_ENTRIES_F	EFFECTIVE_START_DATE
DateTrack Update	PAY_ELEMENT_ENTRIES_F	EFFECTIVE_END_DATE
DateTrack End Date	PAY_ELEMENT_ENTRIES_F
DateTrack Insert	PAY_ELEMENT_ENTRIES_F
DateTrack Delete	PAY_ELEMENT_ENTRIES_F

Enable the Incident Register:

1. Navigate to the Functional Area Maintenance window.  (Global HRMS Manager-->Other Definitions --> Functional Areas)

2. Query the Incident Register and ensure that you have triggers defined.

3. Decide whether to capture the triggers by legislation, business group, or payroll. Navigate to each tab to make your selection.

A caution will be shown on selecting Legislation and Business Group as below.

Setup is complete now.