Use Extensible Fields to Include Additional Attributes

Use the configurable extensible fields to include additional attributes in your extract definition. You can include up to five additional attributes. 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, do 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
   Enter the lookup code as the Short Code of the attribute. If you need to have different fast formulas for different countries or interfaces, enter lookup code as the short code of the attribute with a unique prefix. For example: country	Valid rule formula name to populate the value for the attribute Extensible Field 1.	Enter a valid description. For example: This attribute is being extracted through this extensible field.
   Enter the lookup code as the Short Code of the attribute. If you need to have different fast formulas for different countries or interfaces, enter lookup code as the short code of the attribute with a unique prefix. For example: country	Valid rule formula name to populate the value for the attribute Extensible Field 2.	Enter a valid description.
   Enter the lookup code as the Short Code of the attribute. If you need to have different fast formulas for different countries or interfaces, enter lookup code as the short code of the attribute with a unique prefix. For example: country	Valid rule formula name to populate the value for the attribute Extensible Field 3.	Enter a valid description.
   Enter the lookup code as the Short Code of the attribute. If you need to have different fast formulas for different countries or interfaces, enter lookup code as the short code of the attribute with a unique prefix. For example: country	Valid rule formula name to populate the value for the attribute Extensible Field 4.	Enter a valid description.
   Enter the lookup code as the Short Code of the attribute. If you need to have different fast formulas for different countries or interfaces, enter lookup code as the short code of the attribute with a unique prefix. For example: country	Valid rule formula name to populate the value for the attribute Extensible Field 5.	Enter a valid description.

5. Click Save and Close.