1. Administering Oracle Payroll Interface
  2. Cost Center Override

Cost Center Override

The CostCenterDetails section in the ADP Global Payroll interface, reports cost centers and its description mapped to departments, which are associated with employee assignments.

Use the CostCenterOverride attribute under the Extensible Fields section in Assignment Data to support requirements where you want to use a cost center that,

  • Isn't mapped through departments

  • Captured in a different location

  • Logical combination of more than 1 attributes. For example, combination of project and cost center code

The CostCenterOverride attribute takes priority over the other cost center data values.

  • If you provide a CostCenterOverride attribute value in the output XML file, ADP directly uses this value as the cost center code to build the record on ADP Global Payroll application.

  • If you leave the CostCenterOverride attribute blank, ADP considers the cost center in the CostCenterDetails.

Calculate CostCenterOverride attribute through a custom fast formula. So you can build the fast formula according to the implementation requirements and return the final value of the computed cost center code to this attribute. Optionally, you can also send the override cost center description as a concatenation to the cost center code.

Configure a fast formula to define the value and description of the overriding cost center as a string delimited by ~|. Map this formula to the delivered CostCenterOverride attribute. For example,

CostCenterCode = 'Cost Center Code' /** Return the computed value of the cost center **/
CostCenterDesc = 'Cost Center Description'
l_computed_val = ' '
l_computed_val = CostCenterCode || '~|' || CostCenterDesc
RETURN l_computed_val
Note: If you're including the description, concatenate the string delimited by ~|. If you don't want to send the description, send only the cost center code without ~|.

Here's how you create the fast formula:

  1. On the Home page, click the Fast Formulas quick action under the My Client Groups tab to create a fast formula of type Extract Rule. This formula should return the logically determined override cost center value and description through a variable called l_computed_val. The variable returning the computed value should have the name l_computed_val. Ensure that the fast formula start date is sufficiently backdated, something like 1-Jan-1900.

  2. Compile the formula successfully.

Here's how you enable the override cost center functionality:

  1. In the Setup and Maintenance work area, go to the Manage Common Lookups task.

  2. Search for the lookup type ORA_HRY_EXTND_DATA_FORMULA_MAP.

  3. You can find lookup code ORA_HRY_ENABLE_EXTND_VALUES.

  4. Update the value for Meaning of this lookup code to Y.

Here's how you map the custom fast formula to the override attribute:

  1. If you're still using the same lookup type ORA_HRY_EXTND_DATA_FORMULA_MAP, create a lookup code as:

    Lookup Code

    Meaning

    Description

    ASG_EXTENDED_FIELD_5

    Provide the name of the custom fast formula that you created earlier

    Fast formula mapping for OverrideCostCenter attribute

  2. Save the settings.

Note:

  • If you have used a flexfield to capture the cost center, deploy the flexfield successfully and run the Generate Flexfield Database Items flow to generate the database items. You can use these generate database items in fast formulas to retrieve the cost center value.

Related Topics