Browser version scriptSkip Headers

Oracle® Fusion Applications Workforce Deployment Implementation Guide
11g Release 6 (11.1.6)
Part Number E20379-06
Go to Documentation Home
Home
Go to contents  page
Contents
Book<br />List
Book
List
Go to Feedback page
Contact
Us

Go to previous page
Previous
Go to previous page
Next

22 Define Payroll

This chapter contains the following:

Payroll Relationships: Explained

Define Payroll Business Definitions

Define Pay Frequency

Manage User-Defined Tables

Define Fast Formulas

Define Balance Definitions

Define Earning and Deduction Definitions

Define Events

Define Payment Methods

Define Payroll Costing

Manage Object Groups

Define Payroll Flow Patterns

Manage Payroll Process Configuration

Payroll Relationships: Explained

A payroll relationship exists between a person and a payroll statutory unit, which is the legal entity responsible for employee payment. Payroll relationships group person records based on payroll regulatory and statutory calculation and reporting requirements. This grouping enables the aggregation of balances across multiple employment terms and assignment records.

Important aspects of payroll relationships include:

Creation of Payroll Relationship Records

When an HR administrator processes a new hire, the application automatically creates a payroll relationship record for that person. As an administrator adds employment terms or assignments for that person, the application uses several factors, such as system person type, payroll statutory unit, and country-specific relationship mapping rules, to determine whether to create a new payroll relationship record. Predefined mapping rules for payroll relationships also define the payroll relationship types that indicate whether payroll processing can occur. These predefined rules can vary by localization. For example, in the US, the Employee person type maps to the payroll relationship type that is defined to be processed in payroll runs, whereas the Contingent Worker person type maps to a payroll relationship type that is not be processed in payroll runs.

Note

There is no direct association between payroll relationships and work relationships.

Multilevel Aggregation for Payroll Calculation

Payroll relationships represent the association between a person and the payroll statutory unit, which provides the highest level of aggregation for payroll calculation purposes. Payroll processing occurs at the payroll relationship level. This means that to access the results of any payroll process, such as calculation or payment distribution, you start by selecting a payroll relationship record.

Note

Although a person may have multiple payroll relationships, payroll balances for that person cannot span payroll relationships.

Payroll Employment Model

The payroll relationship structure provides the capability to have employment terms and assignments that can be linked together for calculations based on the payroll statutory unit. Therefore, information must be stored at the various levels of the payroll relationship model. This information is used by the various payroll processes.

Your enterprise might be defined to use two-tier and three-tier employment models. The three payroll employment levels are:

The following figure illustrates the comparison between the HR employment model and the payroll employment model in a US example with two legal employers belonging to one payroll statutory unit. In this example, David Ellis has two different employment terms and assignments, and therefore has two work relationships in the HR employment model and one payroll relationship in the payroll employment model.

Payroll employment model

Define Payroll Business Definitions

Payroll Employment Hierarchy Profile Option: Critical Choices

You can use profile options to specify the values you want to display for each level of the payroll employment hierarchy. The hierarchy appears in View Person Process Results pages. It can display information for up to three levels, depending on the employment model used in your enterprise:

You can specify up to three values at each level to help identify the record. For example, you might select legal employer name and job name to identify employment terms records, and assignment name and number to identify assignment records.

Which Values to Use for the Profile Option

The following table lists the profile option codes, available profile values, and default values at the site level for each level of the payroll employment hierarchy.


Level

Profile Option Codes

Profile Values

Payroll relationship

PAY_EMP_HIERARCHY_REL_DESC_1

PAY_EMP_HIERARCHY_REL_DESC_2

PAY_EMP_HIERARCHY_REL_DESC_3

Payroll

Relationship

Number

Payroll Statutory

Unit Name

Payroll Relationship Type

Employment terms

PAY_EMP_HIERARCHY_TERM_DESC_1

PAY_EMP_HIERARCHY_TERM_DESC_2

PAY_EMP_HIERARCHY_TERM_DESC_3

Employment Category

Legal Employer Name

Grade Name

Job Name

Position Name

Payroll Name

Location Name

Assignment

PAY_EMP_HIERARCHY_ASG_DESC_1

PAY_EMP_HIERARCHY_ASG_DESC_2

PAY_EMP_HIERARCHY_ASG_DESC_3

Assignment Name

Assignment Number

Employment Category

Grade Name

Job Name

Legal Employer Name

Location Name

Position Name

Overriding Site-level Values with User-level Values

You can override site-level values at the user level. For example, you might use position as the default value and override it with job for the payroll administrator who manages records for a group of workers who are not assigned to positions.

Define Pay Frequency

Pay Frequency Components: How They Work Together

Pay frequency components together provide the flexibility to implement complex time-related objects used in payroll definitions, payroll processes, and payroll tasks that use start and end dates.

It is important to understand how the following pay frequency components work together to provide payroll functionality for your organization. Each may require its own setup and implementation.

Consolidation Groups

Use consolidation groups to process the results from more than one payroll run in a single action or process the results for one payroll in separate actions. With consolidation groups, you produce one set of results per payment method for several payrolls, one set of reports, and one set of costing results. For example, you may submit a regular payroll run and a supplementary payroll run for the same payroll period. If both the regular and supplementary run belong to the same consolidation group, then you use a single consolidation group to process all the results for the post-run processing. Optionally, you can enter a different consolidation group for the supplementary payroll and use it to process the results of the post-run processing for the supplementary payroll separately from the regular payroll.

Payroll Definitions

Payroll definitions are essential to your payroll implementation because they indicate the payment frequency and processing schedule, and through the payroll relationship, they link the employees with the payroll run.

Time Definitions

Time definitions can be static periods of unusual length based on a given static date, or they can create dates based on dynamic variables that you specify for either a time span, a retrieval date, or a more complex definition type to use with a user-defined date. They are used in many areas, including payroll periods, payroll employment management, balance dimensions, retroactive and proration events, element start and end dates, and overtime periods.

Run Types

Run types control the elements and payment types to process in a payroll run. Two predefined run types, Regular and Supplemental, group the other run types and determine the sequence in which they are processed. The Regular run type includes Regular Normal, Process Separately, and Separate Payment. The Supplemental run type includes Process Separately, Separate Payment, and Supplemental Normal.

For each of the component run types, you can specify payment methods that override the default payment methods for the payroll definition. You can also select the element classifications to be processed by runs of this type, and exclude specific elements from these classifications.

Consolidation Group Usage: Examples

You create consolidation groups by selecting the Manage Consolidation Groups task from the Payroll Calculation work area. The following scenarios provide examples of how you can use consolidation groups.

Post-Run Processing

Consolidation groups facilitate separating payroll run results for supplemental processing. For most payroll post-run processing, you can use the consolidation group as an input parameter. You may want the results of a supplemental payroll run to be kept separately from those of the regular payroll process that was already performed. To use a consolidation group to keep supplemental run results separate from the regular payroll run, you would perform these steps:

  1. Create a new consolidation group used to label the supplemental payroll run.

  2. Initiate the supplemental payroll run, specifying the new consolidation group as an input parameter.

Separate Costing and Payment

Using multiple consolidation groups you can control processing. For example, you want to process and pay a particular set of employees separately within a single payroll to keep separate records of payment and costing. To process employees separately, you would perform these steps:

  1. Create a new consolidation group to specify when running the Calculate Payroll process.

  2. Create a payroll relationship groups to separate the employees.

    You can use rules to identify them dynamically or you can specify the employees by their payroll relationship numbers.

  3. Run the Calculate Payroll process for each payroll relationship group separately, once specifying the original consolidation and once for the new consolidation group.

Supplemental Processing for Special Circumstances

You may want a supplemental payroll run for a special circumstance. For example, you have a main payroll run and three QuickPay runs. Because one of the QuickPay runs is for a termination, it needs to be processed prior to the others. To process the QuickPay for this special circumstance, you would perform these steps:

  1. Create a new consolidation group to specify when you process the QuickPay for the termination.

  2. Submit a QuickPay process, specifying the new consolidation group.

  3. Process the other three payroll runs using their default consolidation groups.

Payroll Definitions: Explained

Payroll definitions contain calendar and offset information, which determines when payments are calculated and costed. Using payroll definitions, you can specify payment frequency, processing schedule, and other parameters for a particular payroll. Payroll period types, such as weekly or monthly, determine the interval at which you pay employees.

Each payroll definition can use only one payroll period type, and you must set up at least one payroll definition for each payroll period type that you use to pay employees. For example, to pay employees semimonthly, create a payroll definition using the semimonthly payroll period type, ensuring that tax calculations and other calculations will produce correct results for those employees.

When you create a payroll definition, the complete payroll schedule is automatically generated, based on the payroll period type, any offsets or calendar adjustments, and the number of years that you specify. Once you have saved a payroll definition, you can assign employees to it on the Manage Payroll Relationships page.

A common scenario for modifying an existing payroll definition is to increase the number of years and generate more payroll time periods to extend the payroll calendar. A common scenario for creating a payroll definition is to replace one that is expired or end-dated.

Each payroll must belong to a consolidation group, which is required by the application for processing purposes. Before you can create a payroll definition, the legislative data group and the consolidation group to use for it must already be defined.

Managing Payroll Definitions: Points to Consider

When you create or modify payroll definitions, the application automatically generates a calendar of payroll periods based on your selections. The choices you make for the following values determine exactly how the schedule of payroll periods is generated:

Effective Start Date

The effective start date is the first date that the payroll definition can be used for employee data. The start date must be on or before the earliest date of any historical data you want to load. For example if you want a payroll to be in use starting on 1/1/2013, and you have 5 years of historical payroll data to load, then the start date of the payroll definition must be on or before 1/1/2008.

The effective start date does not affect the generated calendar of payroll periods. The start date for the first payroll period is based on the first period end date.

First Period End Date

The first period end date is the end date of the first payroll period that the application generates for a payroll definition. It is typically based on the date of implementation, tax year, benefits enrollments, or a particular payment cycle. For example, if your weekly payroll work week is Saturday through Friday, and your first payment date is planned to be on 1/6/12, you could use 12/30/11 as your first period end date.

Number of Years

The number of years you enter represents how many years of time periods to generate starting from the beginning of the first payroll period. For example, a payroll definition with an effective start date of 1/1/1985, a payroll period type of semimonthly, a first period end date of 6/15/2012, and the number of years as 5 would generate a calendar of payroll time periods from 6/1/2012 through 5/31/2017. Once you save a payroll definition, you can later only increase but not reduce its number of years because a calendar of time periods for the payroll has already been generated.

Offsets

Depending on the payroll period type, you can elect for your payroll cycle events to occur on specific dates or be based on offsets from period start or end dates.

This table describes the predefined payroll cycle events that you can offset.


Date

Meaning

Cutoff Date

Final date that payroll information can be entered for the payroll period.

Payslip Availability Date

Date on which the payslip is available for viewing.

Payroll Run Date

Date scheduled for the regular run of this payroll.

Date Earned

Date on which element entries are added to the payroll run.

Date Paid

Date the employee is marked as paid. For check payments, this is the date that the check can be cashed or deposited. For electronic funds transfer (EFT) payments, it is the transfer date.

Dynamic Offsets

When creating a payroll definition, you can use dynamic offsets for payroll cycle events. All of the predefined payroll time periods you can use support dynamically generated dates for offsets. Using dynamic offsets, you have the option to offset each payroll cycle event by a specified number of calendar or work days before or after the start date or the end date of the payroll period. For example, you might want to set the payroll run date three work days before the payroll end date, which accommodates differences in the number of days in the payroll period and also accounts for weekends and holidays.

Fixed-Date Offsets

The predefined Monthly (Calendar) payroll time period supports using both dynamic offsets and fixed-date offsets. Using fixed dates, you can adjust the exact date of each of the payroll cycle events for the first payroll period and any adjustments that you make will be reflected in the payroll calendar for subsequent payroll time periods. For example, you might set the cutoff date as the 25th of the month and the payroll run date as the 26th of the month, then all payroll periods in the calendar will have those offsets.

Specific Date Adjustments

Once you have generated the payroll time periods, you can further adjust any specific calendar dates, as desired. For example, if you know of a particular bank holiday that falls on a payroll run date or a payment date, you might want to adjust the dates manually on the payroll calendar's time period. You can make these adjustments when creating a payroll definition or any time after then, as long as the time period is in the future.

Creating Payroll Definitions: Worked Example

This example demonstrates how to create two payroll definitions for different payment frequencies that are associated with one consolidation group and one legislative data group.

The following table summarizes the key decisions for this scenario.


Decisions to Consider

In This Example

Which consolidation group should be used?

User-defined consolidation group:

InFusion US Emp Group

What is the legislative data group for the consolidation group?

User-defined legislative group:

InFusion US LDG

What are the payroll periods to use?

Predefined payroll period types:

Semimonthly

Monthly (Calendar)

What are the names of the new payroll definitions?

InFusion US Emp Semimonthly

InFusion US Emp Monthly

What is the name of the organization payment method to use for all employees?

User-defined payment methods:

InFusion US Emp Check

Infusion US Emp EFT

In this example, the InFusion US company is creating payrolls for its employees. There are two sets of employees, permanent employees who are paid a set amount on a semimonthly basis, and temporary employees that are paid using time card data on a monthly basis.

The business requires that a single monthly costing process be run against results from different payroll runs by using the consolidation group name as an input parameter in the costing run. This example creates two payroll definitions with different payment periods, but the same consolidation group. Both definitions are effective starting on 1/1/11 and will generate payroll time periods covering 5 years.

Prerequisites

  1. Ensure that the legislative data group for your payrolls exists, such as InFusion US LDG.
  2. Ensure that organization payment methods exist for your payrolls, such as InFusion US Emp Check and InFusion US Emp EFT.
  3. Create a consolidation group named InFusion US Emp Group assigned to the InFusion US LDG legislative data group.

Create the Payroll Definitions

Create two payroll definitions:

Perform the following steps twice, first using the semimonthly values and then using the monthly values.

  1. In the Payroll Calculation work area, click Manage Payroll Definitions.
  2. In the Search Results section of the Manage Payroll Definitions page, click the Createicon.
  3. Select the InFusion US LDG legislative data group from the list.
  4. Enter 1/1/11 as the effective start date you want the payroll to be available for use, and then click Continue.

    In this example, all employees that will use this payroll definition are hired after 1/1/11, so there is no issue with loading historical employee data.

  5. In the Basic Details section, complete the fields as shown in this table, and then click Next..

    Field

    Semimonthly Value

    Monthly Value

    Name

    InFusion US Emp Semimonthly

    InFusion US Emp Monthly

    Consolidation Group

    InFusion US Emp Group

    InFusion US Emp Group

    Period Type

    Semimonthly

    Monthly (Calendar)

    First Period End Date

    6/15/12

    6/30/12

    Default Payment Method

    InFusion US Emp EFT

    InFusion US Emp Check


  6. On the Payroll Offsets page, in the Number of Years field, enter 5.
  7. For the semimonthly payroll, use dynamic variables to define offsets as shown in this table, and then click Next.

    Field

    Falls Value

    Day Type Value

    Offset Value

    Base Date Value

    Cutoff Date

    5

    Work Days

    Before

    Period End Date

    Payroll Run Date

    3

    Work Days

    Before

    Period End Date


  8. For the monthly payroll, use fixed dates to define offsets as shown in this table, and then click Next.

    Field

    Value

    Fixed Date

    Yes

    Cutoff Date

    6/25/12

    Date Earned

    6/30/12

    Payroll Run Date

    6/27/12

    Date Paid

    6/30/12


  9. On the Payroll Calendar page, adjust payroll days to account for a bank holiday, as shown in this table.

    Column

    Semimonthly Value

    Monthly Value

    Payroll Run Date

    Old Value: 11/28/13

    New Value: 11/27/13

    Old Value: 5/27/13

    New Value: 5/28/13


  10. Click Next.
  11. Review the details of the payroll definition, and then click Submit.

FAQs for Define Pay Frequency

When would I close a payroll period?

Closing a payroll period can interfere with changes to recurring entries. Payroll periods are not like General Ledger periods. You do not need to close payroll periods.

Why can't I select a payment method when creating a payroll definition?

There are two reasons why you might not be able to view and select the payment method you are looking for. Either the start date of the payroll definition is before the start date of the organization payment method or the organization payment method has no associated payment source.

Manage User-Defined Tables

Creating a User-Defined Table for Matched Row Values: Example

This example illustrates how to create a user-defined table to store values for workers schedules.

Scenario

Your organization works on a 10 hour a day, four day a week rotating schedule. The employees work for four consecutive days, 10 hours a day.

User-Defined Table Components

The main components of the user-defined table are the definition, columns, rows, and values.

Analysis

In this example, you will construct a user-defined table containing the schedules available in your organization.

This figure illustrates the user-defined table containing the various schedules that your organization offers.

User-defined table structure for matched
row values

Resulting User-Defined Table Components

This user-defined table definition consists of the following:

The user-defined columns are named the days of the week that the employee works. The data type for each column is number. The date type reflects the data type of the values that will be entered in each column.

There are seven user-defined rows containing the exact value of a day of the week.

The values are the scheduled hours for each day of the week. Since the employees only work four consecutive days of ten hours each, there can only be four different schedules. Each column contains the scheduled hours for each day of the week represented in the row.

Creating a User-Defined Table for a Range of Row Values: Example

This example illustrates how to create a user-defined table to store values for stock option allocations.

Scenario

Each year, your organization offers stock options to its employees. The amount of options depends on years of service and job category of the employee receiving them.

User-Defined Table Components

The main components of the user-defined table are the definition, columns, rows, and values.

Analysis

In this example, you will construct a user-defined table containing stock option allocations by job category and years of service.

This figure illustrates the user-defined table containing the stock option allocation that your organization offers.

User-defined table structure for a
range of row values

Resulting User-Defined Table Components

This user-defined table definition consists of the following:

The user-defined columns are named for each job category. The data type for each column is number. The date type reflects the data type of the values in each column.

There are seven user-defined rows containing the range of years of service allotting the same amount of stock options.

The values are the number of stock options. There are only four job categories, in this example. Each column contains the stock option allocation for each job category based on the range of service years.

Define Fast Formulas

Using Formulas: Explained

Fast formulas are generic expressions of calculations or comparisons that you want to repeat with different input variables.

You can use fast formulas to:

Calculate Payrolls

Write payroll calculations and skip rules for elements that you define to represent earnings and deductions. Associate more than one formula with each element to perform different processing for employee assignments with different statuses. You can define elements and formulas for earnings and deductions with highly complex calculations requiring a number of different calls to the database.

Define the Rules for Paid Time Off Accrual Plans

Edit the delivered accrual type formulas or write your own. Each accrual plan needs two formulas: one to calculate the gross accrual and the other to return information to the PTO carry-over process.

Define Custom Calculations for Benefits Administration

Configure your plan design to the requirements of your enterprise. Formulas provide a flexible alternative to the delivered business rules for such purposes as:

For example, you can write a formula to calculate benefits eligibility for those cases where the provided eligibility criteria does not accommodate your particular requirements.

For more information, see Benefits Fast Formula Reference Guide (1456985.1) on My Oracle Support at https://support.oracle.com.

Validate Element Inputs or User-Defined Tables

Validate user entries into element input values using lookups or maximum and minimum values. However, for more complex validations write a formula to check the entry. Also, use a formula to validate entries in user tables.

Edit the Rules for Populating Work Relationship or Payroll Relationship Groups

Define criteria to dynamically populate a payroll relationship group or work relationship group. When you create a formula of type Payroll Relationship Group or Work Relationship Group, the Create Fast Formula page provides an expression editor to help you build the selection criteria.

Calculate Absence Duration

Calculate the duration of an absence from the start and end dates.

Define Custom Configuration for Compensation

Extend the existing flexibility of compensation plan configuration by writing formulas to customize:

Writing a Fast Formula Using Formula Text: Worked Example

This example demonstrates, using the text editor, how to create a fast formula that returns the range of scheduled hours for managers and a different range for other workers.

The following table summarizes key decisions for this scenario:


Decisions to Consider

In This Example

Is the formula for a specific legislative data group?

No, this is a global formula that can be used by any legislative data group.

What is the formula type for this formula?

Range of Scheduled Hours

Are there any contexts used in this formula?

No

Are there any database item defaults?

Yes, ASG_JOB

Are there any input value defaults?

No

What are the return values?

MIN_HOURS, MAX_HOURS, FREQUENCY

Creating a Fast Formula Using the Text Editor to Determine a Manager's Scheduled Hours

  1. On the Payroll Calculation Tasks page, click Manage Fast Formulas to open the Manage Fast Formulas page.
  2. On the Manage Fast Formula page, click the Create icon to create a new formula.
  3. On the Create Fast Formula page, complete the fields as shown in this table.

    Field

    Value

    Formula Name

    Manager Range of Scheduled Hours

    Formula Type

    Range of Scheduled Hours

    Description

    Manager's Range of Hours

    Effective Start Date

    1-Jan-2010


  4. Click Continue.
  5. Enter the following formula details in the Formula Text section:
    /* DATABASE ITEM DEFAULTS BEGIN */
    DEFAULT FOR asg_job IS ' '
    /* DATABASE ITEM DEFAULTS END */
    JOB_1 = ASG_JOB
    IF JOB_1 = 'Manager' then
    (MIN_HOURS = 25
    MAX_HOURS = 40
    FREQUENCY = 'H')
    else
    (MIN_HOURS = 20
    MAX_HOURS = 35
    FREQUENCY = 'H')
    return MIN_HOURS, MAX_HOURS, FREQUENCY

     

  6. Click Compile.
  7. Click Save.

Writing a Fast Formula using Expression Editor: Worked Example

This example demonstrates how to create a fast formula that groups executive workers for reporting and processing. All executive workers are in department EXECT_10000. Once the formula is created it will be added as object group parameters so that only those workers in department EXECT_10000 are used in processing.

The following table summarizes key decisions for this scenario:


Decisions to Consider

In This Example

Is the formula for a specific legislative data group?

Yes, InVision

What is the formula type for this formula?

Payroll Relationship Group

Creating a Fast Formula Using the Expression Editor

  1. On the Payroll Calculation Tasks page, click Manage Fast Formulas to open the Manage Fast Formulas page.
  2. On the Manage Fast Formula page, click the Create icon to create a new formula.
  3. On the Create Fast Formula page, complete the fields as shown in this table.

    Field

    Value

    Formula Name

    Executive Payroll Relationship Group

    Type

    Payroll Relationship Group

    Description

    Executive Workers

    Legislative Data Group

    Vision LDG

    Effective As-of Date

    1-Jan-2010


  4. Click Continue.
  5. In the Formula Details section, click Add After to add a row to enter the fields in this table.

    Conjunction

    Database Item Name

    Data Type

    Operand

    Literal Value

    IF

    DEPARTMENT

    Character

    =

    'EXECT_10000'

    Then

    SELECT_EMP

    Character

    =

    'YES'

    ELSE

    SELECT_EMP

    Character

    =

    'NO'


  6. Click Compile.
  7. Click Save.

Formula Compilation Errors: Explained

Compilation errors display in the Manage Fast Formulas page when you compile the formula. The formula compiler returns line numbers starting at 1 from the beginning of a formula, and character positions starting at 1 from the beginning of a line in its error messages. The compiler aborts compilation when an error is encountered.

Common Compilation Errors

This table lists the type and description of several common formula compilation errors.


Formula Error

Description

Syntax Error

The formula text violates the grammatical rules for the formula language. An example is using IF1 instead of IF for an IF statement.

Incorrect Statement Order

ALIAS, DEFAULT, or INPUT statements come after other statements.

Misuse of ASSIGNMENT Statement

Occurs when any of these conditions occurs:

  • An ASSIGNMENT assigns a value to a database item.

  • A context is assigned a value externally to a CHANGE-CONTEXTS statement.

  • A non-context variable is assigned a value within a CHANGE-CONTEXTS statement.

Misuse of ALIAS Statement

An ALIAS statement may only be used for a database item.

Missing DEFAULT Statement

A database item with defaulting specified must have a DEFAULT statement.

Misuse of DEFAULT Statement

A DEFAULT statement is specified for a variable other than an input or database item.

Uninitialized Variable

The compiler detects that a variable is uninitialized when used. The compiler cannot do this in all cases. This error often occurs when you want to use a database item, but a database item is not available in the formula.

Missing Function Call

A function call is not recognized. The combination of return type, function name, and parameter types does not match any available function.

Incorrect Operator Usage

An instance of a formula operator use does not match the permitted uses of that operator.

For example, the + operator has two permitted uses. The operands are both of data type NUMBER, or both of data type TEXT.

Inconsistent Data Type Usage

A formula variable is being used as if it is of more than one data type. Or a database item or context is being used with the wrong data type.

For example, Variable A is assigned a NUMBER value at the start of the formula, but a TEXT value later in the formula.

EXIT Statement Not Within WHILE Loop

A condition that eventually becomes false, or an EXIT call for exiting the loop does not exist.

Misuse of Context

A variable is used as a context, or a context is used as a variable.

For example, AREA1 is assigned a value as an ordinary variable, but later in the formula AREA1 used as a context in a GET_CONTEXT call.

Formula Execution Errors: Explained

Fast formula execution errors occur when a problem arises while a formula is running. The usual cause is a data problem, either in the formula or in the application database. These errors contain the formula line number where the error occurs.

Formula Execution Errors

This table lists the type and description of each formula execution error.


Formula Error

Description

Uninitialized Variable

Where the formula compiler cannot fully determine if a variable or context is initialized when it is used, it generates code to test if the variable is initialized.

When the formula executes and the variable or context is not initialized an error is raised.

Divide by Zero

Raised when a numeric value is divided by zero.

No Data Found

Raised when a non-array type database item unexpectedly fails to return any data. If the database item can return no data then it should allow defaulting.

This error is also raised from within a formula function. The cause is an error in the formula function code.

Too Many Rows

Raised when a non-array type database item unexpectedly returns more than a single row of data. The cause is an incorrect assumption made about the data being accessed.

This error can also be raised from within a formula function. The cause is an error in the formula function code.

NULL Data Found

Raised when a database item unexpectedly returns a NULL data value. If the database item can return a NULL value then defaulting is allowed.

Value Exceeded Allowable Range

Raised for a variety of reasons, such as exceeding the maximum allowable length of a string.

Invalid Number

Raised when an attempt is made to convert a non numeric string to a number.

User Defined Function Error

Raised from within a formula function. The error message text is output as part of the formula error message.

External Function Call Error

A formula function returned an error, but did not provide any additional information to the formula code. The function might have output error information to the logging destination for the executing code.

Function Returned NULL Value

A formula function returned a NULL value.

Too Many Iterations

A single WHILE loop, or a combination of WHILE loops, has exceeded the maximum number of permitted iterations. The error is raised to terminate loops that could never end. This indicates a programming error within the formula.

Array Data Value Not Set

The formula attempted to access an array index that has no data value. This is an error in the formula code.

Invalid Type Parameter for WSA_EXISTS

An invalid data type was specified in the WSA_EXISTS call.

Incorrect Data Type For Stored Item

When retrieving an item using WSA_GET, the items actual data type does not match that of the stored item. This is an error within the calling formula.

Called Formula Not Found

The called formula could not be resolved when attempting to call a formula from a formula. This could be due to an error in the calling formula, or because of installation issues.

Recursive Formula Call

An attempt was made to call a formula from itself. The call could be directly or indirectly via another called formula. Recursive formula calling is not permitted.

Input Has Different Types In Called and Calling Formulas

When calling a formula from a formula, the actual formula input data type within the called formula does not match the data type specified from the calling formula.

Output Has Different Types In Called and Calling Formulas

When calling a formula from a formula, the actual formula output data type within the called formula does not match the data type specified from the calling formula.

Too Many Formula Calls

There are two many formula from formula calls. This is due to a problem with the formulas.

FAQs for Define Fast Formulas

When do I run the Compile Formula process?

If you need to compile many fast formulas at the same time, you can run the Compile Formula process on the Submit a Process or Report page. Also, if you make any changes to a function after you have compiled a formula that uses it, you need to recompile the formula for the changes to take effect.

What's the difference between a formula compilation error and an execution error?

Compilation errors occur in the Manage Fast Formulas page when you compile the formula. An error message explains the nature of the error. Common compilation errors are syntax errors resulting from typing mistakes.

Execution errors occur when a problem arises while a formula is running. The usual cause is a data problem, either in the formula or in the application database.

Define Balance Definitions

Balance Definitions: Explained

Payroll balances show the accumulation of values over a period of time. The values can be currency, hours, or any other numeric value. You manage balance definitions from the Payroll Calculation work area. Most of the balances you require are predefined and additional balances are created automatically when you create elements. You can edit the definition of these generated balances, or create additional balances for calculations or reporting.

When you create a balance definition, you select the balance category and a unit of measure. Each balance definition is grouped in a predefined balance category for quicker processing. Balance categories are legislation-specific and cannot be modified. The predefined units of measure available for selection are Day, Hour (with different combinations of minutes and seconds), Integer, Money, and Number.

Important aspects of balance definitions are:

Balance Dimensions

Each balance can have multiple dimensions, which define the specific value to be retrieved. Balance dimensions are predefined and typically combine these components:

For example, if you select the dimension Core Assignment Tax Unit Year to Date for the balance Gross Earnings, you create the defined balance GROSS_EARNINGS_ASG_TU_YTD, which accumulates gross earnings for an assignment in a specific tax reporting unit from the beginning of the calendar year to date.

Balance Feeds

You can define balance feeds by element input values or by balance classification run results.

For any balance that you need to initialize, regardless of whether it is fed by elements or classifications during normal processing, you can select elements to feed it for balance initialization purposes only. Select one element for each level of the employment hierarchy associated with a dimension that you want to initialize.

Generated Balances and Database Items

When you create elements, balances and balance feeds are created automatically as determined by the element template. A database item is generated automatically for each balance dimension. You can use the database items in your formulas to check the value of a balance.

Base Balances

You can specify a base balance when there is a relationship between balances that can be relied on when processing and reporting. For example, Loan Repayment could be the base balance for Loan Repayment Arrears.

Remuneration

One balance in a legislation is predefined as the remuneration balance, which is used to generate payments for employees. For example, the remuneration balance might be Net Pay, which is a calculated balance that is the sum of standard earnings and supplemental earnings minus all the deductions calculated for the run.

Important

Setting the Use for Remuneration option to Yes means the balance will be defined as the remuneration balance. Only one balance in a legislation can be the remuneration balance.

Load Initial Balances

Initial Balance Loading: Explained

Setting initial balances values is an essential task when you migrate payroll data from another system. First you load balance values into batch views then submit the Load Initial Balances process from the Payroll Calculation work area. The process validates then processes the batch.

Balance Initialization Elements

For each balance to be initialized, you must create elements in the Balance Initialization classification and add them to the balance as balance feeds. You can create up to three elements: one to initialize assignment level balances, one for employment terms level, and one for payroll relationship level.

Each balance initialization element must:

Batch Views

Populate the batch views with the balance values for the initialization date. You can use the Batch Loader spreadsheet, or populate the batch directly using the API in the PAY_BALANCE_BATCH_LINES_PKG API package. You can download the Batch Loader spreadsheet in the Payroll Administration work area.

The views are:

Important

The PAY_BALANCE_BATCH_LINES view has a complex definition and cannot be directly inserted into. You must use the Batch Loader spreadsheet or API.

When you create the batch header and lines, consider the following points:

Initial Balances: How They Are Loaded

The Load Initial Balances process validates then processes the initial balance values you load into batch views. It creates balance adjustments to set the required values.

Settings That Affect Initial Balances

The data you load into the batch views determines which defined balances are initialized and the values used. Typically, you group employees into batches to manage the initialization of their balances.

How the Balances Are Initialized

The Load Initial Balances process validates that the entities referenced in the batch data exist, including balances, balance dimensions, tax reporting units, payrolls, payroll relationships, employment terms, and assignments. It checks that values are available for the contexts used by each balance dimension. It does not check, for example, that an employee is assigned to a specified organization. It sets the status of valid batch lines to V.

The process creates balance adjustments. For all the batch lines it successfully processes, the process sets the status to T and updates the PAYROLL_REL_ACTION_ID to point to the balance adjustment.

Examples

The following table shows a simple three-line batch loaded on 18 June.


Defined Balance

Value

Total_Earnings_PTD

100

Total_Earnings_QTD

250

Total_Earnings_YTD

500

For this batch, the process creates an adjustment on the first day of the time period relevant to each dimension, as shown in the following table:


Adjustment Date

Adjustment Value

Balances Adjusted

1 June

100

Total_Earnings_PTD

Total_Earnings_QTD

Total_Earnings_YTD

1 April

150

Total_Earnings_QTD

Total_Earnings_YTD

1 Jan

250

Total_Earnings_YTD

Balance Batch Header and Lines Views

The PAY_BALANCE_BATCH_HEADER and PAY_BALANCE_BATCH_LINES views hold the data used by the Load Initial Balances process to initialize balance values.

You must load data into these views using the Batch Loader spreadsheet or API in the PAY_BALANCE_BATCH_LINES_PKG PL/SQL package. Create each batch line with a BATCH_LINE_STATUS of U (unprocessed) and leave the PAYROLL_REL_ACTION_ID column blank. The batch upload process updates these two columns.

Required Columns

Note

You can view the full column listing by querying the view in the Oracle Enterprise Repository at https://fusionappsoer.oracle.com/oer/.

In PAY_BALANCE_BATCH_LINES, the columns shown in the following table are required. Where there is both an ID column and a name column for the same entity, for example, PAYROLL_ASSIGNMENT_ID and ASSIGNMENT_NUMBER, you can populate either column, but you must populate at least one. If the ID column is left blank, the batch upload process uses the name column value to derive the ID value.


Column

Comments

PAYROLL_RELATIONSHIP_ID + PAYROLL_RELATIONSHIP_NUMBER

Identify the payroll relationship for this balance value.

BALANCE_TYPE_ID + BALANCE_NAME

Identify the balance for this balance value.

BALANCE_DIMENSION_ID + DIMENSION_NAME

Identify the balance dimension for this balance value. DIMENSION_NAME should be populated with the localization's dimension usage dimension name rather than the core DIMENSION_NAME held on PAY_BALANCE_DIMENSIONS.

VALUE

Identify the numerical value of the balance on the upload date.

UPLOAD_DATE

Identify the date of the balance value. This date must be on or before the upload date for the batch header.

PAYROLL_ID + PAYROLL_NAME

Identify the context required for evaluating a balance value, even though it may not be a context for the dimension.

Core Context

The core contexts shown in the following table must be populated if the balance dimension expects a value for this context.


Column

Comment

PAYROLL_TERM_ID + TERM_NUMBER

Identify the payroll term for this balance value, if required. Where there is both an ID column and a number column for the same entity, you can populate either column, but you must populate at least one.

PAYROLL_ASSIGNMENT_ID + ASSIGNMENT_NUMBER

Identify the payroll assignment for this balance value, if required.

LEGAL_EMPLOYER_ID + LEGAL_EMPLOYER_NAME

 

TAX_UNIT_ID + TAX_UNIT_NAME

 

AREA1 + AREA2 + AREA3 + AREA4

Identify state and country code information. In Oracle E-Business Suite these items were STATE_CODE, COUNTY_CODE and so on.

THIRD_PARTY_PAYEE_ID + THIRD_PARTY_PAYEE_NAME

 

TIME_DEFINITION_ID + TIME_DEFINITION_NAME

 

RUN_TYPE_NAME + RUN_TYPE_ID

 

ELEMENT_ENTRY_ID

 

BALANCE_DATE

 

CALC_BREAKDOWN_ID

Identify the ID associated with payroll term.

Legislative or User-defined Context Columns

There are six legislative or user-defined contexts, which must be populated if the balance dimension expects a value for these contexts. For each context, there is a context ID, name, and value. For example:

Note

The values of the core contexts are the IDs themselves, while the values of the legislative contexts are separate from the ID of the context.

Populate CONTEXT[1-6]_NAME with the name of the context usage for that legislative or user-defined context, and CONTEXT[1-6]_VALUE with the actual value of that context.

Define Earning and Deduction Definitions

Element Classification Components: How They Work Together

Elements are grouped into primary classifications, such as Earnings and Voluntary Deductions. In a human resources department, you can use the primary classifications to identify groups of elements for information and analysis purposes. In a payroll department, the classifications control processing, including the sequence in which elements are processed and the balances they feed.

Primary Classifications

Oracle Fusion provides you with these primary classifications and some balances, mainly to reflect tax legislation. They are designed to meet the legislative requirements of your country, so you cannot change them. You can create additional balances to be fed by any of the primary classifications.

Secondary Classifications

Secondary classifications are subsets of the primary classifications. Use them to manage wage basis rules for deductions and taxes. Many legislations have predefined secondary classifications, and a few allow you to create your own. As with primary classifications, you cannot remove or change any predefined secondary classifications.

Subclassifications

Subclassifications provide a way to feed balances. Elements can have only one primary and secondary classification, but multiple subclassifications. You can create subclassifications or use predefined ones. Once a subclassification is associated with a classification it cannot be associated with another classification. A subclassification name can be reused under different primary classifications, but you will have to create separate balance feeds for each subclassification with the same name.

Costing

If the classification is set to allow costing, you can select any costing option for element eligibility records. You can create distribution groups with elements that have a primary classification that allows distribution. For example, you can create a distribution with all of the earnings elements and prorate tax expenses proportionately over the cost centers in which the wages were earned. The primary classification also determines whether a positive amount is costed as a debit or a credit.

Frequency Rules

Use frequency rules on an element that is not scheduled to process each period. For example, the rules for a weekly payroll could indicate that the element entries for that element would only be processed on the first and third payroll periods of each month. The default frequency rule is always each period.

Element Processing Sequence: How it is Determined

Payroll runs process elements in a predefined sequence, which you can determine.

How Processing Order Is Determined

An element's primary classification defines a default processing priority for the element in payroll runs. Lower priority numbers process first

Overriding Default Processing Priority

Most classifications also have a priority range. When you define an element in these classifications, you can overwrite its default processing priority with another number from the range. This is useful if you need to establish the order in which the element processes with respect to other elements in the classification

Sometimes you must prioritize the processing of certain element entries for an individual person. For example, you may need to determine the precise order in which deductions taken for wage attachments process for a person. You can enter a subpriority number for element entries.

Manage Elements

Elements: How They Work in Salary, Absence, Benefits, and Payroll

Elements are building blocks that help determine the payment of base pay, benefits, absences, and other earnings and deductions. The components of elements are set up differently based on how the element is to be used.

Element build blocks for Base Pay Management,
Absence and Accruals, Benefits, and Payroll applications

Base Pay Management

To manage base pay, you attach a single earning element to each salary basis to hold base pay earnings, and assign a salary basis to each worker. When a manager or compensation specialist enters a base pay amount for a worker, the amount is written to the payroll element input value associated with the worker's salary basis and used in payroll processing to generate payment amounts.

Absence and Accruals

You can manage employee absences and leave time. To facilitate reporting and analysis of employee absences, you can distinguish between absence categories, absence types, and absence reasons. You can associate an absence type with an element to maintain an absence balance for an employee. You can associate absence types and other elements with accrual plans to determine the net accrual of an employee.

Benefits

Attach elements at various levels in the benefits object hierarchy to create deductions and earnings that can be processed in a payroll run to calculate net pay.

Payroll

For Oracle Fusion Global Payroll, you define earning and deduction elements, such as bonus and overtime earnings and involuntary deductions. These elements incorporate all the components required for payroll processing, including formulas, balances, and formula result rules.

Elements: Explained

Elements are the building blocks of payroll and benefits. There is no limit to the number of elements you can define. You define the policies or business rules that govern the allocation of these elements to your workers.

Elements can represent:

Oracle Fusion supplies many predefined elements while additional elements are generated when you define certain types of compensation and payroll elements through templates.

Predefined Elements

The predefined elements are specific to your localization. They typically include deductions for tax and wage attachments. You cannot make any changes to these predefined elements.

Element Creation

You can create many earnings and deductions from element templates. The templates include the elements, balances, balance feeds, and formulas required for payroll processing. You can configure any of these definitions to match your specific business requirements.

The components of an element's definition are available for entry based on the primary and secondary classification you select, for example a standard earning. This diagram illustrates element definition components and what is defined in each component.

Element definition components

For example, you can define an element called Wage, for hourly paid workers. You classify the element in the predefined classification Earnings, which determines when it is processed in the payroll run and what payroll balances it feeds.

You must specify at least one input value, in this case Hours Worked, which must be entered in each payroll period. If required, you can define multiple input values with fixed values, defaults, or validation.

You associate a formula with the element, to calculate the wage for the payroll period. A simple formula might be hours worked, from the input value, multiplied by an hourly rate, from compensation information on the employment record. You define who is eligible for the element by assigning eligibility criteria to various components in the persons employment record, such as grade, payroll, salary basis, or organization. In this example, the wage element is available to all persons on the weekly payroll.

Element Input Values: Explained

An element's input values defines the entry values available on each entry of this element. Each input value has a unit of measure defined, and can have validations and conditions defined to control the data entry of the element entry assigned to a person. For example, an earnings element may have an input value for hours worked, which is defined as required and has a unit of measure of number.

When you create an element, some input values are created automatically if you use Oracle Fusion Global Payroll or Oracle Fusion Global Payroll Interface. For Global Payroll Interface, this applies to earnings elements only. You can create additional input values for any element, as needed.

Input Value Options

For each input value created you can modify these attributes:


Field

Purpose

Display Sequence

Control the order in which the entry value is displayed on element entries.

Special Purpose

Identify how an input value is used, irrespective of the name given to it. For example, it identifies if the input value holds a percentage value, a rate, or third-party payee details. It basically assists with processing the input value based on what type of information it holds.

Unit of Measure

Select the value that describes the type of value the entry value can hold, such as number or character.

Displayed

Select to display the input value on the element entry.

Allow User Entry

Select to enter values on element entries.

Required

Select to make the input value a required entry value on the element entry. If you select Required, you must also select Displayed and Allow User Entry.

Create a Database Item

Select to have a database item created for the input value to make the values available for formulas or system extract.

Default

Enter a value that appears as the default value for this entry value in element entries, if needed.

Apply default at runtime

Select to have the default set on the element entry when the payroll process is run. Changes to the default value are reflected in the next processing after the effective date of the change.

You can replace the default at runtime functionality by manually providing an entry value on the element entry.

Minimum

Enter a minimum value for the element, if needed.

Maximum

Enter a maximum value for the element, if needed.

Validation Formula

Enter a formula that validates the entry value entered on element entries, if needed.

Validation Source

Use with the other input value options to select the valid validation method, such as lookups or formulas.

Lookup Type

Specify a lookup type to provide a list of values for an element entry value.

Warning or Error

Use when you are validating the input value or entering a minimum or maximum value. It specifies whether a warning or an error displays if the entry fails the validation condition or does not meet the minimum or maximum value indicated.

Reference

Use to associate a balance context with the run result. For example, if you want to associate a context, such as jurisdiction, with an element; create an input value for jurisdiction and select the jurisdiction context in the reference field. Then the run result value of the input value will work as context value when updating the balance.

If you select a reference then the lookup type and validation source values should be automatically set to the reference context. You need to provide the reference field first for the validation source value to be automatically populated.

Note

Once an element is processed, you cannot update certain input value attributes, such as unit of measure. This ensures that changing certain attributes will not invalidate prior results.

Maintaining Elements: Explained

After you have defined and used an element, updates to the element are limited to ensure the integrity of the element for retroactive processing and the balances of the input values. You cannot remove existing input values or add new ones if you have created entries for the element. You must add an input value to an element before you create any element entries, or set the element entries effective date to the element's start date.

You can make the following changes to an element that has been previously processed:

Determining Entry Values for an Element: Critical Choices

You can select rules for the element's entry value to define how you can update the element entries. The options are:

Automatic Entry

Entry values can be automatically added in element entries in three ways.

  1. Elements can be defined to default an input value at creation. The user defining the element can specify the entry value to be defaulted when an element entry is created. Users can override or change the default at any time. Changes to this type of a default value on the element do not affect existing element entries.

  2. Elements can be defined to default an input value at run time. When this is selected, the element will automatically default the element entry value. `This value can be updated if needed. A change to the default value for an input value set to default at run time will automatically change the value to be applied at run time for everybody with an entry for that element.

  3. Some entry values are automatically created by a service or process used with compensation, benefits, or formula results.

Important

An element with automatic entry allowed cannot allow multiple entries in the same period.

Allow Multiple Entries in Same Period

This option allows you to give a person more than one entry of the element in the same pay period. For example, if you enter overtime hours on a weekly basis for monthly-paid persons, you might need to give a person five entries of an overtime element in each period.

If you are creating a net-to-gross element, you must select Allow multiple entries in same period.

Additional Entry

This option allows you to add an occasional one time entry for recurring elements. This additional entry can override or add to the normal entry amount.

Element Result Rule Options: Explained

At minimum, an element needs one standard processing rule. This identifies the formula the payroll run uses to process the element for persons with an active employment record. It is also the default formula for other assignment statuses. However, you can define additional processing rules if you need to use different formulas for assignments at other statuses. For example, you could have two rules for a Wages element: Standard Wages and Paid Training Leave.

You can add one or more of the following optional results rules to an element:

For all formula result types except Direct Result or Message, select the target element name to which you want to pass the formula result. This element must have a processing priority causing it to process after the element sending the result.

For the formula result types Direct Result, Indirect Result, and Target Indirect, select the target input value to update.

Direct Result Rule

This is the element's run result, or a direct result updating one of the element's input values.

Indirect Result Rule

This result passes as an element entry to another nonrecurring element not yet processed.

Message Rule

The formula issues messages under certain conditions. For example, a formula can check a loan repayment balance and, if the balance is zero, issue the message "Loan is repaid."

There are three severity levels for a message rule:

Order Indirect Rule

This result updates the subpriority of the element you select in the Target Element Name field.

Stop

This formula result uses the Date Earned of the payroll run to put an end date on a recurring entry of this or another element (which must be defined with Allow Multiple Entries not selected).

Target Indirect

This result updates recurring entries of this or another element on the effective date of the payroll run. The receiving element must be defined with Allow Multiple Entries not selected unless you are passing a recurring element's entries to itself, that is updating another entry of the same element. With this result rule, any future-dated changes to the entry will be overwritten by the results of the current payroll run.

Determining an Element's Latest Entry Date: Critical Choices

An element's latest entry date determines how element entries process after a person is terminated or transferred to another payroll. The options are:

Note

These are the predefined options, you can create others that fit your business needs.

Final Close

This option allows the element to stay open for entries beyond a persons last day worked. For example, you want the element to stay open to pay a severance package to a terminated person.

Last Standard Earning Date

This option stops all element entries on the date the person leaves. It is recommended to use this option for recurring entries such as salary.

Note

When you select the Last Standard Earning Date, also select proration for the element. This ensures the element is processed for proration purposes, even if it is not active at the end of a payroll period.

Last Standard Process Date

The last standard process date defaults to the last day of the pay period in which the person is terminated, but you can set it to a later period when you terminate a person. It enables all element entries to stop on the last standard process date or on the date the assignment ends, if this is earlier.

Note

This option is only available for Oracle Fusion Global Payroll users.

Element Eligibility: Explained

Element eligibility determines which people are eligible for an element. To determine eligibility, you assign element eligibility criteria to the components that persons must have to receive entries of the element. While some elements may represent compensation, deductions, and equipment available to all persons, many elements are available only to certain groups of persons. For example, your enterprise might provide company cars only to persons in the Sales Department. Eligibility criteria rule out the possibility of persons getting element entries by mistake. For example, you might want to give a production bonus only to those persons who work full time in Production and are on the weekly payroll. To do this you would define eligibility criteria for the element Production Bonus and the combination of the Production organization, the Full-Time assignment category, and the Weekly payroll.

Eligibility Criteria

Element eligibility can be assigned by many different criteria.

Note

In order to enter an element for a worker, you must define element eligibility for every element. This must be done for predefined elements and those you define. If you want the element to be available to all workers, you can save the element eligibility record with no criteria selected. This is the usual practice for compensation and benefit elements where you determine eligibility using eligibility profiles.

Multiple Rules of Eligibility

You can define more than one eligibility criteria for each element but there must be no overlap between them. For example, you could create one criteria for the combination of grade A and the job Accountant. However, you could not create one criteria for grade A and a second for the job Accountant. This would imply that an accountant on grade A is eligible for the same element twice. If you have more than one criteria for an element, you can enter different default values, qualifying conditions, and costing information for each eligibility group.

Maintaining Element Eligibility: Explained

Element eligibility rules always control element entries.

After you have used an element you can make the following changes to the eligibility rules:

Element Proration: Explained

Proration is the calculation of proportionate element amounts whenever payroll-relevant data is changed during a payroll period. For example, a person joining or leaving the company or a change of pay grade, mid-payroll period, could trigger proration. You add a proration formula to the element and add the element to a proration event group.

Proration Formula

The proration formula determines how to prorate the element. For example, you can prorate based on hours in a pay period or days in a pay period. You can either use a payroll formula that handles proration, or create a separate proration formula that runs after the main payroll formula only in payroll periods in which a proration event occurs.

Proration Event Group

You must assign an event group to an element to prorate it. When you define the event group, you select the events that activate proration calculation, such as hiring a person or terminating employment.

Gross-Up Earning: How It Is Calculated

Gross-up functionality enables you to calculate the gross earnings required to generate a specified net pay for a given earning, if you need to pay a person a guaranteed take home pay (net) per payroll period, or to pay a specified bonus of a set amount (net amount). You define which taxes and other deductions the employer is willing to pay by selecting the balances that can be used in the net-to-gross processing.

Settings That Affect Gross-Up Earning Element

Follow these steps to set up elements for gross-up processing.

  1. On the Standard Rules section of the earning element, define the element with the following criteria:

  2. On the Duration Rules section define the Latest Entry Date to be Final Close.

  3. On the Advanced Rules section, define the element with the following criteria:

  4. Chose the following input values for the element:


    Input Value Name

    Purpose of Entry

    Pay Value

    The gross pay is returned to this input value when it has completed the gross-up calculations.

    Amount

    The amount gives the iterative formula the desired net pay.

    Low Gross

    The low gross is used by the iterative formula to hold the lower gross pay guess, to feed into the next iteration of the formula.

    High Gross

    Used by the iterative formula to hold the higher gross pay guess, to feed into the next iteration of the formula.

    Remainder

    The amount by which the additional pay to be paid by the employer (gross minus desired net) differs from the total of the balances that are eligible for gross-up processing. Returned by the iterative formula.

    To Within

    The amount by which actual net can differ from desired net after normal processing. Must not be zero but can be a nominal amount such as 0.01.

    Method

    The method of iterative calculation: binary or interpolation. This determines which function the iterative formula calls. Use the lookup type ITERATIVE_METHOD and select the default interpolation, since this is usually the more efficient method.

    Additional Amount

    The amount to add to desired net to calculate gross pay. Returned by the iterative formula.

  5. Define element eligibility rules.

  6. On the Processing Rule section, enter the following formulas:

  7. On the Balance Feeds section, confirm which balances feed your gross-up element.

  8. On the Gross Balance Exclusions section, select the deductions to be paid by the employer.

How Gross-Up Earning Is Calculated

The formulas for Net-to-Gross processing do the following:

Absence Processing in Payroll Runs: Critical Choices

When you create an absence element for an absence type, your choice of element classification determines how absence entries display on the statement of earnings. You must use one of the following classifications:

Using the Information or Absence Classification

Use either of these classifications if you want to:

Note

Although both the Information classification and Absence classification work in the same way, you can select either classification depending on your reporting requirement.

Since payroll runs do not process elements in the Information or Absence classifications, you can use an Earnings element to manage the calculation and payment of absences. For example, you can define a skip rule for an Earnings element that triggers processing when it finds an entry for the absence element. The payroll formula associated with the Earnings element uses the database item of the absence element to retrieve the total number of absences. Then the formula uses another database item to retrieve the salary or hourly rate to calculate the total absence pay for the period and, if necessary, reduce the regular earnings.

The following figure depicts the relation between the Absence element, Earnings element, skip rules, and the payroll formula associated with the Earnings element:

Relation between the absence element,
earnings element, skip rules, and the payroll formula associated with
the earnings element

Using the Standard Earnings Classification

Use this classification if you want to:

This approach creates a one-line entry on the statement of earnings for each absence type. For example, you can use this classification if your employees submit timecards, and you want absences taken by these employees to show on the statement of earnings.

Recurring and Nonrecurring Absence Elements: Critical Choices

When you set up an absence type, you can determine how absences are processed in payroll runs. Choose the type of element to associate with the absence type:

Using a Nonrecurring Absence Element

Nonrecurring absence elements are valid for the payroll period in which the absence starts. The application creates the entry only when you enter the absence end date. The element entry records the full value of the absence duration even if the end date falls beyond the payroll period.

For example, if you enter an absence that starts on May 24 and ends on June 5 for someone on a monthly payroll, the element entry is dated May 1 to May 31 and records the full value of the absence duration (13 days).

Using a Recurring Absence Element

Use a recurring absence element if you want the payroll run to process absences that have not ended. To process the absence element and calculate the absence duration in each payroll period, you use a payroll formula that handles proration.

Recurring absence element entries start on the absence start date and end on the absence end date (if there is an end date). If the absence starts or ends in the middle of a payroll period, the payroll run detects and processes the absence using the proration functionality.

Creating Earnings Elements for Payroll: Worked Example

The example shows how payroll managers create a regular earnings element using an element template.

First you create an earning element then update it to allow for multiple entries.

Creating an Earnings Element

  1. In the Payroll Calculation work area, click Manage Elements.
  2. Click Create.
  3. Complete the fields, as shown in this table.

    Field

    Value

    Legislative Data Group

    Your Legislative Data Group

    Primary Classification

    Standard Earnings

    Secondary Classification

    Regular


  4. Click Continue.
  5. On the Basic Details page, complete the fields, as shown in this table.:

    Question

    Answer

    Name

    REGULAR SALARY

    Reporting Name

    Regular Salary.

    Effective Date

    1/1/2010

    Input Currency

    US Dollar

    Should every person eligible for the element automatically receive it?

    No.

    What is the earliest entry date for this element?

    First Standard Earnings Date

    What is the latest entry date for this element?

    Last Standard Earning Date

    At which employment level should this element be attached?

    Assignment Level

    Does the element recur each payroll period, or does it require explicit entry?

    Recurring

    Process the element only once in each payroll period?

    Yes

    Can a person have more than one entry of the element in a payroll period?

    No

    Process and pay element separately or with other earnings elements?

    Process and pay with other earnings


  6. Click Next.
  7. On the Additional Details page, complete the fields, as shown in this table.

    Question

    Answer

    What is the calculation rule?

    Flat Amount

    How do you want to derive the amount?

    Entered value

    What is the time-basis for this element?

    Periodically

    Is this element subject to proration?

    No

    Is this element subject to retroactive changes?

    No

    Use this element to calculate a gross amount from a specified net amount?

    No

    Should this element reduce regular earnings?

    No


  8. Click Next.
  9. Verify the information is correct.
  10. Click Submit.

Reviewing an Earnings Element

On the Element Summary page, review the newly created element details for accuracy.

  1. Review the basic details for the earnings element, for example Element Name, Classification, and Description.
  2. In the Standard Rules section, verify that the element is recurring.
  3. Verify that the employment level is assignment level.
  4. In the Currency section, verify that the currency is US Dollars.

Updating an Earnings Element

On the Element Summary page, update the newly created element details.

  1. Click Edit Element.
  2. Select today's date.
  3. Click Continue.
  4. Scroll to the Standard Rules region.
  5. In the Entry Options section, select the Allow multiple entries in same period option.
  6. Click Save.
  7. In the Element Overview section, select the expand arrow.
  8. Expand the Input Value folder.
  9. Select Pay Value.
  10. Select Edit Element.
  11. Select today's day on the window, and click Continue.
  12. In the Element Overview section, Select Actions, Create Element Eligibility Criteria.
  13. On the Element Eligibility name field, enter REGULAR SALARY ELIG.
  14. In the Eligibility Criteria section, select All payrolls eligible.
  15. Click Save.
  16. Click Submit.

What's the difference between a recurring and nonrecurring elememt?

A recurring element has an entry that applies in every pay period until the entry is ended.

A nonrecurring element has an entry that applies in one pay period only. It is only processed once per pay period. The dates of the pay period are determined by the payroll to which the person is assigned.

Note

A base pay element associated with a salary basis must be recurring.

A net-to-gross element must be nonrecurring.

What's an element's skip rule?

A skip rule is a formula that determines the circumstances in which an element should be processed. If the conditions of the formula are met, then the element is processed. Otherwise the element is skipped from processing.

How can I create an element for retroactive processing?

When an element is subject to retroactive changes, all components for the retroactive element are created automatically. This includes adding the element to the predefined retroactive event group and proration group. You can create your own retroactive event group and proration event group and change the default values for the element in the Manage Element flow.

When does an element get processed with a processing option of process once per period?

An element processes entries only in the first payroll run of each period for this element.

If this option is not available for your localization, you can select a skip rule to process this element once each period.

What happens if the Closed for Entry option is selected on an element?

It prevents all new element entries for the element. Selecting this option will not affect any existing element entries.

Use caution with this feature. When hiring, terminating, or updating assignments, this option will prevent element entry creation for the element, even if the element is used for automatic entries.

What happens if I override an element entry that has a runtime default set at the element's definition?

If you override it, then any subsequent changes to the default value on the element or element eligibility definition will not affect the element entry. However, you can clear your entry if you want to restore the default value.

Manage Deduction Ranges

Deduction Ranges: Explained

Deduction rates and amounts may vary depending on the range in which the earnings balance falls. A deduction range is a table that holds the range of values and associated rates, amounts, or rules to use when calculating a deduction or exemption. For example, a deduction range for a graduated tax might contain two range value rows: one that defines the tax rate for earnings under 50,000 USD and another for earnings above 50,000 USD..

Each localization provides a set of predefined deduction ranges used to calculate statutory and involuntary deductions. You cannot edit predefined deduction ranges. You can add new deduction ranges using the Manage Deduction Ranges task in the Payroll Calculation area. When you create a deduction range, you specify the legislative data group (LDG) to which the range applies. The new range can then be used when processing deductions for the LDG.

Range Groups

Each deduction range belongs to a deduction range group used to categorize related deduction ranges. Examples of deduction range groups include city tax information and social insurance information. A set of standard deduction range groups is delivered with the application and available to all legislations. When you create a deduction range, you can select an existing range group or create a new one.

Associating Deduction Ranges with Calculation Factors

Deduction ranges are building blocks used in the calculation of deductions and exemptions. You associate a deduction range with a calculation factor, which defines the rule for calculating the deduction element for balances in the range table. The deduction range provides the values, but the calculation factor specifies when and how to apply them.

For example, a calculation factor might direct the payroll process to do the following: Calculate the deduction using this deduction range only if the person lives in Region B, and then annualize the calculated result to produce the final deduction amount.

Use the Manage Deduction Group Rules task in the Payroll Calculation work area to view and manage calculation factors.

Deduction Range Values: Examples

The examples that follow illustrate how to use both static and dynamic deduction range values, and how to override the default calculation type for individual range value rows.

Static Range

The deduction range for a regional income tax uses a default calculation type of Flat Rate. However, for the lowest and highest incomes, a flat amount applies. For these two ranges, the Flat Amount calculation type overrides the default type, and uses a monetary value rather than a percentage. No database item is specified in the Basis of Range of Values for the deduction range, so the range values are static.


From Value

To Value

Calculation Type Override

Rate or Amount

0

199

Flat Amount

0

200

999

 

4 (percent)

1000

1999

 

6 (percent)

2000

999,999,999

Flat Amount

300

Dynamic Range

The deduction range for a tax exemption uses a default calculation type of Incremental Rate. The first and last range value rows specify the Flat Amount calculation type, which overrides the default type. The Gross Earnings YTD database item is specified in the Basis of Range Values field, which means that the range values represent a percentage of year-to-date gross earnings. The following sample values define a set of dynamic range values for this deduction range:


From Value

To Value

Calculation Type Override

Rate or Amount

0

.1

Flat Amount

300

.1

.2

 

10 (percent)

.2

.9

 

30 (percent)

.9

1

Flat Amount

0

The first range value row defines a flat amount of 300 USD that applies to the first 10 percent of gross earnings. The second row defines a 10 percent rate that applies to the next 10 percent of gross earnings. The third row defines a 30 percent rate that applies to between 20 and 90 percent of gross earnings. The final row defines a flat amount of zero between 90 and 100 percent.

Deduction Overrides: Explained

A deduction override refers to a value entered on a deduction card that replaces a value defined in a deduction range. For example, an organization might set a default tax rate at the legislative level, and allow the rate to be overridden by a flat amount entered on a personal deduction card at the payroll relationship level.

When the payroll process runs, it checks for deduction card overrides in the following order:

  1. Payroll relationship

  2. Tax reporting unit

  3. Payroll statutory unit

When the process finds an override record, it stops checking and uses the values defined at that level.

Note

Some localizations do not support deduction cards for tax reporting units or payroll statutory units.

Allowing Overrides on Deduction Cards

Overrides for statutory and involuntary deductions are predefined. You cannot allow new overrides for predefined deduction ranges.

If you create a custom deduction range, you can allow users to override a range value on a deduction card by adding the item to the Overrides Allowed on Deduction Card table on the Create or Edit Deduction Ranges page. You must provide the name to appear on the deduction card for the item. The list of items available for override varies depending on the calculation type for the deduction range. For example, you can allow users to override the percentage value for a flat rate calculation or the monetary value for a flat amount calculation. The following three override items are available for all calculation types except text:

If you allow multiple overrides for the same deduction range, the deduction calculation process applies them in the following priority:

  1. Total amount

  2. Deduction range

  3. Range value component, such as rate or flat amount

Creating Overrides on Deduction Cards

Use the Manage Personal Deductions task in the Payroll Calculations or Payroll Administration work area to create deduction card overrides at the payroll relationship level. If overrides are allowed, the Overrides Allowed on Deduction Cards tab appears in the Component Details section of the Manage Deduction Cards page when you select a deduction component. Click Create to define an override. The override value you enter varies based on the type of override item defined in the deduction range, as described in the previous section. For example, you may enter a rate to be used in the deduction calculation or an amount to be added to the calculated amount.

If your localization supports deduction cards at multiple levels, use the Manage Legal Entity Deduction Records task in the Setup and Maintenance work area to create deduction card overrides at the payroll statutory unit level. Use the Manage Legal Reporting Unit Deduction Records task in the Setup and Maintenance work area to create deduction card overrides at the tax reporting unit level.

Calculation Types in Deduction Ranges: Explained

The Calculation Type field on the Create or Edit Deduction Ranges page specifies the default type of calculation to use for all deduction range value rows. You can override the default calculation type for individual rows in the Range Values section by selecting a different calculation type in the Calculation Type Override field. The calculation type determines which values you must provide in the Range Values section. For example, if you select Flat Amount as the calculation type, then you must provide a flat amount value.

Predefined Calculation Types

You can choose from several predefined calculation types, as described in the following table:


Calculation Type

Description

Flat Amount

Uses the specified flat amount as the total deduction amount.

Flat Amount Times Multiplier

Multiplies a flat amount by a multiplier value. If you select this option, you must specify a database item that provides the value of the multiplier.

Conditional Flat Amount

Uses the specified flat amount if the condition defined in the Calculation section is met. For example, a person might qualify for an exemption if their filing status is married or head of household. If you select this option, you must specify a database item that provides the value of the condition.

Flat Rate

Applies the specified rate to the balance. For example, to apply a rate of 10 percent, enter 10.

Incremental Rate

Applies a different rate to portions of the balance. For example, assuming that the balance is 80,000 USD, you could apply a 1 percent rate for the first 20,000 of the balance; a 3 percent rate for the next 30,000, and a 5 percent rate to the next 30,000. This is also referred to as a blended rate.

Standard Formula 1

Calculates the total amount based on the following formula:

y = Ax - Bz

Where:

  • y is the deducted amount.

  • x is the reduced deductible amount.

  • A and B are specified values.

  • z is a factor from a predefined formula. The value defaults to 1.

Standard Formula 2

Calculates the value based on the following formula:

y = (x - A) x B + Cz

Where:

  • y is the deducted amount.

  • x is the reduced deductible amount.

  • A, B, and C are specified values.

  • z is a factor from a predefined formula. The value defaults to 1.

Text

Uses the specified character string as the calculated value.

Specifying View Objects

You can specify the view objects that define the valid values available to the selected calculation type. A view object is a query result set used to display a list of values. The view objects you can specify vary depending on the calculation type. For example, if the calculation type is Conditional Flat Amount, then you can specify view objects for the condition and flat amount values.

Include the fully qualified path name when you specify a view object, such as: oracle.apps.hcm.locUS.payrollSetup.details.publicView.UsStatePVO

Manage Payroll Deductions

Payroll Deductions, Elements, and Deduction Cards: How They Work Together

Payroll deductions comprise multiple components that are defined and managed at different levels. When a payroll run processes a payroll deduction element, it retrieves information stored at all applicable levels.

The following figure shows how deduction information at the legislative and personal levels feeds into the deduction calculation process.

Shows the components described in the
sections that follow

Element Processing

The deduction element's status processing rule drives the calculation, accessing rates and rules defined for the related payroll deduction and values captured on a personal deduction card.

Use the Manage Elements task in the Payroll Calculation work area to view the deduction elements. If an element is associated with a payroll deduction, the deduction name is displayed in the Deductions section on the Manage Element Summary page.

Payroll Deduction

A payroll deduction comprises the rates and rules used to calculate the deduction amount.

Use the Manage Deduction Group Rules task in the Payroll Calculation work area to view all wage basis rules, related elements, and calculation factors defined for a particular deduction group. Use the Manage Deduction Ranges task to view deduction ranges and range values.

Personal Deduction Card

A personal deduction card contains person-specific information used to calculate the deduction amount.

Use the Manage Personal Deductions task in the Payroll Administration or Payroll Calculation work area to create and edit personal deduction cards.

Note

Each legislation supports a predefined set of deduction card types, which typically includes a statutory deduction card and an involuntary deduction card. Additional cards may be supported to capture information for reporting purposes.

Payroll Deduction Components at the Legislative Level: How They Fit Together

Deduction information defined at the legislative data group level comprises several different components, including wage basis rules, one or more payroll elements, and rules for calculating the deduction amount. The following figure shows the relationship between these components.



Deduction Group

Each deduction belongs to a deduction group used to categorize related deductions. Predefined deduction groups include social insurance, taxes, retirement plans, involuntary deductions, benefits, and more. The deduction groups available and their names vary by legislation.

Deduction

A payroll deduction is a set of rates and rules used in the calculation or reporting of one or more payroll deduction elements. A set of statutory deductions is predefined for each legislative data group and cannot be changed. Involuntary deductions are created automatically when you create an element for an involuntary deduction classification. Use the Manage Payroll Deductions task to view deductions.

Wage Basis Rules

Wage basis rules determine the earnings that contribute to a deductible amount or, for exemptions, the elements that reduce the amount subject to deduction. For example, wage basis rules might define which classifications of standard and supplemental earnings are subject to a particular tax. If wage basis rules vary based on a factor such as a person's location of residence, then location of residence is defined as a wage basis rule reference. Use the Manage Deduction Group Rules task to create new wage basis rules.

Related Elements

A deduction is typically associated with one or more elements. The element definition specifies how and when the element should be processed and identifies the input values for the element. A deduction element's processing rule drives the calculation of the element, accessing calculation factors and wage basis rules to derive the deduction amount.

Related elements for statutory deductions are predefined. Related elements for involuntary deductions are created when you create the involuntary deduction element. Element entries for deduction elements are created automatically when the deduction component for the element is added to a personal deduction card.

Calculation Factors

A calculation factor is a data-driven rule for calculating an element. For example, a calculation factor for an income tax element would identify the deduction range that holds the tax rates to use in the calculation. If tax rates vary based on a factor such as a person's filing status, then filing status is defined as a calculation factor reference. Thus, an element may have multiple calculation factors, one for each unique set of rules and references values. If element calculation involves multiple steps, each step is defined in a separate calculation factor. Calculation factors are predefined for statutory and involuntary deductions, and should not need to be changed. Technical users can create new calculations factors using the Manage Payroll Deductions task, and then modify an element's processing rule to use the new calculation factors.

Deduction Range Values

A deduction range stores calculation rates and rules, which may vary based on the amount subject to deduction. For example, deduction range values for a graduated tax might define a 10 percent tax rate for earnings under 50,000 USD and a 20 percent rate for earnings above 50,000 USD. Predefined deduction ranges are provided for statutory and involuntary deductions. Use the Manage Deduction Ranges task to view and manage deduction ranges.

Tax Reporting Units

At the legislative level, a deduction can be associated with one or more tax reporting units for reporting purposes. These associations do not impact the deduction calculation or aggregation during a payroll run. You associate tax reporting units with specific deduction components on a personal deduction card.

Payroll Deduction Components at the Legislative Level: Examples

Use these examples of an individual income tax deduction and a social insurance deduction to understand how deduction components work together. Each example provides sample values for the following deduction components:

Individual Income Tax Deduction

A particular legislation has a statutory deduction for an individual income tax. The exemption amount for the tax varies based on a person's residential status. The earnings classifications included in the wage basis for the tax vary by geographical region. Thus, references are defined for both the wage basis rules and the calculation factors. The calculation is a two-step process: calculate the exemption and then calculate the tax amount based on the reduced deductible amount.

Social Insurance Deduction

The same legislation has a statutory deduction for a social insurance tax. Both the employer and the employee contribute to the social insurance tax, but their contribution rates are different. Calculation of the deduction has several steps:

  1. Calculate the base amount for the employee's contribution.

  2. Calculate the base amount for the employer's contribution.

  3. Calculate the employee's contribution amount.

  4. Calculate the employer's contribution amount.

The following component values define this deduction at the legislative level:

Wage Basis Rules: Explained

Wage basis rules determine the earnings that contribute to a deductible amount or, for exemptions, the elements that reduce the amount subject to deduction.

Element Classifications

Each wage basis rule is associated with a primary or secondary element classification. For deduction elements, the classifications identify which types of earnings are subject to the deduction. For exemption elements, the classifications identify which type of earnings reduce the amount subject to deduction.

References for Wage Basis Rules

A wage basis rule may be associated with up to six references that define the context for the rule. Each reference has a sequence number that determines the order in which it is evaluated for processing relative to other references. For example, if a wage basis rule for a regional tax deduction has references for both county and city, then the county reference should have a higher sequence number than the city so that it will be evaluated first.

The wage basis rules and related references for statutory and involuntary deductions are predefined for each legislation. You cannot edit predefined rules or references.

Creating Wage Basis Rules

You can create new wage basis rules for existing deductions using the Manage Deduction Group Rules task in the Payroll Calculation work area. The process is summarized below:

  1. On the Manage Deduction Group Rules page, select the deduction group to which the new rule applies.

  2. In the Deduction Group Overview section, click the deduction group name and then click Wage Basis Rules. If wage basis rule references have been defined, click the reference.

  3. In the Wage Basis Rules section, click Create.

  4. Select the deduction to which the rule applies.

  5. Select the primary and secondary classifications to be used in the wage basis for the deduction.

  6. Provide the reference value for the rule, if applicable.

Wage Basis Rules: Example

The following example illustrates how to define a set of wage basis rules for a tax deduction when the earnings included in the wage basis vary depending upon where a person lives.

Taxable Earnings by Region

Brittany is a waitress who receives a salary of 5,000 USD each month plus tips. Brittany is subject to an income tax that is calculated at the rate of 10 percent of the deductible amount, which may vary based on where an employee lives. In Dover County, tips are included in the deductible amount, but in Smith County, tips are not included. This table shows the tax calculations that apply for each region.


Region

Earnings in Salary

Earnings in Tips

Deductible Amount

Deduction Amount

Dover County

5000

50

5050

505

Smith County

5000

(50 - Exempt)

5000

500

The wage basis rules for this tax deduction are as follows:


Region (Reference Value)

Primary Classification

Secondary Classification

Use in Wage Basis?

Dover County

Earnings

Salary

Y

Dover County

Earnings

Tips

Y

Smith County

Earnings

Salary

Y

Smith County

Earnings

Tips

N

Calculation Factors: Explained

A calculation factor defines a data-driven rule for calculating a deduction or exemption element. For example, a calculation factor for a tax deduction element might define a context reference (such as a city or state), the deduction range value (such as a 4 percent tax rate on balances under 50,000), and optionally a calculation method and calculation step. Some elements may have a large number of calculation factors, one for each unique set of rules, ranges, and references values. The element calculation process determines which calculation factor to use based on the reference values and calculation rules of the element being processed. Calculation factors are predefined for statutory and involuntary deductions, and should not need to be changed.

Aspects of a calculation factor are shown in the following figure:

Aspects of calculation factor include
reference values, a deduction range, a calculation step, and a calculation
method

Reference Values

A calculation factor may be associated with up to six references that define its context. For example, calculation of a social insurance deduction might vary based on a person's age and employment status. Each reference has a sequence number that determines the order in which it is evaluated for processing relative to other references.

To view the references associated with a calculation factor, click the deduction in the Deduction Overview pane on the Manage Payroll Deductions page.

Note

The calculation factors and related references for statutory deductions are predefined for each legislative data group. You cannot add or edit references for predefined deductions.

Deduction Range

Each calculation factor is associated with a deduction range that defines the calculation type, such as flat amount or flat rate, and a set of calculation rates and rules, which may vary based on the amount subject to deduction. For example, a deduction range for a graduated tax might define a 10 percent tax rate for earnings under 50,000 USD and a 20 percent rate for earnings above 50,000 USD. Predefined deduction ranges are provided for statutory and involuntary deductions. Use the Manage Deduction Ranges task to view and manage deduction ranges.

Calculation Step

A calculation step is a label you assign to a calculation factor to identify its role in a complex calculation. For example, when calculating an income tax deduction, the process might first calculate the allowance, then any exemption amount, and then apply the tax rate to the reduced deductible amount. For such deductions, you can define multiple elements to be processed separately or define a single element with multiple calculation steps, each defined in a separate calculation factor. You can assign the same calculation step to more than one calculation factor. Calculation steps are optional.

Calculation Method

A calculation method references a single fast formula. It is an optional component of a calculation factor. Calculation methods operate at a higher level than the calculation types defined in the deduction range. They provide a wrapper around the calculation of a deduction by retrieving values from a deduction range, applying a fast formula, and returning the final deduction amount for the current run. For example, if the calculation method is set to Cumulative, which references the Core Cumulative fast formula, then the calculation process returns the total deduction amount as a cumulative year-to-date amount.

Calculation Factors for Payroll Deductions: Examples

The following examples illustrate how calculation factors are used to calculate different types of deductions.

Social Insurance Deduction

Employers in many countries deduct social insurance payments from employees and also make contributions. Employee and employer rates are typically different. Such deductions often have wage limits.

To process this type of deduction, you might create a social insurance deduction processor element with the following calculation factors:


Employer or Employee Code (Reference Value)

Calculation Method

Calculation Step

Deduction Range

Range Values

Employee

None

Calculate Social Insurance Employee Rate

Social Insurance Employee Rate

4 percent flat rate

Employer

None

Calculate Social Insurance Employer Rate

Social Insurance Employer Rate

2 percent flat rate

Employee

None

Calculate Social Insurance Employee Wage Limit

Social Insurance Employee Wage Limit

100,000 flat amount

Employer

None

Calculate Social Insurance Employer Wage Limit

Social Insurance Employer Wage Limit

100,000 flat amount

National Income Tax Deduction Using Calculation Steps

A national income tax deduction involves the multiple steps. First, it calculates the allowance, then any exemption amount, and then it applies the tax rate. The following table shows a subset of calculation factors that might be associated with a tax processor element.


Filing Status (Reference Value)

Calculation Method

Calculation Steps

Deduction Range

Single

None

Calculate Region A Allowance - Single

Region A Allowance - Single

10,000 flat amount

Single

None

Calculate Region A Exemption Amount - Single

Region A Exemption - Single

0 flat amount

Single

None

Calculate Region A Regular Rate - Single

Region A Rate - Single

7 percent flat rate

Married

None

Calculate Region A Allowance - Married

Region A Allowance - Married

10,000 flat amount

Married

None

Calculate Region A Exemption Amount - Married

Region A Exemption - Married

1,000 flat amount

Married

None

Calculate Region A Regular Rate - Married

Region A Rate - Married

6 percent flat rate

Creating Involuntary Deductions: Overview

Oracle Fusion Global Payroll supports a set of involuntary deduction types, such as bankruptcy orders, garnishments, child support payments, tax levies, and educational loans. Global Payroll provides element templates for each involuntary deduction type supported by your localization. You can create involuntary deduction elements as needed using these predefined templates. You can then add the corresponding involuntary deduction component to a personal deduction card so the deduction will be processed during a payroll run.

This figure shows the steps involved in creating an involuntary deduction.

Diagram shows each step described in
remainder of this topic

Create Third-Party Payment Methods

Use the Manage Third-Party Payment Methods task in the Payment Distribution work area to create payment methods for all external payees. For example, you might set up direct deposit for the payee of a child support deduction. A payee can be either a person or an organization.

For both types of third-party payment methods, you must select a previously defined organization payment method to use. (Use the Manage Organization Payment Methods task in the Payment Distribution work area to define the payment source for third-party payments, if not already defined.)

Create an Involuntary Deduction Element

An involuntary deduction element must be defined for each involuntary deduction type you need to process. Involuntary deduction elements can be created during initial setup and as the need arises later. You can create multiple elements for the same involuntary deduction type if processing information or other details vary. For example, court orders from different jurisdictions might have different processing rules. The involuntary deduction element creation process is summarized here. You can skip this task if an element has already been defined for the type of involuntary deduction you want to add to a person's deduction card and the element's processing rules meet your needs.

  1. Using the Manage Elements task in the Payroll Calculation work area, create a new element with a primary classification of Involuntary Deduction and a secondary classification that reflects the deduction type, such as tax levy or child support. (Secondary element classification names vary by localization.)

  2. Answer the questions on each page of the Create Element flow. For example, you must indicate whether or not to create arrears if the full deduction amount cannot be taken. A predefined set of rules, plus the answers you provide, determine which earnings contribute to the deductible amount and how the deduction will be processed.

  3. Define eligibility for the element. To define open eligibility, enter a name for the element eligibility record but do not specify any criteria.

  4. Define costing for the element as appropriate.

    Note

    To define costing for related elements, you must open and edit each element individually.

When you save the element, the application automatically creates all associated balances, feeds, input values, formulas, and related elements required for payroll processing. It also creates a deduction component that you can add to an employee's involuntary deduction card. Fee rules and proration rules are predefined in deduction ranges, based on statutory rules that vary by localization. Rules for core payroll are as follows:

Create an Involuntary Deduction Card

Using the Manage Personal Deductions task in the Payroll Administration or Payroll Calculation work area, search for and select a payroll relationship. Create a new deduction card of the type Involuntary Deductions.

Add the Involuntary Deduction Component to the Deduction Card

On the Manage Deduction Cards page:

  1. Create a deduction component with the same name as the previously defined involuntary deduction element.

    Adding the involuntary deduction component to the card automatically creates an element entry for the related deduction element.

  2. If the deduction card will include more than one involuntary deduction component, you can specify the order in which the deductions should be processed in the Subprocessing Order field. For example, if you set the Subprocessing Order to 103 for a child support deduction and set it to 104 for a court order, the payroll run processes the child support deduction before the court order. By default, involuntary deduction elements are processed in order by date received; the oldest is processed first.

  3. Enter a reference code to uniquely identify this deduction, such as a court order number, case number, or other identifier provided by the issuing authority.

  4. Complete the fields on the Deduction Component Details tab.

You can add multiple involuntary deduction components for the same or different types. For example, you could add two child support and one garnishment components to the same deduction card. Assign each component a unique reference number and, optionally, specify the subprocessing order.

Create Overrides for the Deduction Amounts

You define the order amount by creating an override on the deduction card. You can also create overrides for fees and other amounts used in the calculation. These overrides replace default values defined in deduction ranges at the legislative level. The default order amount for an involuntary deduction is typically zero.

The process of creating overrides is summarized here:

  1. On the Overrides Allowed on Deduction Card tab, create an override for Order Amount (Rate) or Order Amount (Amount).

    For example, if you specified a frequency of monthly in the component details, enter the amount to deduct each month, regardless of the payroll period; the application automatically calculates the correct amount to deduct in each payroll run. If you did not specify a frequency, this amount will be deducted at the payroll frequency defined for the payroll relationship.

  2. Create additional overrides, as needed, for fees, protected pay amount, minimum and maximum withholding amounts, and other values applicable to this deduction.

    Make sure that you have selected a payee on the component details for each fee override you create.

Process the Payroll with Deductions

During a payroll run, the status processing rule for the deduction element calculates the correct deduction amount based on rules predefined for the deduction type plus information defined on the deduction card.

Creating Overrides for Involuntary Deductions: Critical Choices

You define the order amount for an involuntary deduction by creating an override on the person's involuntary deduction card. You can also create overrides for fees and other amounts used in the calculation. These overrides replace default values defined in deduction ranges at the legislative level.

Overrides Allowed on Deduction Card

The overrides allowed on a deduction card may vary by legislation, but typically include the items described in this table.

Note

For most overrides, you can create either an amount or a rate override. Create a rate override if you want the application to calculate the deduction amount as a percentage of available pay. For example, to define a rate of 20 percent for the order amount, add an Order Amount (Rate) override and enter 20 in the Rate field.


Override Name

Description

Order Amount

Rate or amount paid to the Order Amount Payee based on the frequency you specified.

For example, if you specified a frequency of monthly in the component details, enter the amount to deduct each month, regardless of the payroll period; the application automatically calculates the correct amount to deduct in each payroll period. If you left the Frequency field blank, this amount will be deducted at the payroll frequency defined at the terms or assignment level.

Organization Fee

Rate or amount paid to the Organization Fee Payee each time the deduction is processed.

Person Fee

Rate or amount paid to the Person Fee Payee each time the deduction is processed.

Processing Fee

Rate or amount paid to the Processing Fee Payee each time the deduction is processed.

Initial Fee

Rate or amount paid to Processing Fee Payee the first time this deduction is processed.

Maximum Withholding Amount and Minimum Withholding Amount

Maximum and minimum rates or amounts that can be withheld in one payroll processing period for this deduction.

Maximum Withholding Duration

The number of days after the Date Received that the order is valid. For example, a court order might only be valid for 90 days after the date issued.

Protected Pay Amount

Amount of the employee's pay that is exempt from this deduction. Only pay exceeding this amount will be included in the deductible amount (available for the deduction).

Exemption Percentage

Percentage of the employee's pay that is exempt from this deduction.

Involuntary Deduction Processing: Examples

Use these examples to understand how involuntary deductions are processed in different scenarios for core payroll. Processing rules may vary by legislation or legal authority issuing the order for the deduction.

Involuntary Deduction Has Initial Fee and Processing Fee

Scenario: A US employee is issued a court order for a monthly garnishment for 500 USD. The order is subject to a 10 USD one-time initial fee and a 10 USD monthly processing fee, which are both paid to the agency responsible for administering the account and forwarding payment to the recipient.

Involuntary Deduction Card Setup: Add a deduction component for a garnishment and then:

  1. Select the Order Amount Payee and the Processing Fee Payee. (The processing fee payee is also the initial fee payee.)

  2. Set the Frequency to monthly.

  3. Create an Order Amount override, and set the amount to 500.

  4. Create a Processing Fee Amount override, and set the amount to 10.

  5. Create an Initial Fee Amount override, and set the amount to 10.

Payroll Run Results:

Deduction Amount Exceeds Protected Pay Amount

Scenario: A UK employee is issued a court order in the amount of 100 GBP per month. However, protected pay rules defined for the deduction require that the employee take home at least 700 GBP, after all deductions.

Involuntary Deduction Card Setup: Add a deduction component for a court order and then:

  1. Select the Order Amount Payee.

  2. Set the Frequency to monthly.

  3. Create an Order Amount override, and set the amount to 100,

  4. Create a Protected Pay Amount override, and set the amount to 700.

Payroll Run Results:

Employee Has Multiple Assignments and Payrolls

Scenario: An employee has 2 assignments, both for the same payroll relationship, and is assigned to 2 different payrolls. One of the assignments is on a weekly payroll, and the other assignment is on a monthly payroll. The employer receives a court order to deduct 200 USD per month from the employee's wages. The court order amount must be deducted from all available money, regardless of the payroll. If the total order amount cannot be deducted from the first payroll run, then the remaining balance must be deducted from one or more subsequent runs during the month, until the full amount is paid.

Involuntary Deduction Card Setup: Add a deduction component for a court order and then:

  1. Select the Order Amount Payee.

  2. Set the Frequency to monthly.

  3. Create an Order Amount override for 200 USD.

Payroll Run Results:

Note

If a person has two assignments for different payroll relationships, they would typically be issued two different court orders, one for each employment. In this case, you would add each court order to a different deduction card.

Multiple Orders Exist with Different Protected Pay Amounts

Scenario: A UK employee has 3 court orders, and each has a different protected pay amount.

Deduction Card Setup: Add 3 deduction components to the employee's deduction card. Set the frequency of each one to monthly. Define protected pay and order amount overrides for each as shown in this table.


Involuntary Deduction

Protected Pay Amount

Order Amount

Date Received

Child Support 1

500

1000

23 January 2012

Child Support 2

600

1100

2 February 2012

Child Support 3

1000

1200

2 February 2012

Payroll Run Results:

The net amount available for involuntary deductions in the payroll run is 2000 GBP. Based on the processing priority defined for child support payments, the payroll run processes the involuntary deductions in order by date received.

How do I view and manage calculation factors?

Select the Manage Payroll Deductions task and open the deduction. In the Deduction Overview section, expand the Related Elements node and then expand the Calculation Factors node to display a list of all calculation factors associated with the element. You can create new calculation factors and edit existing ones that have an update status of Unlocked. You cannot edit predefined calculation factors. Note that if you create a new calculation factor, you must edit the element's processing rule (a fast formula) to use the new factor.

Why can't I create payroll deductions?

Oracle Payroll provides a set of predefined statutory deductions. You can view predefined deductions from the Manage Payroll Deductions page, but you cannot create new deductions. You can create new involuntary deduction elements using the Manage Elements task. The predefined involuntary deduction element templates automatically create a payroll deduction object and associated deduction component when you save the involuntary deduction element. You can add deduction components to a personal deduction card using the Manage Personal Deductions task. Adding a deduction component to a deduction card creates an element entry for the related deduction element.

Add Eligibility Rules for Predefined Elements

Element Eligibility: Explained

Element eligibility determines which people are eligible for an element. To determine eligibility, you assign element eligibility criteria to the components that persons must have to receive entries of the element. While some elements may represent compensation, deductions, and equipment available to all persons, many elements are available only to certain groups of persons. For example, your enterprise might provide company cars only to persons in the Sales Department. Eligibility criteria rule out the possibility of persons getting element entries by mistake. For example, you might want to give a production bonus only to those persons who work full time in Production and are on the weekly payroll. To do this you would define eligibility criteria for the element Production Bonus and the combination of the Production organization, the Full-Time assignment category, and the Weekly payroll.

Eligibility Criteria

Element eligibility can be assigned by many different criteria.

Note

In order to enter an element for a worker, you must define element eligibility for every element. This must be done for predefined elements and those you define. If you want the element to be available to all workers, you can save the element eligibility record with no criteria selected. This is the usual practice for compensation and benefit elements where you determine eligibility using eligibility profiles.

Multiple Rules of Eligibility

You can define more than one eligibility criteria for each element but there must be no overlap between them. For example, you could create one criteria for the combination of grade A and the job Accountant. However, you could not create one criteria for grade A and a second for the job Accountant. This would imply that an accountant on grade A is eligible for the same element twice. If you have more than one criteria for an element, you can enter different default values, qualifying conditions, and costing information for each eligibility group.

Maintaining Element Eligibility: Explained

Element eligibility rules always control element entries.

After you have used an element you can make the following changes to the eligibility rules:

Define Events

Payroll Event Groups: Explained

A payroll event group is a group of types of data changes that trigger retroactive event notifications or prorated calculation of a person's earnings.

There are two types of payroll event groups:

Proration

Using proration, you can calculate proportionate earning and deduction amounts whenever payroll-relevant data is changed during a payroll period, for example, if a person joins or leaves an organization or if a person's pay grade changes during a payroll period.

If you want to prorate an earnings element, such as basic salary, assign a proration event group to it containing the proration points that affect a person's salary. When you define the event group, you select the events that activates proration calculation, such as changes to:

Retroactive

Retroactive processing ensures that your payroll run for the current period reflects any backdated payments and deductions from previous payroll periods. A retroactive event group defines the types of changes that trigger a retroactive event notification.

Within a retroactive event group, select the events that produce notifications if a backdated change occurs. Specify the entity, update type, and attribute, such as the examples provided in the following table.


Entity

Update Type

Attribute

Element Entry Value

Correction

SCREEN_ENTRY_VALUE

Element Entry

Update

EFFECTIVE_START_DATE

Element Entry

Update

EFFECTIVE_END_DATE

Element Entry

Logical Date Change

 

Element Entry

Insert

 

Element Entry

Delete Changes

 

Define Payment Methods

Bank, Branch, and Account Components: How They Work Together

Banks, branches, and accounts fit together on the premise of the Bank Account model. The Bank Account model enables you to define and keep track of all bank accounts in one place and explicitly grant account access to multiple business units, functions, and users. This eliminates the redundant duplicate bank account setup under different business units when these business units share the same bank account.

Banks

Creating a bank is the first step in the bank account creation. The user can search for existing banks, view and update them, or create new banks. You can create a new bank from an existing party. The option to create from an existing party is implicitly implemented by the matching option. The option is available only after the existing party has been found with the same bank. If you choose the matching option, the page repopulates the information from the matched party.

Branches

Once you have created your bank, the next step is create a branch or branches associated to the bank. The matching option is also available when creating branches. To create a new branch without using the matching option, manually enter in the information required. You can define other branch-related attributes in the page. If you do not use the matching option when an existing party is found, a branch with the same party name is created.

Accounts

Once the bank and branch are created, you can proceed to the bank account setup. Select the bank branch you want to associate to your bank account. Assign the owner of the bank account. There are four areas associated to defining the account: general information, control of the account, security access to the account, and business unit assignment. If this is a Payable or Receivable account, the accounts are identified by business unit, and if a Payroll account, by legal entity.

Creating Accounts: Points to Consider

Banks, branches and accounts fit together on the premise of the Bank Account model. The Bank Account model allows you to define and keep track of all bank accounts in one place and explicitly grant account access to multiple business units, functions, and users. Consider the following when you set up bank accounts:

Account Use

Account use refers to accounts created for Oracle Fusion Payables, Oracle Fusion Receivables and Oracle Fusion Payroll. When creating an account to be used in one or more of these applications you must select the appropriate use or uses.

Account Access

Payables and Receivables account access is secured by business unit. In addition to selecting the appropriate application use or uses, one or more business units must be granted access before the bank account can be used by Payables and Receivables. Only business units who use the same ledger as the bank accounts owning legal entity can be assigned access

User and Role Security

You have the option to further secure the bank account so that it can only be used by certain users and roles. The default value for secure bank account by users and roles is No. In Payables and Receivables even if the secure bank account by users and roles is no, you must have the proper Multi-Organization Access Control (also known as MOAC) to access a bank account. If the secure bank account by users and roles is set to Yes, you must be named or you must carry a role that is named expressly on the bank account in order to use it.

Note

The security role Bank and Branch Management Duty is used to set up banks and branches.

The security role Bank Account Management Duty is used to set up accounts.

Entering Bank Information for Personal Payment Methods: Critical Choices

Bank, branch, and bank account information is shared across multiple applications. For example, if you add an employee's bank details for expense payment, the same bank details are available for managing electronic funds transfer (EFT) payment details for that employee. Who enters bank information depends on how security is configured at your site.

The configuration choices are:

Entering Bank Information Centrally

By default, only cash managers can enter banks and branches. They use the Set Up Bank, Branches, and Accounts task list in the Setup and Maintenance work area.

A web service is also available to migrate personal payment method information, including employee bank account details, from external sources.

Entering Bank Information on the Manage Personal Payment Methods Page

By default, on the Manage Personal Payment Methods page, employees can enter their own bank account details for existing banks and branches, but they cannot create new banks and branches. Similarly payroll managers, payroll administrators, and payroll coordinators can enter account details for the employees they handle, but they cannot create new banks and branches. If you want to enable the create option for any of these roles, you must add the Bank and Branch Management duty role to the relevant role.

It is not possible to edit bank and branch details on the Manage Personal Payment Methods page. You must use the Set Up Bank, Branches, and Accounts task list to edit existing banks and branches.

Important

If you enable employees or other roles to create banks and branches, provide guidance to use unique names and follow appropriate naming conventions.

Organization Payment Methods: Explained

Organization payment methods identify the payment type and the currency to use for payroll payments to workers and for disbursing employee deductions to third parties.

You must define at least one organization payment method for each type of payment and currency that you use to disburse wages and other compensation to your employees. You can also define rules for validating or processing the distribution of payments when you offer more than one option.

A typical configuration is to have one organization payment method for each combination of legislative data group, payment type, and currency.

Payment Types

Any payment method that you define must belong to one of the payment types that your enterprise supports.

Each payroll must have at least one valid organization payment method for each payment type available to employees on that payroll. There may be more than one payment method with the same payment type.

The most common payment types are:

Your enterprise may support a different range of types that are appropriate for your localization. For example, some localizations do not allow cash, some do not support checks, and very few support postal money orders.

The names of payment types can vary by localization. For example, in the US, the payment type for EFT is NACHA; in the UK it is BACS, and in Australia it is BECS.

Note

When you select the EFT payment type, you can enter EFT information at the organization payment method level, the payment source level, or both. Entries at payment source level take priority over entries at organization payment level.

Payment Sources

Payment sources associate bank accounts and other sources of funds with organization payment methods. If you are using Oracle Fusion Global Payroll for payroll processing, each organization payment method that is in use must have at least one valid payment source.

For check and EFT payment methods processed by Global Payroll, the payment source must be associated with an active bank account defined in Oracle Fusion Cash Management. If an organization payment method is associated with multiple payment sources, then the payment method rules determine which payment source is to be used for each disbursement.

You can use the same bank account as a payment source in more than one organization payment method. For example, one checking account may be used to pay both check and EFT payments. The application will not prevent specifying the same name for different payment sources, but it is best practice to use different naming for each occurrence.

When you have one organization payment method for each combination of legislative data group and payment type, you can use payment rules to determine the appropriate payment source based on tax reporting unit. However, there are several reasons why a company might need multiple organization payment methods and multiple payment sources, such as these examples:

Note

You can use the same organization payment method for both employee payments and third-party payments, but you must define different payment sources for each of them and name them differently.

Payment Rules

The first payment source defined is the default payment source. If you add more payment sources, you can add subsidiary information as payment rules. For example, if you have multiple tax reporting units, you can specify which payment source to use for each tax reporting unit.

Having a default payment source ensures that employees are paid if there is a change in tax reporting unit. For example, Company A has multiple independent franchises, each with its own tax reporting unit. If a franchise sells, it will have a new tax reporting unit number, and the payment rule will fail. Instead of issuing errors, payment is made using the default payment source.

You might rather not specify a default payment source when payments cannot be made from the specified payment source in the payment rule. For example, Company B has 30 bank accounts and is very careful not to comingle funds. They leave the default unspecified to instead receive notifications that they can resolve manually.

Default Payment Methods

You can define as many payment methods as required for your enterprise. When you create a payroll, you can select which of these methods are valid for employees assigned to that payroll. You select one method as the default method for the payroll. The default payment method is used to determine how to disburse a payment when an employee does not have any personal payment methods specified.

Note

The application does not support EFT payment methods as default payment methods because each payee must have a personal payment method with account information to know where the money will be deposited.

Relationship to Other Objects

You select organization payment methods when defining other objects, such as payroll definitions and other payment methods. Organization payment methods are only available for selection if they are effective as of the date the object is being defined or updated.

For example, if you create a payroll definition effective as of 4/1/2012 and want to associate a particular organization payment method as the default, the organization payment method must have an effective start date on or before 4/1/2012. Similarly, when updating or correcting objects to change the organization payment method, the organization must have an effective start date on or before the effective date of the change.

The functional relationship of organization payment methods with other objects is described in this table.


Object

Functional Relationship

Personal Payment Method

Associates a person to a particular organization method. If the payment type is EFT, the person's bank information is included in the personal payment method.

Employees manage personal payment methods from their portrait. Payroll managers, coordinators, and administrators use the Manage Personal Payment Methods task on the Payment Distribution work area.

Third-Party Payment Method

Enables separate payment information for payments to third parties who are not on the payroll.

Payments to third parties, such as garnishments or other involuntary deductions, are typically check payments processed separately from the payroll.

To manage third-party payment methods, payroll managers and administrators use the Manage Third-Party Payment Methods task on the Payment Distribution work area.

Payroll Definition

Establishes the default payment method for payments to employees who have no personal payment method defined.

To manage payroll definitions, payroll managers and administrators use the Manage Payroll Definitions task on the Payroll Calculation work area.

Run-Type Payment Method

Overrides a payroll's default payment method for payments to employees with no personal payment method defined.

For example, your regular payroll is by EFT but you issue check bonuses once a year. Using the Separate Payment run type, the payment method will overwrite the one of the payroll. However, if a personal payment method of type EFT has been defined for any employee on the payroll, the application will use the personal payment method instead.

To manage run type payment methods, payroll managers and administrators use the Manage Run Types task on the Payroll Calculation work area.

Setting Up Payment Sources in Organization Payment Methods: Worked Example

This example demonstrates how to set up payment sources when defining organization payment methods to be used in Oracle Fusion Global Payroll for payroll processing.

The following table summarizes the key decisions for this scenario.


Decisions to Consider

In This Example

How many organization payment methods are needed?

Two methods to pay employees by check and electronic funds transfer (EFT), and one method to pay external third-party consultants by check.

How many payment sources are needed?

One payment source for each of organization payment method to pay employees, and two payment sources for the organization payment method to pay external third-party consultants.

How many bank accounts will be used?

One for each payment source.

What payment method rules will be used?

Rules for in-state bank accounts used to pay third-party consultants.

Is notification required to alert the source financial institution before processing EFT payments?

Yes. Ten days before EFT payments to executive employees

In this example, the InFusion US company pays its employees by check and EFT payments. Two bank accounts have been set up for funds used to pay the executive staff and the regular employees separately. The company occasionally distributes payments to external third-party consultants, but must comply with state regulations and pays them from two different banks based on their tax reporting unit.

Note

The available payment types for organization payment methods may be limited by the legislation.

Prerequisites

This worked example assumes that the following prerequisites of organization payment methods have already been set up:

  1. The primary ledger is set up in Oracle Fusion General Ledger and is available for use.
  2. The banks, branches, and account information to use as the payment sources are set up in Oracle Fusion Cash Management and are available for use.
  3. The legal entity associated with the legislative data group has been assigned to a general ledger.
  4. Tax reporting units have been set up and are available for use.

Setting Up Organization Payment Methods

Perform the following steps three times, once for each of the three organization payment methods.

  1. In the Payment Distribution work area, click Manage Organization Payment Methods.
  2. In the Search Results section, click Create.
  3. Select the legislative data group, for example, InFusion US LDG.
  4. Select the date when you want this payment to start being available for use, and then click Continue.
  5. In the Basic Details section, complete the fields as shown in this table, and then click Save.

    Field

    Non-Executive Value

    Executive Value

    Consultant Value

    Name

    Employee Payroll Check

    Executive Payroll Direct Deposit

    In-State Consultant Check

    Payment Type

    Check

    NACHA

    Check

    Currency

    US Dollar

    US Dollar

    US Dollar


  6. For the non-executive and executive employee organization payment methods, in the Payment Sources section under Employee Payment Sources, click Create.

    On the Create Payment Source page, complete the fields as shown in this table, and then click Continue.

    Field

    Non-Executive Value

    Executive Value

    Name

    Employee Check Source

    Executive Direct Deposit Source

    Bank Account Name

    InFusion US Your Bank

    InFusion US Bank of America


    Note

    Keep your payment source names as specific as possible for each scenario. This will help when managing more complicated combinations of organization payment methods and payment rules.

  7. For the third-party organization payment method for non-employee payments, in the Payment Sources section under Third-Party Payment Sources, click Create.

    Perform this step twice, once for each payment source.

    On the Create Payment Source page, complete the fields as shown in this table, and then click Continue.

    Field

    First Source Value

    Second Source Value

    Name

    Texas Check Source

    California Check Source

    Bank Account Name

    Comerica Bank

    Bank of the West


    Note

    If a single organization payment method has payment sources defined for both employees and third parties, the names of the payment sources must not be the same.

  8. Click Submit.

Creating Payment Rules

In this example, the organization payment method you set up for the external third-party payments with two different payment sources requires payment rules to determine how payments are distributed.

Perform these steps for the In-State Consultant Check organization payment method created in the previous task.

  1. In the Search section of the Manage Organization Payment Methods page, select your legislative data group, and then click Search.
  2. In the Search Results section, click the Edit icon in the Update Status column for the row showing the In-State Consultant organization payment method.
  3. Click Yes if a message displays confirming you want to correct the record.
  4. In the Payment Method Rules section under Third-Party Payment Sources, click Create and select the values shown in this table to create two payment rules that map a payment source to a tax reporting unit.

    Field

    Texas Check Source

    California Check Source

    Default

    No

    No

    Tax Reporting Unit

    Texas TRU

    California TRU

    Payment Source

    Texas Check Source

    California Check Source


  5. Click Submit.

Adding EFT File Information

In this example, the bank information for the EFT payments to executive employees must be added.

When you select the EFT payment type, you can enter EFT information at the organization payment method level, the payment source level, or both. Entries at payment source level take priority over entries at organization payment level. In this example, the EFT information is set at the organization payment method level because the US company requires notification of any electronic transfers of funds 10 days prior to the planned transfer date.

  1. In the Search section of the Manage Organization Payment Methods page, select your legislative data group, and then click Search.
  2. In the Search Results section, click the Edit icon in the Update Status column for the row showing the Executive Direct Deposit organization payment method.
  3. Click Yes if a message displays confirming you want to correct the record.
  4. In the Electronic Funds Transfer File Information section, enter values as shown in this table.

    Field

    Value

    Prenotification Required

    Yes

    Prenote Days

    10


  5. In the Payment Rules area, ensure that the Executive Direct Deposit Source is selected as the default payment source.
  6. Click Submit.

Third-Party Payment Methods: Explained

Use the Manage Third-Party Payment Methods task to create payment methods for all external payees who are not on the payroll. A third party can be either a person or an organization. Payments to third parties are normally involuntary deductions, such as court-ordered garnishments.

For all third-party payment methods, the organization method that determines the payment source to use must already be defined. Use the Manage Organization Payment Methods task in the Payment Distribution work area to define the payment source for third-party payments.

Payments to Persons

When you create a third-party payment method for a person, you select the payroll relationship for the employee whose pay is subject to the deduction. This makes the third-party person payment method available for selection as a payee on the employee's involuntary deduction card.

For example, you might set up an electronic funds transfer (EFT) payment to Mary Smith for a child-support deduction for employee John Smith. When you create the third-party payment method, you select the payroll relationship for John Smith. When you add the child support order to John Smith's involuntary deduction card, you can select Mary Smith in the Order Amount Payee field.

Payments to Organizations

When you create a third-party payment method for an organization, you select External Payee in the Party Usage Code field to make the organization available for selection as a payee on the employee's deduction card.

For example, you might set up an EFT payment method for a County Sheriff that receives a processing fee on garnishment payments. When you create the payment method, you designate the County Sheriff as an External Payee. When you add the garnishment order to the employee's involuntary deduction card, you can select the County Sheriff in the Processing Fee Payee field.

Define Payroll Costing

Payroll Cost Allocation Key Flexfield: Critical Choices

The cost allocation key flexfield creates a structure that captures the account codes you use to create accounting entries, and to report and track your labor costs. When planning how to create a key flexfield structure, consider the following choices:

Structure of the Cost Allocation Key Flexfield

Use the predefined cost allocation key flexfield code to create a cost allocation key flexfield structure. The structure specifies the segments to include, their order, and the value sets to validate the data entered in the segments. The segments correspond to each part of the account number, such as the company identifier, cost center code, and the activity or expenditure type.

As a best practice, you create the cost allocation key flexfield structure based on the key flexfield structure used by the accounting flexfield for that chart of accounts that receives the costing entries from payroll. By using a similar sequence of segments and naming conventions, you can facilitate setup, avoid discrepancies, and minimize effort. For example, when you define the accounting rules in Oracle Fusion Subledger Accounting, you can more easily map the segment names of the cost flexfield to the heading names in the accounting flexfield.

When you create your cost allocation key flexfield, also consider whether you want to add segments for:

Segment Value Sets

You associate each segment in your structure to a value set, which validates the data entered for that segment.

When planning which value sets to create for your segments, consider which segments require a:

The following figure shows how the cost allocation key flexfield segments are associated to value sets. The flexfield structure includes an additional segment to break down costs for projects, which does not have a corresponding segment in the chart of account.

Cost allocation key flexfield structure
and value sets

Cost Hierarchy Levels

When you create the cost allocation key flexfield structure, you determine at which levels of the cost hierarchy each cost account segment is available for entry. This structure controls which cost account segments the application displays on the costing setup pages.

Each column heading of the cost key flexfield structure corresponds to a segment of your account structure. Each segment label of the flexfield structure corresponds to a cost hierarchy level, which qualifies where you can enter account information. For example, you might select the column heading for the segment that records the natural account and select element as the segment label. The Manage Costing of Elements page would then include the natural account segment for the cost account, and you could enter that account for the appropriate element eligibility records.

The following figure illustrates how the flexfield structure determines which segments you can specify for the cost account on the costing setup pages.

The flexfield structure determines
which segments are available for entry on the costing setup page

Note

You can specify different levels of the cost hierarchy for the cost segments, but the offset segments that balance the costs are available for entry only at the element level of the cost hierarchy.

You do not have to enter a costing segment at each level of the cost hierarchy where it is available for entry. The cost hierarchy determines how a segment inherits an account number. If you enter an account number at a higher level, such as the company account at the payroll level, each lower level of the cost hierarchy inherits that number. If you do not want all the levels to inherit the same number, you can specify the levels at which to override the account number. Overrides identify costs at a more granular level.

The level at which you enter costs is a key determinant in how the application builds the account number. The application starts with the lowest level (element entry) and ends with the highest level (payroll), checking for a value at each level until a value is found. For example, if you specify that a cost center segment is available for entry at the department and job levels, if the application finds a cost center number at the job level, it uses that number and not values at any higher levels.

The following figure shows the different levels of the cost hierarchy.

Cost hierarchy levels

When setting up the segment labels for the cost allocation key flexfield, consider which level of the cost hierarchy to enable the segment for entry. The following table includes example of the segment labels you might specify for costing.


Cost Hierarchy Level

Example

Payroll

Select payroll segment label for segments that seldom change for the people assigned to the payroll, such as company, line of business, and future use segments.

Job or Position

Select job segment label to compare and roll-up costs based upon job category.

Select position segment label if you are using position management at your enterprise, to better track the cost of turnover to the enterprise.

Costing at these levels requires higher maintenance to set up and manage the costing in diverse and complex organizations.

Person

Select segment label for Person to enable costing at the payroll relationship, term, and assignment level, and for elements at each of these levels.

You might select Person to enable allocation of wages when costs are shared by several cost centers, or to override the activity or natural account segment that is usually enabled at the element level.

Number of Key Flexfield Structure Instances

You create structure instances of your cost allocation key flexfield that you then associate to legislative data groups. Structure instances share the same set, arrangement, and properties of the cost allocation key flexfield structure.

Before creating structure instances, determine how many instances you require. You associate a single instance to a legislative data group on the Manage Legislative Data Groups page, but you can associate the same instance to several legislative data groups, as long as they all use the same value sets.

To fully implement the cost allocation key flexfield, you specify rules in Oracle Subledger Accounting that identify the flexfield instance to use as the source for entries in the chart of accounts. You map each segment of your cost flexfield instance to the corresponding segment of the accounting flexfield for your chart of accounts using the Manage Account Rules task. If you selected the option when you created your accounting flexfield instances in Oracle Fusion General Ledger to allow dynamic account combination, when you save the account rule, Subledger Accounting automatically creates the corresponding account combinations for General Ledger. (Otherwise, you must create General Ledgers accounts that correspond to each of the account combinations you plan to use in payroll using the Manage Account Combinations task.)

Account numbers generated by payroll costing are validated against the cost-code combinations created in General Ledger when the Create Final Accounting process is submitted

Payroll Costing Components: How They Work Together

Payroll costing integrates components required to accurately report labor costs and generate journal entries for your payroll run results and payments. To set up and manage payroll costing, you must have the appropriate duty roles to create components used by payroll costing, such as ledgers that you associate to legal entities, accounting methods and rules, and banking information.

Payroll costing involves creating the following components:

The following figure illustrates how Oracle Fusion Global Payroll works with the following applications: Oracle Fusion Financials to maintain chart of accounts, ledgers, accounting periods, and calendars for legal entities; Oracle Fusion Cash Management to reconcile payments with bank statements; and Oracle Fusion Subledger to create journal entries for transfer to General Ledger.

Global Payroll integrates with Financials

The following figure shows the different components you set up for payroll costing grouped by application.

Components created in Global Payroll
and the Financials applications, including General Ledger, Cash Management,
and Subledger Accounting

Financial Information

You create components in Financials that support payroll costing, such as general ledgers, accounting calendars, and accounting periods. For example, you create ledgers in Financials that you later associate to your payrolls.

You create an accounting key flexfield structure for the chart of accounts and create General Ledger accounts that receive costing entries, such as cost, offset, payroll liability, cash clearing, and cash accounts. Most enterprises use the structure of this key flexfield and the value sets as a basis for the structure of the cost allocation key flexfield.

When you create the equivalent accounts in payroll, you should ensure that the same natural account is used in payroll that you use in your General Ledger accounts. By using a similar structure, you avoid discrepancies, minimize maintenance, and improve communication between departments when resolving questions about account entries. For example, you would want to ensure that the Cash account uses the same natural account in Payroll as in General Ledger so that you can easily reconcile the cash account balance with the bank balance for transactions for the same bank account. The Application Implementation Consultant with the appropriate Financial duty roles can perform these tasks.

Cost Allocation Key Flexfield

You create an account key flexfield structure based on the cost allocation key flexfield code, and then create a structure instance that you associate to appropriate value sets. You map the structure instance to a legislative data group. You specify rules in Subledger Accounting on the Manage Account Rules page to use the cost allocation key flexfield instance as the source for segments in the accounting key flexfield for the chart of accounts. If you selected the option when you created your accounting flexfield instances in Oracle Fusion General Ledger to allow dynamic account combination, when you save the account rules, Subledger Accounting automatically creates the corresponding account combinations for General Ledger. (Otherwise, you must create General Ledgers accounts that correspond to each of the account combinations you plan to use in payroll using the Manage Account Combinations task.)

The cost flexfield structure determines at which levels of the payroll cost hierarchy you can enter account information when you create your payroll accounts. Specifying different levels at which to enter account information for a segment enables you to override account information. For example, you might specify that the department and job level can hold account information for a cost center segment, which would then enable you to specify a different cost center for a job than the department.

Subledger Accounting Methods and Rules

Subledger Accounting generates subledger journals, creates subledger balances, and generates general ledger journals. Payroll supplies predefined data for Subledger Accounting, such as event classes for event entities. You create accounting methods, and journal line and entry rules that Subledger Accounting uses to create accounting entries and post them to general ledger. You must have the Subledger Accounting duty roles required to perform these tasks.

Cash Management Bank Account and Reconciliation Information

Payroll requires bank account information for Check and EFT payment types, and optionally for Cash and Money Order payment types. If you plan to cost the payments that you issue, complete the bank, branch, and bank account information for the payment source and specify the General Ledger cash account. To reconcile your payments, you create reconciliation rules, map transaction types to payment types, create bank statement transaction codes, and specify the General Ledger accounts for cash clearing and reconciliation differences. You must have the Cash Management duty roles required to perform these tasks

Payroll Cost Accounts

After creating the components that support payroll costing in the other applications, you create the costing setup information for the different payroll accounts you intend to use, such as the cost, offset, suspense, default, payroll liability, cash clearing, and cash accounts. You enter the account information and any overrides for the different levels of the cost hierarchy. You must ensure when you set up the cash and cash clearing accounts that the natural account segment you specify for these accounts is the same as the natural account specified in the equivalent general ledger accounts.

Payroll Costing and Payroll Accounts Setup: Critical Choices

Payroll accounts capture the account information required to generate journal entries for the ledgers used by your legal entities, and to produce the data required to accurately report and track labor costs based on regulatory and corporate requirements. The framework for payroll accounts accommodates cash and accrual accounting, distribution of costs over earnings elements, allocation of costs to multiple accounts, and the reconciliation of payments.

The payroll accounts you create store cost, payment, and offset costing results. The application places cost results with errors in a suspense account and unallocated costs in a default account for review and corrective action. Review the following choices about the payroll accounts and the options for managing the costing results:

Offset Accounts

Identify which accounts your enterprise uses to create balancing entries required for double-entry bookkeeping. Create offset accounts on the Manage Costing of Elements page for each element eligibility record that you cost.

For elements that affect net pay, the offset for cash accounting is usually an asset account, such as Cash in Bank, and for accrual accounting a payroll liability account, such as Wages Payable. Employer taxes and benefit expenses generally use offset accounts specific to the types of liability.

The cost allocation key flexfield determines the segments available for entry for the offset account. You do not have to complete all the segments. If you leave a segment blank, the application builds the account information based on the corresponding segment entered for the cost account.

Payment Accounts

The number of payment accounts you create depends on whether your company uses cash or accrual accounting, and whether you reconcile your payments.

For both cash and accrual accounting, create a cash account for each separate bank account, entering the appropriate natural account for each record. If you use accrual accounting, create payroll liability accounts for your payment sources. If you reconcile your payments, create a cash clearing account to generate costing entries when the payments clear. When you create these accounts, ensure that you select the same account numbers for the segments as the General Ledger accounts you select when specifying the bank account information in Cash Management. By using the same account information, you avoid discrepancies and minimize maintenance.

Suspense and Default Accounts

You can create payroll suspense and default accounts at the payroll or department level of the cost hierarchy. Suspense and default entries for a department override those at the payroll level.

Review your enterprise requirements to decide at which level you resolve invalid or unallocated cost results. For example, you may decide to create the default account at the department level, to aggregate unallocated cost results so that they are more easily identified and processed.

Cost Account Overrides

You can override the costing information to meet specific conditions, such as costing for a job or person or for a specific payroll period. You can also override the standard process of building the cost account by creating a Priority account to cost element results.

You can control the level of granularity for costing by entering costing information for:

You can override the standard process for calculating the cost account by creating a Priority cost account. You might create a Priority account to ensure that the application costs the entire cost or a portion of the cost to a single account number. If you specify a percentage of the cost to a Priority account, the application creates a costing entry for the percentage allocated to the Priority account, and a costing entry for the remaining percentage, by using the standard costing process to derive the cost account number.

Cost Allocation and Distribution

You have a choice to divide a cost among accounts, for example to divide labor costs over more than one cost center. You can also distribute your overhead expenses across earnings elements, such as employer liability and tax charges.

You can allocate costs when creating:

Note

With the exception of the Priority account, the total percentage you allocate to each account must equal 100 percent.

You set up distributed costing by creating the cost account information for the distributed element on the Manage Costing of Elements page and the distribution element groups that include earnings elements on the Manage Object Groups page. You can control whether to include all or a portion of each earning element, and whether to include the earnings element in more than one distribution group.

Transfer to General Ledger

If you plan to transfer payroll and payment costs to Oracle Fusion General Ledger, you select options on the costing setup pages. Specify on the Manage Costing of Elements page and the Manage Costing of Payment Sources the elements and payment sources that you intend to post to general ledger.

Default configuration parameters specify the basis for accounting dates, which you can review and update as required on the Manage Payroll Process Configuration.


Parameter Name

Parameter Description

Default Value

Transfer to GL Process on Date Earned

Date earned or date paid, used to transfer and post journal entries for costing results to Oracle Fusion General Ledger

P

Reversal and Balance Adjustment Accounting Date

Accounting date based on the process date of the reversal or balance adjustment or the process end date of the Transfer to Subledger Accounting process.

T

Retroactive Costing

There are two retroactive costing processes, one which recalculates costs after you change the costing setup, and one which calculates costs for retroactive pay.

Before you can run:

Payroll and Financials Setup: Explained

Oracle Fusion Global Payroll integrates with Oracle Fusion Financials. You create components as part of your implementation such as chart of accounts, ledgers, and accounting calendars, which you use when creating payroll definitions and when distributing accounting for payroll costs.

Complete the following setup tasks in the Setup and Maintenance area for the chart of accounts and ledgers. If you integrate Global Payroll and Financials in a single system, assign an application implementation consultant role or appropriate duty role to a Financials or payroll manager.

Chart of Account Setup Tasks

Complete the following tasks to set up your chart of accounts information. Later, you associate the chart of accounts to a ledger.


Task

Action

Manage Chart of Accounts Value Sets

Create new or review existing value sets for association with a key flexfield segment.

Manage Chart of Accounts Structures

Create account structures that specify the segments to include, their order, and the value sets to validate the data entered in the segments.

The key flexfield, Accounting Flexfield, is predefined for you in Oracle Fusion General Ledger.

Manage Chart of Accounts Structure Instances

Create account structure instances used to record transactions and maintain account balances.

Manage Chart of Accounts Value Set Values

Create groups of values assigned to a key flexfield segment.

Manage Account Hierarchies

Search, create, and edit hierarchical groupings of accounts.

Manage Accounting Calendars

Set up accounting calendar period details. Determine the total number, frequency, and duration of the accounting periods.

Manage Account Combinations

If you do not select the option for your chart of accounts structure instance to allow account combinations to be dynamically created, you create account combinations. You create accounts for each account combination used in payroll, for example, for your payroll liability, cash, cash clearing, default, and suspense accounts. As a best practice, use the same account numbers in payroll and General Ledger.

If you reconcile payments in Oracle Fusion Cash Management, create an account combination for reconciliation differences.

Ledger Setup Tasks

You perform the following tasks as part of the accounting configuration setup for payroll.


Task

Action

Manage Primary Ledgers

Create a ledger with a chart of accounts, accounting calendar, currency and subledger accounting method.

If you are creating bank information, you must create a primary ledger.

Assign Legal Entities

Add the legal entities that use the ledger.

When you create a payroll definition, you select a legislative data group. The list of available ledgers includes only ledgers assigned to legal entities associated with the legislative data group. (The Manage Legal Entity HCM Information task associates the payroll statutory units for legal entities to the legislative data group.)

Specify Ledger Options

Complete the fields for the General Information, Accounting Calendar, and Subledger Accounting sections. In the Period Close section, select the Retained Earnings Account you will use for payroll. In the Journal Processing Intercompany subsection, select the option to launch AutoReverse after the open period.

Assign Balancing Segment Values to Legal Entities

Assign specific balancing segment values to each legal entity before assigning values to the ledgers. By specifying this information, you can more easily identify legal entities during transaction processing and reporting

Assign Balancing Segment Values to Ledger

Optionally, assign specific primary balancing segment values to the primary and secondary ledgers to represent transactions for nonlegal entities, such as adjustments.

Manage Reporting Currencies

Review and update reporting currencies. Reporting currencies maintain and record subledger and general ledger journal entries in additional currencies.

Review and Submit Accounting Configuration

Submit your configuration.

Open First Period

Open the first period when you are ready to process transactions for the ledger.

the Open First Period Task is used initially to open the first period. Afterwards, you use the Manage Accounting Periods in General Ledger to open and close periods, and to specify the target period that concludes the series of calendar periods.

Payroll Costing and Subledger Accounting Setup: Explained

Oracle Fusion Global Payroll integrates with Oracle Fusion Subledger Accounting to streamline accounting tasks. Payroll transactions generate accounting events such as the costing of the payroll run, payments, and partial period accruals. Subledger Accounting applies rules to the transaction data and creates subledger journal entries and subledger balances for each payroll cost, and posts this information to Oracle Fusion General Ledger. This integration simplifies the management of corporate and statutory audit and reporting requirements by recording detailed and summary information, and facilitates the reconciliation of payments with Oracle Cash Management.

Global Payroll provides predefined data for Subledger Accounting. Subledger Accounting uses this data when creating accounting entries for payroll transactions and posting the resulting journal entries to General Ledger. You create additional components in Subledger Accounting to support costing, such as accounting methods and rules.

Predefined Tasks

When you create your implementation project, you can configure the Financials offering by selecting the Define Subledger Application and Sources task list from the Select Features Choices page. You can include this task list to view the Subledger Accounting information that supports payroll costing. The information includes the definition of attribute values, process categories, event classes and event class options, sources, source assignments and accounting attribute assignments, journal line types, account derivation rules, journal lines definitions, and application accounting definitions.

Required Tasks

The Define Subledger Accounting Methods task list includes tasks you must complete to integrate Subledger Accounting with Payroll.

You perform the following tasks as part of the setup required for defining payroll costing.


Page

Action

Manage Account Rules

Specify the segment rules for each segment of the chart of accounts flexfield structure that has a corresponding source segment in the cost allocation key flexfield. Enter conditions to use for the rules.

If you selected the Oracle Fusion General Ledger accounting key flexfield option to allow dynamic account combination, when you save the account rule, Subledger Accounting automatically creates the corresponding account combinations for General Ledger. (Otherwise, you must create General Ledgers accounts using the Manage Account Combinations task.)

Manage Subledger Journal Entry Rules Sets

Create journal entry rule sets for each type of event class: Costs, Payment Costs, Run Costs, and Partial Period Accrual for event types All and Reversal. Confirm the status is active.

Manage Journal Line Rules

Create journal line rules for the journal rule sets that have the same event class, and assign conditions.

Manage Accounting Methods

On the Payroll tab, add the journal rule set for each event class. From the Actions menu, change the status to active.

Manage Subledger Accounting Options

Specify accounting options to define how journal entries are generated from subledger transactions. Determine whether to summarize by general ledger date or by general ledger period.

Optional Tasks

Complete the following optional tasks.


Page

Action

Import Supporting Reference Initial Balances

Import source values for the balances maintained by the segments that store supporting reference balances.

Manage Description Rules

Define the rules for the descriptions that appear on the subledger journal entry at the header and the line level.

Manage Supporting References

Decide what additional source information to store about a subledger journal at the header or line level.

Payroll Costing of Elements: Critical Choices

The Manage Costing of Elements page records your choices about how to cost the element eligibility records for an element. You can decide which input values for the element to cost and which offset account to use to balance the cost account. You also have the choice of creating an override cost account, a Priority account, to ensure that you cost the run results to only one account number.

After you complete the initial implementation and create your person records, you can further define the costing of elements for specific people in your enterprise to cover situations where, for example, you need to cost the person's element run results to a different natural account or activity, such as specifying a separate account for commission bonuses for a group of sales people.

When you create costing for elements, review the following points:

Element Eligibility Records

If you plan to cost the run results for an element processed in a payroll run, you must specify at least one element eligibility record when you create the element. You do not need to specify element eligibility criteria, but you must create a name for the element eligibility record. Cost the element eligibility records for the element that includes the primary output value, either the base element or the results element.

When you cost the base or the related results element, cost all its element eligibility records, even if the costing is the same for all the eligibility records. If you do not cost all the eligibility records, the application costs only those entries that have eligibility records with costing information.

The element classification determines whether the costing results for the cost and offset accounts for the element eligibility record create credits or debits, and whether the application can include the element as a member of a distribution group.

Costing Type

The costing type determines whether the application should cost the payroll run results and distribute the cost over earnings elements. The costing type is also one factor in determining which levels of the cost hierarchy the application checks when building the account number for each segment.

Offset Accounts

The cost allocation key flexfield determines the segments available for entry for the offset account. You do not have to complete all the segments. If you leave a segment blank, the application builds the account information based on the corresponding segment entered for the cost account.

Distributed Costing

Distributed costing allocates costs for the payroll run result values of distributed elements over earnings elements. For example, the costs for employer taxes, charges, and liabilities are generally distributed over earnings elements such as wages, overtime, and shift pay.

Identify which elements have costs that you plan to distribute, and which earnings elements to include as members of the distribution group. You create distribution groups on the Manage Object Groups page. Create an object group of element group type, and distribution usage type, and select the elements to include in the group.

When payroll calculates the costs for the distributed element, the application allocates the costs based on the ratio that each element in the distribution group contributes to the total cost. The application creates the distributed cost entries for each earnings element in the distribution group, replacing the account numbers for the segments of the earnings elements with the account numbers for the corresponding segments defined for the distributed element.

Priority Accounts

Decide whether to use a Priority account as a separate cost account to ensure that all cost results for the element are allocated to one account and that no overrides occur at other levels of the cost hierarchy. You might choose this option if you fund a specific labor cost entirely or partially by one account.

For example, if a percentage of wages are funded by a matching grant, you might enter a cost account and a priority account. You would specify the percentage of the element that receives this funding and enter the priority account information, and then enter the appropriate segments for the cost account. The application would apply the specified percentage of the costs for the element's run results to the priority account and use the standard costing process to derive the cost account for the remaining percentage.

Payroll Cost Results: How They Are Calculated

Payroll processes generate costing results and create journal entries used to record your labor costs.

Settings That Affect Payroll Run Cost Results

Several settings affect how the application costs a payroll run result for a payroll relationship:

How the Costing is Calculated

The different costing processes generate costing entries for payroll run results or payments generated at the payroll relationship level, and offset entries to balance those entries. For example, when calculating the payroll, the application costs a salary run result value as a debit to an expense account and offsets the same amount as a credit to a payroll liability account. When costing a cleared payment, the application costs a payment as a debit to a clearing account and offsets the same amount as a credit to a cash account.

The application calculates the costing result for a payroll run result value and a payment value in different ways. When building the cost account for:

The application places invalid entries for costed payroll run result values and payments in a suspense account and incomplete entries in a default account. After editing the costing setup, you can process a corrective action to cost the entry to the appropriate account. The application offsets the original costing when the corrected account number is generated, which clears the suspense or default account.

This table lists the standard costing hierarchy levels checked when the application builds the account number for payroll run result values and where to manage these settings.


Level of Costing Hierarchy Checked for Costing Details

Sequence of Costing Hierarchy Levels Checked When Costing Payroll Run Result Values

Accounts Checked for Costing Details

Costing Types Checked for Costing Details

Page Where Costing Details Are Managed

Element Entry

First level checked when building each account segment. If costing details are not found for that segment, the application proceeds to the next level, the Person Element - Assignment level.

Cost

Fixed Costed, Costed, Distributed

Manage Element Entries

Person Element - Assignment

Next level checked.

Cost

Costed, Distributed

Manage Costing for Persons

Person Element - Terms

Next level checked.

Cost

Costed, Distributed

Manage Costing for Persons

Person Element - Payroll Relationship

Next level checked.

Cost

Costed, Distributed

Manage Costing for Persons

Person - Assignment

Next level checked.

Cost

Costed, Distributed

Manage Costing for Persons

Person - Terms

Next level checked.

Cost

Costed, Distributed

Manage Costing for Persons

Person - Payroll Relationship

Next level checked

Cost

Costed, Distributed

Manage Costing for Persons

Position

Next level checked.

Cost

Costed, Distributed

Manage Costing of Positions

Job

Next level checked.

Cost

Costed, Distributed

Manage Costing of Jobs

Department

Next level checked.

Cost, Default, Suspense

Costed, Distributed

Manage Costing of Departments

Element Eligibility

Next level checked.

Cost, Offset, Priority

Fixed Costed, Costed, Distributed

Manage Costing of Elements

Payroll

Last level checked for costing information. If costing setup information is not found for that segment and the resulting costing account number is incomplete, the entry is costed to a Default account or, if invalid, to the Suspense account

Cost, Default, Suspense

Fixed Costed, Costed, Distributed

Manage Costing of Payrolls

When building the account number for the payroll run result values for a retroactive pay element, the Recalculate Payroll for Retroactive Changes process checks for costing details as of the current payroll period and the original payroll period. This table lists the costing hierarchy levels checked when the application builds the account number for retroactive payroll run result values and where to manage these settings.


Level of Costing Hierarchy Checked for Costing Details for Retroactive Pay

Sequence of Costing Hierarchy Levels Checked for Costing Details

Current or Original Payroll Period Checked for Costing Details

Accounts Checked for Costing Details

Costing Types Checked for Costing Details

Page Where Costing Details Are Managed

Retroactive Pay Element Entry

First level checked for costing details when building each account segment for retroactive pay elements only. If costing details are not found for that segment, the application proceeds to the next level, the Retroactive Pay Element Eligibility level.

Current

Cost

Fixed Costed, Costed, Distributed

Manage Element Entries

Retroactive Pay Element Eligibility

Next level checked for retroactive pay elements only. If costing details are not found for that segment, the application proceeds to the Element Entry level of the original payroll period.

Current

Cost

Fixed Costed, Costed, Distributed

Manage Costing of Elements

Element Entry

Next level checked.

Original

Cost

Fixed Costed, Costed, Distributed

Manage Element Entries

Person Element - Assignment

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing for Persons

Person Element - Terms

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing for Persons

Person Element - Payroll Relationship

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing for Persons

Person - Assignment

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing for Persons

Person - Terms

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing for Persons

Person - Payroll Relationship

Next level checked

Original

Cost

Costed, Distributed

Manage Costing for Persons

Position

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing of Positions

Job

Next level checked.

Original

Cost

Costed, Distributed

Manage Costing of Jobs

Department

Next level checked.

Original

Cost, Default, Suspense

Costed, Distributed

Manage Costing of Departments

Element Eligibility

Next level checked.

Original

Cost, Offset, Priority

Fixed Costed, Costed, Distributed

Manage Costing of Elements

Payroll

Last level checked for costing information. If costing setup information is not found for that segment and the resulting costing account number is incomplete, the entry is costed to a Default account or, if invalid, to the Suspense account

Original

Cost, Default, Suspense

Fixed Costed, Costed, Distributed

Manage Costing of Payrolls

This table lists the payroll processes that generate costing entries and describes the calculations.


Process That Generates Costing and Accounting Results

Description

Recalculate Payroll for Retroactive Changes

Calculates costing for retroactive changes that were not included in the original payroll run, and records the difference found between the original entry and the retroactive result.

Calculate Payroll

Calculates the costing for the payroll run results for payroll relationships after the run results are calculated.

Calculate QuickPay

Calculates the costing for the payroll run results for a payroll relationship processed by the Calculate QuickPay process for a single employee.

Reverse Payroll Calculation

Negates the costing results generated by the Calculate Payroll process by creating costing entries that offset the original entries. The process uses the effective date of the reversal process as the accounting date to avoid creating entries for a closed accounting period. The reversal creates an audit trail, unlike the rollback action which eliminates the audit trail by deleting the original entry.

Adjust Cost for a Person

Reallocates costing results to different accounts using a manual adjustment process. An offset entry is created for the original entry based upon the amount of the new entries created. A user can reallocate the entire costing result or part of it to one or more different accounts.

Costing of Balance Adjustment

Calculates the costing for the payroll run results of the Adjust Individual Balances process.

Calculate Retroactive Costing

Recalculates costing based upon retroactive changes to costing setups. The process compares the recalculated and original entries, and where different, offsets the original entries and creates new ones. The effective date of the process is used as the accounting date when transferring the results to general ledger.

Calculate Partial Period Accruals

Calculates accrual entries for a partial payroll period, prorating the costing results based on the previous results of a full period, and using as the accounting date, the date of the Partial Period Accruals process. The process also creates reversal entries with an accounting date of the payroll period end date. The process is often used when a payroll period overlaps two accounting periods.

Calculate Costing of Payments

Calculates costing for prepayments, QuickPay prepayments, and external payments. It also offsets the costing for voided payments by negating the original costing. If you reconcile payments, after payments have cleared the bank, the process creates entries that debit the clearing accounts and credit the cash accounts.

Transfer to Subledger Accounting

Creates subledger accounting events for each payroll relationship to identify the payroll costing entries that are transferred to Oracle Fusion Subledger Accounting when the Create Draft Accounting and Create Final Accounting processes are run.

Create Draft Accounting

Creates draft journal entries in Subledger Accounting. You can preview the journal entries before you run the Create Final Accounting process that transfers the entries to Oracle Fusion General Ledger.

Create Final Accounting

Creates final journal entries in Subledger Accounting. Creates journal entries, transfers the entries to Subledger Accounting, and transfers and posts them to Oracle Fusion General Ledger.

Costs Distributed Across Payroll Run Results: How They Are Calculated

Many enterprises distribute the costs for employer taxes, charges, and liabilities over earnings elements, such as wages, overtime, and shift pay. When you set up costing, you specify the costing for the distributed element eligibility records, and identify which elements belong to the distribution group over which the costing results are allocated.

Settings That Affect Distributed Payroll Costs

Several settings control how the costs for an earnings element are calculated:

How Distributed Payroll Costs Are Calculated

The application allocates the cost for the distributed element's run result value over the costed run result values for the elements in the distribution group. The application allocates the cost proportionately based on the amount each element contributes to the total for the distribution group. Only elements in the distribution group that produce actual run result values have costs distributed over them.

This distribution maintains the ratio that each element's costed run result value contributes to the total for the distribution group. For example, if a salary element contributes 70 percent of the total costed run results for the distribution group, the overtime contributes 20 percent, and the commission 10 percent, the application allocates 70 percent of the employer liability to the salary, 20 percent to the overtime, and 10 percent to the commission. If the distribution group does not include a run result value for the commission, then the application distributes the liability cost over the two remaining elements proportionate to the amount each contributes to the total.

If none of the earnings elements produce actual results, the application enters the costing result for the distributed element in a suspense account.

The application creates cost and offset entries for distributed elements. The distribution depends on how you set up costing for the distributed element on the Manage Costing of Element page. If you:

Example

In the following example, the distributed element is the employer pension tax and the distribution group consists of the costed run result values for the regular and overtime wages for Departments 120 and 053.

This table lists the liability and expense accounts used in the example.


Account Classification

Account Name

Account Number

Liabilities

Wages Payable

2110

Liabilities

Pension Payable

2150

Liabilities

Employee Pension Payable

2151

Liabilities

Employer Pension Payable

2152

Expense

Regular Wages

5110

Expense

Overtime

5130

Expense

Employer Pension Tax

5220

This table shows the primary output values calculated for the employee's regular and overtime pay while working for two different departments.


Elements included in the Distribution Group

Division

Department

Hours

Rate (USD)

Primary Output Value

Percent Costed Run Result Contributes to the Total for the Distribution Group

Regular Wages

10

120

30

10

300

61.2

Regular Wages

50

053

10

10

100

20.4

Overtime Wages

50

053

6

15

90

18.4

The employer and employee each contribute a rate of 6.2 percent of the employee's gross pay to the pension fund. In this example, the elements in the distribution group constitute the gross pay. The total for the elements in the distribution group is 490 USD. The employee and employer each pay 6.2 percent of the gross pay, or 30.38 USD. The employer's share is distributed over the elements in the distribution group.

This table shows the percentage of the distributed element allocated to each department based on the amount each element contributes to the total for the distribution group.


Distributed Element

Element in the Distribution Group

Division

Department

Percent Allocated Based on the Amount the Element Contributes to the Total of the Distribution Group

Distributed Amount (USD)

Employer Pension Tax

Regular Wages

10

120

61.2

18.60

Employer Pension Tax

Regular Wages

50

053

20.4

11.78

Employer Pension Tax

Overtime Wages

50

053

18.4

5.59

This table shows the costing entries calculated for the distributed element.


Costing Entries

Distributed element

Input Value

Distributed Input Value

Account Name

Division Department Account

Debit (USD)

Credit (USD)

Regular Wages

Pay Value

Regular Wages

10.120.5110

300

Offset

Wages Payable

00.000.2100

300

Regular Wages

Pay Value

Regular Wages

50.053.5110

100

Offset

Wages Payable

00.000.2100

100

Overtime Wages

Pay Value

Overtime

50.053.5130

90

Offset

Wages Payable

00.000.2100

90

Employer Pension Tax

Employer Pension Tax

Liability Amount

Employer Pension Tax

10.120.5220

18.60

Offset

Employer Pension Payable

00.000.2152

18.60

Employer Pension Tax

Employer Pension Tax

Liability Amount

Employer Pension Tax

50.053.5220

11.78

Offset

Employer Pension Payable

00.000.2152

 

11.78

Employee Pension Tax

Liability Amount

Employee Pension Payable

00.0000.2000

 

30.38

Offset

Wages Payable

00.000.2100

30.38

 

Manage Object Groups

Object Groups: Explained

Use object groups to define subsets of objects used for processing or reporting.

There are four types of object groups:

Element Groups

Element groups limit the elements processed for payroll, reporting, or cost distribution purposes.

There are two usages for an element group:

All element groups are static. You select the element classifications to add and then include or exclude additional elements from the group. Or you can select specific elements to include without using element classifications.

Payroll Relationship Groups

Payroll relationship groups limit the persons processed for payroll, data entry, and reporting. When defining the group specify the payroll definition which retrieves the payroll relationships assigned to it. Every group is limited to the payroll relationships assigned to a single payroll that you select. You can further define the group statically or dynamically.

Work Relationship Groups

Work relationship groups limit the persons processed for human resources and reporting. For example, you can use work relationship groups in custom extracts. If you define the group statically, select the work relationships, terms, and assignments to include or exclude in the group. If you define the group dynamically, use a fast formula of type Work Relationship Group to determine the criteria that determines the work relationships, terms, and assignments to include in the group. Then you can individually select additional work relationships, terms, and assignments to include in or exclude from the group.

Deduction Card Groups

Deduction card groups are read-only. They are automatically created when deductions cards are created. For example, in the UK, they are used for year-end processing.

Define Payroll Flow Patterns

Payroll Flow Patterns: Explained

A payroll flow pattern consists of a sequence of tasks, which represent the tasks you complete in each phase of the payroll cycle. You can use the predefined flow patterns or create new ones for tasks you normally perform during a payroll period.

When you create a flow pattern, you can:

The task pane of the payroll work areas include a task to submit a flow pattern. Submitting a flow pattern generates a payroll flow, which you can monitor from the Payroll Dashboard, and with a payroll checklist that lists the tasks on a single page, so that you can easily monitor, perform, and reassign the tasks to someone else.

Include Predefined Tasks

Predefined tasks are the building blocks of flow patterns. Predefined tasks are associated to an activity, which corresponds to a phase of the payroll cycle, and optionally to a task group within the activity.

All payroll flow patterns begin with a start task and conclude with an end task. Flow patterns can include:

This figure shows a payroll flow pattern for a single task.

Payroll flow pattern with a start task,
report task, and an end task.

This figure shows a payroll flow pattern of several tasks.

Payroll flow pattern with a start task,
multiple tasks, and an end task.

Task Action

Each payroll task has subordinate task actions. Task actions are based on the work the task performs and how it does this work within the application. They describe how the task is executed, such as submit, roll back, mark for retry, retry, and view. Each task action includes task parameters that control how the application processes a task and how the task relates to other tasks in the flow pattern. When you create a flow pattern, you can review the predefined task-action parameters and edit them, for example, to specify a different lookup value set.

This figure shows the relationship of a task to its subordinate task actions and their parameters.

Flow Pattern with subordinate task
action and its task-action parameters

Rename and Rearrange Task Sequence

You can rename tasks on the Tasks Sequence page and add descriptions to tasks to more clearly identify their use. For example, if you have a payments flow pattern that includes two payment processes, you might add a manual task after each payment task, rename these tasks and add descriptions to reflect the type of payment and validation to perform.

The sequence in which you initially select the tasks for your flow pattern on the Basic Information page determines the order in which you view the tasks on the Task Sequence page. You can rearrange the order on the Task Sequence page, as well as remove and add tasks. For example, you might remove a report task from the Calculations activity and add it to the Statutory activity.

Specify Flow Parameters

When you create a flow pattern, you specify flow parameters, the subset of input task parameters that a person submitting the flow enters and that the application uses to derive values needed to successfully complete the tasks included in the flow pattern.

Specify Optional Information

You can specify optional information for a flow pattern, including when a task starts or is due, and which types of notifications to send the task owner, such as overdue reminders, and error and warning messages.

You can restrict who can perform the tasks in it by designating owners for specific tasks. After you create a flow pattern, you can control access to it by creating a security profile and associating it to the appropriate data roles.

Payroll Flow Pattern Parameters: Explained

The payroll flow pattern parameters capture the information necessary to complete the tasks in the flow pattern. Tasks parameters determine how the application processes a task, and how the task relates to other tasks in the flow pattern. Flow parameters consist of a subset of the input task parameters that the person submitting the flow enters and that the application uses to derive values when processing the tasks in the flow pattern.

You can review and update the task and flow parameters for the flow patterns you create.

The following figure shows how the flow parameters are a subset of task-action parameters required to generate the entire payroll flow and complete the tasks successfully.

Flow parameters form a subset of task
action parameters

When you create a flow pattern, you review and update the parameters for the submission and initialization task actions. After you submit the flow pattern, you can edit the other task-action parameters, such as those for Mark for Retry, Retry, and Roll Back. The parameter details you can update include:

Display and Display Format

Display parameters determine whether someone can view and enter parameters and the format for displaying them.

The Display option controls whether the person submitting a standalone task flow can enter the parameter, add it as a search criteria to a work area Overview page, or view it in the Parameters region of the payroll flow.

The Display Format option identifies the type of data displayed, such as a date or text, or choice list. The Display Format works in conjunction with other parameters such as the Parameter Basis and Basis Value, and the Lookup and Value Set details. For example, the Request parameter is not displayed because the application obtains it from the context.

Lookups and Value Sets

Use lookups and value sets to control and validate the data used in the payroll flow pattern. Specify lookups for parameters and value sets for descriptive flexfields.

The following table describes the type of methods used for lookups.


Method

Parameter Basis

Person submitting the flow enters the lookup value from a smart list or choice list

Bind to Flow Parameter

Application derives the value from existing tables, such as the value for the payroll statutory unit

Bind to Flow Task Parameter or Bind to Context

Application obtains the value based on a Post SQL process, such as a consolidation group

Post SQL

If you create value sets for descriptive flexfields to validate the values someone can enter for the parameter, you can specify that value set.

Usage

A parameter can receive information (input) or generate information (output) that subsequent tasks can use as input. For example, the Calculate Payroll Submit task action includes a Payroll Process parameter that generates an output value for the payroll action ID which is used as an input for the Calculate Payroll Retry task action.

Parameters that use the output of other tasks are not usually displayed in the UI. If the parameter is an output parameter, then the type of binding is Bind to Flow or null. If the binding is:

Sequence

You can control the order in which the application processes and displays the parameters by specifying the sequence. Sequence numbers provide the application with the default logic to derive the parameter order in which to process the parameters. For example, if you have two lookups and the values of the second lookup depends on the value selected for the first lookup, the first lookup would have a lower sequence number than the second lookup. For example, in the Calculate Payroll task, the lookup for the Payroll parameter would have a lower sequence number than the lookup for the Payroll Period parameter, so that the values for the Payroll Period list the payroll periods defined for the selected payroll.

Parameter Basis and Basis Value

The Parameter Basis tells the application how to derive the value for the parameter and the Basis Value further specifies the value the application should use for the parameter.

The following table lists the Parameter Basis options and gives examples of when you might select them.


Parameter Basis

Description

Basis Value

Example

Use Specified Value

Assigns a specific value to the parameter.

Value is entered or selected by user.

Use a constant if the value is the same for all tasks. For example, if you have only one payroll statutory unit, select Use Specified Value as the basis for the payroll statutory unit parameter and enter the text for the payroll statutory unit as the Basis Value.

Bind to Context

Derives the value from the context of the current flow instance or the task instance of the flow pattern.

Context information available on the Overview page of the work area depends on whether the Bind to Context is based on the payroll task or payroll flow. The Add fields are derived based on the parameters for the tasks relevant to the work area.

Value is based on the payroll flow, payroll task, or the Request. The application automatically generates the value.

Bind the Request parameter to the payroll flow context so that other tasks in the flow can reference the task, based on the Request ID which the application generates when the task is submitted.

Bind the legislative data group parameter to a task parameter that supplies the legislative data group. For example, the legislative data group for prepayments uses the payroll as context, because the payroll definition includes the legislative data group.

Bind to Flow Parameter

Derives the value from one of the flow parameter values.

Value is selected from the flow parameters.

Bind parameters to the flow that several tasks share to avoid multiple occurrences of the same parameter.

Bind to Flow Task Parameter

Binds the value to the output of the previous task.

Value is selected from the previous task's parameters.

Bind a parameter to a task, such as Retry corrective action, so that when the flow owner resubmits the task to retry it, the application uses the output of the Submit task parameter.

Bind to Task Parameter

Resolves the value for the task parameter.

Value is selected from the current task's parameters.

If several tasks share a parameter, such as a start date, but one task requires a different date, bind the parameter to the task.

Null

Stops the application from generating a parameter value when the task executes.

Parameter generated by the application is blank.

 

Post SQL Bind

Calculates the parameter but does not display it on the user interface.

SQL statement

Use Post SQL bind to generate data. For example, if the process date is not displayed as a flow parameter, the person submitting the flow does not enter it. Use a post SQL process to generate the process date from the payroll period and payroll parameters.

Predefined tasks such as Costing of Payments and Gross-to-Net reports determine the Basis Value for the Consolidation Group using Post SQL bind.

SQL Bind

Before the parameter is rendered the value is calculated and displayed on the user interface.

SQL statement

Use SQL bind, for example, to have the application calculate the payment type parameter for the Generate Check Payment task by obtaining the payment type ID that corresponds to the record queried for that check payment.

Another example of the SQL bind is to prompt the task owner to enter a reason for a corrective action, such as a QuickPay.

Payroll Flow Pattern Tasks Start and Due Dates: Critical Choices

You can specify the start and due date for any task in the flow pattern by selecting a duration date and further adjust the start or due date by entering an offset. The application then uses the resulting dates as a basis for sending notifications, such as overdue reminders. The list of values for the duration dates consists of the dates specified as flow level parameters, such as process date or date earned.

By specifying duration dates and notifications, you can ensure that task owners have adequate time to prepare material before the task starts or to address issues that arise before the task is due. Notifications with details about the task are sent by e-mail or to the worklist and are also displayed in the Payroll Dashboard.

Task Start and Due Dates

When a person submits a payroll flow, the payroll flow task begins after the completion of the previous task unless you schedule the task by entering a start date. The due date sets the date by which the task owner should complete the task.

You can control the start or due date by specifying:

Notifications

Select notifications to have the application send error and warning messages to the task owner, as well as notifications that a task has started or ended or is overdue.

The receipt of notifications about the start date or due date depends on the dates and their offsets. For example, if the process date is the date paid, you might specify an offset of 3 days in advance of the process date for the verification of the prepayment results to give the task owner adequate time to review the results and make any necessary corrections before generating the payments.

You can specify the amount of time before payroll flow notifications generated by the payroll flow expire. A Notification Expiration Offset parameter on the Manage Payroll Process Configuration page controls the number of days before a payroll flow notification is automatically deleted.

Managing Corrective Tasks in a Payroll Flow Pattern: Points to Consider

Most predefined process and report tasks support corrective task actions such as retrying or rolling back a task. Corrective payroll and payment tasks are usually submitted as separate flows. For example, the Cancel Payment flow pattern includes tasks to view the person process results, void the payment, process an external payment to prevent reissue of the original payment, and reverse the original payroll run calculations to negate the run results.

Before adding a corrective task to your flow pattern, consider whether people working with a flow based on your pattern will correct errors by:

Using Corrective Task Actions in a Flow Pattern

You do not need to incorporate task actions for payroll and payment corrective tasks in your flow pattern, such as marking for retry, retrying, reversing, or rolling back processes and report results. Most tasks support these task actions at the task level or individual record level. The type of task and the status of the task and resulting records determine which actions you can select from the Actions menu on the View Person Process Results page or from the Payroll Checklist or Processes and Reports tab of the payroll flow.

The following figure shows the task actions such as Mark for Retry, Retry, and Roll Back that you can choose as task actions from the Actions menu when working on the Payroll Flow Checklist or the Processes and Reports tab of the payroll flow.

Mark for Retry, Retry, and Roll Back
task actions available from the Actions menu when working on the Payroll
Flow Checklist or the Processes and Reports tab of the Payroll Flow.

Corrective Flow Patterns

If you have sequential tasks you perform to correct a problem, you can create a flow pattern that consists of those tasks. For example, a flow pattern to reissue a lost check might include tasks to void the payment, issue an external payment, and view the person process results.

Payroll Flow Checklist and Flow Tasks: Explained

The payroll flow pattern determines the sequence of payroll flow tasks executed in a payroll flow. Submitting a payroll flow generates a payroll flow checklist.

You can manage a payroll flow by working in:

Payroll Checklist Work Area

The payroll flow checklist contains the payroll flow tasks required to complete each activity phase of the payroll: preparation, calculation, payment distribution, accounting, and regulatory reporting.

A payroll flow task by default is associated to an activity, but it can recur in the same activity. For example, a payment distribution flow pattern might include a verification task after each type of payment, such as EFT payment and check payment.

The payroll flow checklist shows you the progression of the individual tasks that comprise the payroll flow. You can use the checklist to monitor the status of the payroll flow tasks and to manage the tasks. The checklist owner or flow task owner manages the flow tasks, for example, by reassigning tasks, revising due dates, marking tasks as complete, and performing actions the task supports, such as roll back and retry.

From the payroll checklist, you can navigate directly to the payroll flow task details. For example, you can navigate from the payroll calculation task directly to the Person Process Results page to view a list of workers processed in the payroll run.

Other Payroll Work Areas

While working with payroll flows, you can remain in the Payroll Checklist work area or navigate to the other payroll work areas to work on payroll flow tasks and access related payroll tasks.

The activities in the payroll flow checklist correspond to the individual payroll work areas. Each payroll work area includes additional tasks to manage the information processed for that phase of the payroll. For example, the Accounting Distribution work area includes tasks to view journal entries and revise cost allocations, and the Payroll Calculation work area includes tasks to manage payroll relationship information.

Creating a Payroll Flow Pattern to Reissue a Check: Worked Example

This example demonstrates how to create a payroll flow pattern to issue a replacement check that an employee lost or did not receive.

The following table summarizes the key decisions for this scenario.


Decision to Consider

In This Example

What activities do you want to include in the flow pattern?

Calculation and Payment activities

What tasks do you want to include in the flow pattern and in what sequence?

Verify a Payment, Void Payment, Generate Check Payment

Do you want to assign an owner to the flow?

InFusion Payroll Manager

Do you want the flow owner to receive notifications?

Error and Warning notifications

Do you want to override the task or flow parameters?

Process Configuration Group parameter for the Void Payment task

Create the Payroll Flow Pattern

  1. In the Payroll Checklist work area, select the Manage Payroll Flow Patterns task from the task pane.
  2. On the Manage Payroll Flow Patterns page, click the Create icon.
  3. Select the legislative data group, and click Continue.
  4. On the Create Payroll Flow Pattern: Basic Information page, complete the fields, as shown in this table.

    Region

    Field

    Value

    Basic Information

    Flow Pattern

    InFusion Reissue Check

    Activities

    Activities to Include

    Payment

    Tasks

    Available Tasks

    Void Payment, Generate Check Payments, Verify a Payment


  5. Click Next.
  6. On the Create Payroll Flow Pattern: Tasks page, select the Verify the Payment task.
  7. In the Owner and Checklist region, click the Owner field.
  8. Select an owner.
  9. Click Next.
  10. On the Create Flow Pattern: Tasks Sequence page, confirm the order in which the tasks occur: Verify a Payment, Void Payment, Generate Check Payment.
  11. Correct the sequence of tasks, if necessary. Select the row, click the Edit icon, and select a different following task. Repeat this process for each task.
  12. Click Next.
  13. On the Create Payroll Flow Pattern: Flow Parameters page, click the Select and Add icon.
  14. In the Select and Add window, select the parameters, as shown in this table.

    You can select multiple parameters from the Select and Add window.

    Field

    Value

    Void Payment

    Start Check Number, End Check Number, Process Configuration Group, Process Date, Payroll Process, Reason

    Note

    With the exception of the Reason parameter, these task parameters are used by the Generate Check Payment task. Add them only once as flow parameters to cover both tasks.

    Generate Check Payment

    Payroll, Start Date, Consolidation Group, Organization Payment Method, Overriding Payment Date, Payment Source, Payment Type


  15. Select the row for the Process Configuration Group flow parameter and click the Edit icon.
  16. Edit the flow parameters as shown in this table:

    Field

    Action

    Display

    No

    Display Format

    Text

    Lookups

    blank

    Parameter Basis

    Use Specified Value

    Basis Value

    InFusion Process Configuration Group


  17. Click Next to display the Create Payroll Flow Pattern: Task Parameters page.

    You do not need to edit the Process Configuration task parameter. The application uses the details specified for the flow parameter, not the details specified for the task parameter.

  18. Click Next.
  19. On the Create Payroll Flow Pattern: Review page, preview the resulting payroll checklist.
  20. Click Submit.

Editing Payroll Flow Patterns: Points to Consider

The activities of a payroll cycle include predefined tasks that you can include or exclude to correspond to the way in which your enterprise typically processes payroll. When you create a payroll flow pattern or edit it later, you can revise the initial list of tasks. You can add and delete tasks, move them to a different activity, rename them, and edit their descriptions.

Editing Tasks

You can edit flow patterns you create, but not predefined flow patterns. While editing flow patterns, it is helpful to keep in mind the following points when you add, delete, or move a task.

Editing Payroll Flow Patterns: Examples

Use these scenarios to understand the types of updates you might make to a flow pattern.

Updating a Parameter to Use a Specified Value

The payrolls you run use a single Process Configuration Group. On the Parameter tab for the Calculate Payroll task, you can update the flow parameters to specify the name of that configuration group so that the person submitting the payroll flow does not have to complete that information but relies on the application to supply the value.

The following table lists the values to enter for the task parameter details for the Calculate Payroll task to enter a constant for the Process Configuration Group.


Parameter Detail

Value

Display

No

Display Format

Text

Lookup

blank

Usage

Input Parameter

Parameter Basis

Use Specified Value

Basis Value

Name of the Process Configuration Group

Supplying a Reason for a Corrective Action

You have decided to add the Reason parameter to one of your tasks to better track why managers submit standalone tasks during a payroll cycle.

The following table lists the values to enter for the task parameter details for the Calculate QuickPay task to enter a reason for processing the task.


Parameter Detail

Value

Display

Yes

Display Format

Text

Lookup

blank

Usage

Input Parameter

Parameter Basis

Bind to Flow Parameter

Basis Value

Reason

After completing the task parameter information, you would add the Reason parameter as a flow parameter, so that the user completes the Reason when submitting the flow.

Adding Tasks and Reordering the Task Sequence

Your flow pattern includes payroll calculation reports. You decide that you need to run specific reports such as Gross-to-Net report before other reports such as the Element Register report and to validate the results of each report before the application runs the next report. You can rearrange the sequence of reporting tasks, add a manual verification task after each report, and rename the manual tasks to more clearly identify them, such as Verify Gross-to-Net Report and Verify Element Register Report.

Editing a Payroll Flow Pattern: Worked Example

This example demonstrates how to edit a QuickPay flow pattern that you have created so that a person whose role carries a specific level of authority reviews the prepayment results before the flow owner generates the payment.

The following table summarizes the key decisions for this scenario.


Decisions to Consider

In this Example

Which role should own the Verify Prepayments Result task?

Payroll Manager Operations

When does the task become overdue?

One day before the process date

Prerequisites

  1. Create a QuickPay flow pattern.
  2. Include the same tasks and flow parameters as the predefined QuickPay flow pattern.

Specifying a Task Owner

  1. In the Payroll Checklist work area, click the Manage Payroll Flow Patterns task from the task pane.
  2. On the Manage Payroll Flow Patterns page, search for the QuickPay flow pattern that you created.
  3. In the search results region, click the Edit icon on the row of your QuickPay flow pattern.
  4. On the Tasks tab, select the Verify Prepayment Results task, and click the Edit Task icon.
  5. On the Edit Task Details: Basic Information page, click Next.
  6. On the Edit Task Details: Owner and Checklist page, select a role or a user name.
  7. Click Next.
  8. On the Edit Task Details: Duration and Notifications page, in the Duration region, complete the fields, as shown in this table.

    Field

    Value

    Due Date

    Process Date

    Offset

    -1


  9. In the Notifications region, complete the fields, as shown in this table.

    Field

    Value

    Flow Task Start Notification

    Yes

    Overdue Notification

    Yes


  10. Click Submit to submit your changes, and to return to the Manage Payroll Flow Patterns page.
  11. On the Manage Payroll Flow Patterns page, click Submit.

FAQs for Manage Payroll Flow Patterns

Can I edit a locked flow pattern?

You cannot edit predefined single or composite flow patterns, but you can edit payroll flow patterns that you create. For example, if all your payrolls reference the same legislative data group, you could edit the legislative data group flow parameter for your payroll cycle flow, and select the Parameter Basis as Use Specified Value, the Display Format as text, and then enter the name of the legislative data group for the Basis Value.

Can I skip the flow parameters for a single-task payroll flow pattern?

No, you must specify the flow parameters required to successfully complete the task. You can also include optional parameters that the person submitting the flow enters, or that the application can derive from the information entered for the required parameters.

How can I rearrange tasks in a flow pattern?

Edit the task sequence by selecting a different task in the Following Task column. Every payroll flow pattern begins with a Start Flow task, which does not belong to an Activity or Task Group. The payroll flow concludes with the End Flow task, which is listed for the last task in the Following Tasks column.

The sequence in which you select the tasks for a flow pattern on the Create Flow Pattern: Basic Information page determines the order of the tasks displayed on the Task Sequence page. Edit this task list on the Task Sequence page by selecting a different following task for the task you want to reposition. Confirm the order of the tasks on the Review page before submitting the flow pattern.

What happens if I don't enter a task owner in a payroll flow pattern?

The person who submits the payroll flow becomes the payroll flow owner and the task owner. The person's security privileges determine whether the person can submit the payroll flow.

When do I enter a destination for a payroll flow task?

Enter a destination URL for a task when the task type is the application interface, such as the batch loader, or user interface, such as a page in the user interface where the task owner views process and report results.

Why did the payroll flow pattern duration dates not display?

The payroll flow pattern duration dates for the start and due dates are based on the flow parameter dates. Enter the flow parameters and then navigate back to the Tasks page to enter the duration dates and the offsets for those dates.

If your flow pattern does not specify dates as flow parameters, the duration list of values is blank.

Manage Payroll Process Configuration

Payroll Process Configuration Groups: Explained

Payroll process configuration groups provide sets of payroll action parameters, primarily related to logging and performance, for your processes and reports. When you run a process, you can select a process configuration group. If you do not select a process configuration group, the application uses the parameters in the default group.

You must specify the default group in the Process Configuration Group ACTION_PARAMETER_GROUPS profile option. You can set the profile option in the Setup and Maintenance work area using the Manage Default Process Configuration Group Profile Option Values task or the Manage Administrator Profile Values task.

Note

Entering a value for this profile option is a required step. The value of the Payroll License parameter in the process configuration group selected in the profile option determines the element templates used in the Manage Elements task and whether deduction cards are created automatically for new employees when you hire them.

A default process configuration group is predefined. You can edit the predefined group on the Default Group tab of the Manage Payroll Process Configuration page. You can select this group or another one as the default for your sites using the Process Configuration Group ACTION_PARAMETER_GROUPS profile option.

You can also create as many additional groups as you require on the Group Overrides tab on the Manage Process Configuration Group page. For example, you might want to create a group with the logging parameters turned on to troubleshoot processes. You can also specify different performance parameter values (such as chunk size and buffer size) for running different processes.

Payroll Process Configuration Group Parameters

Payroll action parameters are system-level parameters that control aspects of the payroll batch processes. The effects of setting values for specific parameters may be system wide. Payroll batch processes read values from the PAY_ACTION_PARAMETERS table on startup, or provide appropriate values by default, if specific parameter values are not specified.

For some parameters you should understand the concept of array processing and how this affects performance. Values for each parameter are predefined with the system, but you can override these values as part of your initial implementation and for performance tuning. Use the Manage Payroll Process Configuration task in the Setup and Maintenance work area.

The following table describes action parameters and lists values and predefined default values:


Parameter

Description

Values

Default Value

Balance Buffer Size

Used for array inserts and updates of latest balances, based on one row per balance.

Maximum: 1000. Minimum: 1.

Note

If your trace files show differences between execute and fetch timings, look at the buffer sizes you are using. Try setting each of these to 100.

500

Shuffle Chunk Processing

Random processing of order chunks for assignment actions.

Yes, No

No

Chunk Size

Number of payroll relationship actions processed together.

Maximum: 16000. Minimum: 1.

20

Cost Buffer Size

Used for array insert and select statements when calculating the costing of the payroll run results.

Maximum: 1000. Minimum: 1.

500

Element Entry Buffer Size

Buffer size used in the initial array selects of element entries, element entry values, run results, and run result values per assignment.

Maximum: 1000. Minimum: 1.

500

Formula Execution Logging

Code area where logging is performed.

The action parameter mechanism is only available for formula logging in the Payroll run. It is possible to perform logging with a combinations of characters. For example, the 'di' string corresponds to the logging of database item cache access and formula input and output values.

Note

The dump logging options should only be used in rare circumstances, especially the T trace option, which generates very large amounts of data that would significantly slow down processing.

d = database item cache access

D = database item cache dump

f = formula cache access

F = formula cache dump

i = formula input/output values

w = working storage area access

W = working storage area dump

n = nested calls

c = change contexts

s = SQL execution (database item and PLSQL formula function calls)

m = miscellaneous

T = trace (very large level that provides the inputs and outputs of every call made when executing a formula)

1 = level 1 (combination of i, m, f, and C)

2 = level 2 (combination of 1, d, w, c, and n)

3 = level 3 (combination of 2, D, W, and s)

4 = level 4 (combination of 3 and F)

5 = level 5 (combination of 4 and T)

No logging.

Logging Area

Area where code logging can be performed.

The values correspond to c-code entries in the form PY_ENTRY (env, pyipppr); where pyipppr is the functional area that will have logging enabled.

Note

If this isn't set, logging is not limited to a particular code area if logging is enabled by the Logging Category pay action parameter.

Assignment ID to End Logging

Assignment ID that ends logging.

 

All assignments

Assignment ID to Start Logging

Assignment ID that starts logging.

 

All assignments

Logging Category

Helps investigates problems with large volumes of detailed data.

GMPE or blank for no logging. You can specify multiple values.

No logging.

Maximum Number of Payroll Relationship Actions to Roll Back

Number of payroll relationship actions that can be rolled back, when rolling back a process.

Minimum: 1

50

Maximum Errors Allowed

Number of payroll relationship actions that can be rolled back, when rolling back a process.

Minimum: 0

CHUNK_SIZE or 20

Maximum Iterations Allowed per Run Action

Maximum number of iterations allowed per run action within Net to Gross calculations within the Payroll Run.

Minimum: 0

15

Notifications Expiration Offset

Number of days before a payroll flow notification is automatically deleted.

 

 

Payroll License

Provides features, such as element templates, appropriate to selected product license.

PAYROLL, HR_ONLY , and PAYROLL_INTERFACE.

HR_ONLY

Process Timeout

Number of minutes before the Run Balance Generation process times out.

Minimum: 0

If not specified, no timeout limit is enforced.

Remove Report Assignment Actions

Removes report processing actions after reports are generated.

Yes, No

Yes

Run Result Buffer Size

Used for array inserts and updates, based on 1 row for each payroll run result.

Maximum: 1000. Minimum: 1.

500

Override Location for Tax Libraries

Directory location for Quantum tax libraries.

There are no set values. Values for this parameter would be directory structures on the client site.

$VERTEX_TOP/lib

Accounting Date for Transfer to General Ledger

Date earned or date paid, used to transfer and post journal entries for costing results to Oracle Fusion General Ledger.

E = date earned

P = date paid

P

Reversal and Balance Adjustment Accounting Date

Accounting date based on the process date of reversal or balance adjustment or the process end date of the Transfer to Subledger Accounting task, which is used to transfer journal entries for costing results to Oracle Fusion General Ledger.

T = transfer using end date of the Transfer to Subledger Accounting task as the accounting date

P = use process date of the reversal or balance adjustment as the accounting date

P

Threads

Total number of subprocesses that can run from the Oracle Enterprise Scheduler Service.

Minimum: 1.

1

Wage Basis Rules Buffer Size

Used in array selects from the PAY_ TAXABILITY_RULES table within the Payroll Calculation process.

Minimum: 100

500

Trace

Enables the database trace facility for application processes written in C only.

Yes, No

No

Trace Level

Sets the trace level of the trace event. To generate the finest level of detail, enter the highest value.

1, 4, 8, 12

None

User Messaging

Enables detailed logging of user-readable information to the PAY_MESSAGE_LINES table.

Yes, No

No

Parallel Processing Parameters

THREADS

Oracle Fusion Global Payroll is designed to take advantage of multiprocessor machines. This means that you can improve performance of your batch processes by splitting the processing into a number of threads, or subprocesses, which run in parallel.

Note

Using threads and subprocesses may also improve performance if you are using PAYROLL_INTERFACE.

When you submit a batch process, the THREADS parameter determines the total number of subprocesses that run concurrently. The process submits THREADS minus 1 subprocesses.

Set this parameter to the value that provides optimal performance on your server. The default value of 1 is set for a single-processor machine. Benchmark tests on multiprocessor machines show that the optimal value is approximately 2 processes per processor. So, for example, if the server has 6 processors, you should set the initial value to 12 and test the impact on performance of variations on this value.

CHUNK_SIZE

Size of each commit unit for the batch process. This parameter determines the number of assignment actions that are inserted during the initial phase of processing and the number of assignment actions that are processed at one time during the main processing phase. Parameter values range from 1 to 16,000. The default value is 20.

Note

This does not apply to all processes, such as Generate Check Payments and Retroactive Pay.

During the initial phase of processing, this parameter defines the array size for insert. Large chunk size values are not desirable and the default value has been set as a result of benchmark tests. Each thread processes one chunk at a time.

Logging Parameters

During implementation and testing, you may need to turn on logging to provide a large volume of detailed information that is useful for investigating problems.

Use this parameter only when you need to investigate problems that are not easily identified in other ways. The logging activities can impact the overall performance of the process you are logging. Usually, this feature is needed during your initial implementation and testing before you go live. In a normal operation you should disable detailed logging.

Note

If you need to contact Oracle Support for assistance in identifying or resolving problems in running your payroll processes, you should prepare your log file first. Define the logging category, area, and range of assignments before resubmitting the problem.

LOGGING

Logging categories define the type of information included in the log. You can set any number of these categories by specifying multiple values so you can focus attention on specific areas that you think may be causing a problem. Parameter values are one or more logging categories, as described below. The default value is No logging.

The following table explains each logging category:


Parameter Value

Logging Category

Description

B

Balance Information.

Provides output information that shows the creation and maintenance of balances used during payroll processing.

C

C cache structures information.

Provides output information that shows details of the payroll cache structures and changes to the entries within the structure. While working on a service request, Oracle may ask you to use this parameter to gather additional information.

E

Element entry information.

Provides output information that shows the state of the element entries in the process memory after the entries have been retrieved from the database. The information is provided whenever data for an entry is changed during processing.

F

Formula information.

Provides output information that shows details of formula execution, including formula contexts, inputs, and outputs.

G

General logging information.

Provides general information, rather than a specific information type. This parameter does not provide sorted output. In general, it is recommended that you choose parameters that provide specific types of information.

I

Balance output information.

Provides output information that shows details of values written to the database from the balance buffers.

L

Balance fetching information.

Provides output information that shows the balances retrieved from the database and whether or not the process will use those balances. (If balances such as Year To Date totals have expired because the year has changed, the process resets them and uses the new balance.)

M

Entry or exit routing information.

Provides output information to show when any function is entered and exited. The system may display messages such as In: pyippee and Out: pyippee. This information is indented to show the call level, and can be used to trace the path taken through the code at the function call level. Often, this information is useful when attempting to track down a problem such as a core dump.

P

Performance information

Provides output information to show the number of times certain operations take place at the assignment and run levels and why the operation took place. This parameter is often used to balance the buffer array write operation.

Q

C cache query information.

Provides output information that shows the queries being performed on the payroll cache structures. While working on a service request, Oracle may ask you to use this parameter to gather additional information.

R

Run results information.

Provides output information that shows details of run results and run result values just as they are about to be written to the database from the Run Results buffer or the Values buffer. This enables verification that the buffer contents were correct.

S

C cache ending status information.

Provides output information that shows the state of the payroll cache before the process exits, whether that process ends with success or an error. While working on a service request, Oracle may ask you to use this parameter to gather additional information.

T and Z

PL/SQL detail and PL/SQL output.

To obtain detailed information about the PL/SQL calls made by the Payroll application, use the combination of the T parameter and the Z parameter. This combination is typically useful for obtaining information about payroll processes that use a large amount of PL/SQL code, such as prepayments and archive. The output from using these parameters is buffered while the process is running and is placed at the end of the log file after processing is complete. Each payroll process instance has its own log file, located under the log subdirectory for the particular process ID.

V (USA and Canada only)

Vertex tax calculation information.

Provides output information that shows the values being passed in and out of a third-party Vertex tax engine. This parameter also provides a separate file in the Out directory that shows the internal settings of the Vertex engine. This logging option is available to customers in the USA and Canada only.

Payroll License Configuration: Critical Choices

The Payroll License parameter on the Manage Payroll Process Configuration page has three allowable values that determine how payroll-related features function within Oracle Fusion Applications. You must ensure that the value for the Payroll License parameter in your default configuration group is appropriate for your licensing agreement.

The three allowable values for the Payroll License parameter for the following product licenses are:

Global Payroll

Global Payroll customers must set the Payroll License parameter to PAYROLL to ensure the complete set of payroll-related element templates is available when creating elements. These element templates assist in element creation and automatically create and generate fast formulas for new elements. Elements created without this set of element templates will not be suitable for costing or payment processing in Global Payroll.

The PAYROLL license setting also prevents any organization payment methods without a payment source from being associated when creating payroll definitions, which reduces potential problems during payment processing. For some localizations, the PAYROLL license setting enables deduction cards to be automatically generated as part of the new-hire process.

Global Payroll Interface

Global Payroll Interface customers must set the Payroll License parameter to PAYROLL_INTERFACE to ensure the correct set of element templates is available. Earnings elements created without this license setting will not automatically generate the associated features, such as the formulas and balances required when calculating gross earnings for employees.

Other HCM Products

Customers of other HCM products must set the Payroll License parameter to HR_ONLY to ensure the correct set of element templates is available. These element templates are simplified to facilitate creating elements to capture just the required information. Elements created without this license setting will include formulas and balances, which are required for payroll purposes but are unnecessary for HR purposes.

FAQs for Manage Payroll Process Configuration

How can I improve performance and troubleshoot payroll processes?

Add parameters to a payroll process configuration group to optimize performance and troubleshoot your payroll processes. To process large volumes of records, use the Threads and Chunk Size parameters. To troubleshoot processes, add the Logging Category or Formula Execution Logging parameters to a configuration group and rerun the process using that configuration group. Using these parameters enables you to investigate formula code problems.