Balance Exceptions

Balance exceptions define the criteria you use to identify overpayments, underpayments, and trends. The variance might also be a result of incorrect setup or adjustment.

Create a balance exception and the Balance Exception Report, and then run the Balance Exception Report. Run the report to generate a report output that displays payroll balance results according to the defined exception criteria. This info helps you detect the balance adjustments needed to correct payments or correct the balance setup.

To define a balance exception:

  1. From My Client Groups, click Show More.

  2. In Payroll, click Balance Exceptions.

Consider the following when you create the exception.

  • Standard balance exceptions

  • Comparison types

  • Variance operators

  • Severity level

  • Formula variance type

  • Balance variance type

Standard Balance Exceptions

The Balance Exception Report provides predefined balance exception checks at these levels.

  • Deferred compensation

  • Federal

  • State

For further info, see Oracle Cloud Human Capital Management for the United States: Balance Exception Report (2325520.1) on My Oracle Support.

Comparison Types

When you're creating balance exceptions, select a comparison type. Comparison types define the period that you use to determine whether an exception has occurred.

For example, select Average in months as the comparison type and enter 3 as the comparison value. In this scenario, the process compares the current month value to the average of the previous 3 months.

Some comparison values are preset, and you can't change them.

  • Current month, Current period, Current quarter, and Current year always have a comparison value of 0.

  • Previous period and Previous month have a comparison value of 1.

This table lists each comparison type that you can select and explains how it operates as a basis of comparison.

Comparison type

How it operates as a basis of comparison

Average in months

Compares the current month to date balance with the average of previous months to date. Only available if you have a Month to Date balance dimension for assignment or payroll relationship.

Current month

Compares values to the total for the current month to date balance. Doesn't use any previous month as a basis for comparison. Only available if you have a Month to Date balance dimension for assignment or payroll relationship.

Current period

Compares values to the total for the current period to date. Doesn't use any previous period as a basis for comparison. Only available if you have a Period to Date balance dimension for assignment or payroll relationship.

Current quarter

Compares values to the total for the current quarter to date. Doesn't use any previous period as a basis for comparison. Only available if you have a Quarter to Date balance dimension for assignment or payroll relationship.

Current year

Compares values to the total for the current year to date. Doesn't use any previous period as a basis for comparison. Only available if you have a Year to Date balance dimension for assignment or payroll relationship.

Previous month

Uses the previous month as a basis of comparison. Only available if you have a Month to Date balance dimension for assignment or payroll relationship.

Previous period

Uses the previous period as a basis of comparison. Only available if you have a Period to Date balance dimension for assignment or payroll relationship.

Note:

Comparison Value is shown for Average in Months. It is hidden for other comparison types.

If you select Average in months as the comparison type, you must enter a comparison value to determine the number of months that are averaged for the comparison.

Variance Operators

Variance operators enable you to specify the precise range of variance that you want to report on.

For example, you want to determine the monthly car allowance paid to employees in excess of $600 more than the previous month for the same payroll relationship. You can set up a balance exception for this example using these values.

  • Comparison type is previous month

  • Balance name is monthly car allowance

  • Dimension name is relationship month to date

  • Previous month amount is $500

  • Variance value is $100

This table describes the effect of using each of the variance operators for balance exception reporting. The Results column indicates the effect of selecting each variance operator.

Variance Operator

Balance Exception Report Output

Results (based on sample data)

Variance, plus or minus

Note:

This operator applies only for comparison types of Previous, such as Previous Months or Previous Period, as well as Average in Months.

All relationships whose balance value either exceeds or are less than the previous month amount by the amount or percentage stated in the variance value.

Returns all relationships with a value less than or equal to $400 and greater than or equal to $600.

Less than

All relationships that are less than the previous month amount by the amount or percentage stated in the variance value.

Returns all relationships with a value of less than $400.

Less than or equal

All relationships with a current value either equal to or less than the previous month amount by the amount or percentage stated in the variance value.

Returns all relationships with a value of $400 or less.

Equal

All values that are exactly equal to the higher limit or the lower limit of the variance value.

Returns all relationships with a current value equal to $400 or $600.

Greater than

All relationships that are greater than the previous month amount by the amount or percentage stated in the variance value.

Returns all relationships with a value of more than $600.

Greater than or equal

All relationships with a current value either equal to or greater than the previous month amount by the amount or percentage stated in the variance value.

Returns all relationships with a value of $600 or more.

Does not equal

All relationships with a current value not equal to the previous month amount.

Returns all relationships with a value other than $500.

Select a balance type and balance dimension that specifies the balance value you want evaluated for the exception. You can only select balance dimensions that are compatible with the comparison type you specified.

For example, if the comparison type is Current Period, you can only select balance dimensions of Period to Date type.

Severity Level

The severity level controls the order in which the exceptions are displayed in the balance exception report. Balance exceptions with the higher severity are displayed first (1 being the highest).

Formula Variance Type

You can write a fast formula using the Balance Exception formula type to return a variance value that you can use for identifying exceptions for a balance. To use this feature, select the Formula variance type on the Create Balance Exception page and then select the formula that you created from Formula Name.

Balance Variance Type

To reference two balances in the balance exception equation:

  1. Select the Balance variance type on the Create Balance Exception page.

  2. Select the Target Balance Name and Target Dimension Name.

    This applies only when the comparison type is Current Month, Period, Quarter, or Year.

    The dimension name you select on the left-hand side of the Create Balance Exception page determine the context values for Target Dimension Name. No additional contexts are set for the target dimension name.