Oracle Payroll enables you to control starting and stopping deductions in several ways:
Start Rule or Stop Rule: On Entry
When the start rule is On Entry, the deduction begins on the effective date you enter the deduction for an employee.
When the stop rule is On Entry, the deduction ends on the effective date the entry is deleted.
Start Rule: Earnings Threshold
The deduction starts when the Gross Earnings balance for the employee reaches a specified amount.
The formula for deductions with this rule checks whether the payroll run has caused the employee's year-to-date value of the Gross Earnings balance to reach or surpass the threshold amount.
Stop Rule: Total Reached
The deduction stops for an employee when a balance of the amount taken for the deduction reaches a specified amount.
US and Canadian users: You specify the start and stop rules through the Deductions window.
Mexican users: You specify the start and stop rules through the Element Design Wizard.
Note: You can modify the generated formula to reference a different balance.
The elements Oracle Payroll generates for initiated deductions include entry values needed for particular start and stop rules. Specify a default value for all eligible employees in the Default field of the Entry Values sub window of the Element Link window. Specify a value for an individual employee in the Entry Values sub window of the Element Entries window. The entry values are:
| Start or Stop Rule | Entry Value Name | Purpose of Entry |
|---|---|---|
| On Entry start and stop rule | On Entry | N/A |
| Earnings Threshold start rule | Threshold Amount | Gives formula the balance value that triggers deduction's start (Formula references Gross Earnings balance).
Note: This rule does not apply to Mexico. |
| Total Reached stop rule | Total Owed | Gives formula the total amount that triggers deduction's stop. |
When you use a Total Reached stop rule, the accrued balance is automatically set to zero when the amount deducted reaches the total owed. However, if you end the element entry before this happens, the balance is not cleared. If you enter the same element for the employee in the future, this deduction will end before the total owed has been deducted because the formula uses a balance that does not start from zero.
To prevent this problem, perform the following steps if you have to end an element entry with this stop rule before the total owed has been deducted:
Create a formula to check the value of <element_name>_ACCRUED_ASG_ITD, multiply its value by -1, and feed the result back to the accrued balance.
Create a nonrecurring element, and associate the formula with this element in the Formula Result Rules window.
Enter this element for the employee