1. Administering Oracle Payroll Interface
  2. Use Extensible Fields to Include Additional Attributes for Ascender

Use Extensible Fields to Include Additional Attributes for Ascender

Use the configurable extensible fields to include additional attributes in your extract definition. You can configure fast formulas to determine the values for these attributes and map these formulas to the extensible fields.

To use the configurable extensible fields, perform these actions:

  1. Create a rule formula of type Extract Rule for each extensible attribute that you want to extract.

  2. Map the rule formula to the extensible attributes using the delivered lookup type ORA_HRY_EXTND_DATA_FORMULA_MAP.

Create Fast Formula

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.

Map the Rule Formula to the Lookup Type

Do these steps to map the rule formula to the lookup type:

  1. In Setup and Maintenance, search for and select the Manage Common Lookups task.

  2. On the Manage Common Lookups page, in the Lookup Type field, enter ORA_HRY_EXTND_DATA_FORMULA_MAP and click Search.

  3. In the ORA_HRY_EXTND_DATA_FORMULA_MAP: Lookup Codes section, for the ORA_HRY_ENABLE_EXTND_VALUES lookup code, enter Y in the Meaning field to enable this feature.

  4. In the ORA_HRY_EXTND_DATA_FORMULA_MAP: Lookup Codes section, add these lookup codes:

    Lookup Code

    Meaning

    Description

    ASG_EXTENDED_FIELD_1

    Fast formula mapping for Employment Status.
      • The default mapping for this field is the Global Payroll Interface concatenated values:

      JobDetails > Assignment Category

      JobDetails > HourlyOrSalary
    • Include other values as required with a maximum length value of 50 characters
    Note: ExtensibleField 1 takes a higher precedence. If ExtensibleField 1 is empty then Assignment Category & HourlyOrSalary is used.

    ASG_EXTENDED_FIELD_2

    Fast formula mapping for Oncost Pattern.
      • The default mapping for this field is the Global Payroll Interface value JobDetails > LocationCode
      • Include other values as required with a maximum length value of 50 characters
    Note: ExtensibleField2 takes a higher precedence. If ExtensibleField 2 is empty then LocationCode is used.

    ASG_EXTENDED_FIELD_3

    Fast formula mapping for CostCenterOverride
    • Create custom entry fields in Oracle HCM to capture this information. Use these fields to report upto 5 iterations of:
      • GL account >cost center codes (upto 50 characters)
      • Percentage Allocation: a percentage value up to 4 decimal digits, maximum value 100
    • The combined entry/entries must sum up to 100%

    • The Extensible field mapping for these values will use the following format <Account>:<percentage>|<Account>:<percentage>

      For example: 901122:60|904433:40

  5. Click Save and Close.

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.