1. Administering Global Payroll
  2. Set Up a Lookup Code to Control the Rules for Data Validation Reports

Set Up a Lookup Code to Control the Rules for Data Validation Reports

Use the delivered ORA_HRX_GLB_VALIDATION_OBJECTS lookup type to set up a lookup code that you can use to control a validation for the Data Validation Report.

You can then use this lookup code to add multiple country tags to a validation. Alternately, you can remove a previously added country tag from the lookup code, if the validation is no more valid for the country.

Note:

If you don't tag a country, the application doesn't trigger any validation.

To create a lookup code:

  1. In the Setup and Maintenance area, select the HCM Extract Lookups task.

  2. Search for and select HCM Extract Lookups.

  3. Click Create.

  4. Enter these lookup code details.

    Field

    Description

    Lookup Code

    Enter a lookup code suitable for the attribute or entity to be validated. If you want to use the Oracle delivered formula for mandatory attribute validation, enter suffix as >MC n the lookup code, for example CST_PERSON_ADDRESS_LINE 1>MC.

    Display Sequence

    Enter a unique value for the lookup code. It is recommended to use a sequence number, between 201 to 500, for the user-defined lookup codes.

    Start Date

    Enter 01/01/0001.

    End Date

    Enter 12/31/4712.

    Meaning

    Enter a suitable meaning for the lookup code, for example, Person Address Line 1 Check.

    Description

    Enter a suitable description, for example, Person Address Line 1 Check.

    Tag

    Tag an appropriate country or countries, for which the validation is to be performed. For example, +FR.

    Note:

    If no Tag is set up, the application doesn't perform the validation for any country.

  5. Click Save.

Related Topics