Add Rules to Data Validation Reports

This example demonstrates how you can add a validation rule to the Data Validation Report extract definition.

Before you make changes to the extract, select a legislative data group. When you submit your changes for a new rule, the validation is available for the selected legislative data group. Depending on the validation rule and the legislative data group you add it to, the validation is included when you submit any or all of the following processes:

  • Payroll Data Validation Report for identifying missing payroll data needed for processes

  • Worker Validation Report for identifying missing HR data needed for processes

  • Data Validation Report for Payroll Interface for identifying missing HR or payroll data of persons associated with a given object group or payroll. The primary goal of the report in this case is to validate the data before it's exported by the Global Payroll Interface process to a third-party payroll provider.

Before you add the validation rule, ensure that a database item exists to retrieve the value to be validated. The contexts required by the database item are provided by the block level to which you add the validation. For example, suppose you're adding the new validation to the Person Details data group. You are adding a rule to check whether each person's Person Address Line 1 attribute has a value. If there is no value, the report displays an error message. A database item must exist for the person address line 1 attribute. Create the records and data elements in the appropriate data group based on the level at which you need the validation.

How to Create the Validation

To create a validation:

  1. In the Name field, enter Data Validation Report.

  2. Select Extract Definitions task from the Data Exchange area under My Client Groups.

  3. Search for and select the extract definition to edit as follows:

    1. In the Type list, select Full Profile.

    2. Select a legislative data group.

    3. Click Search.

    4. In the search results, click Data Validation Report.

  4. On the Extract Definitions page, click Switch Layout.

  5. In the Session Effective Date field, enter 01/01/0001.

  6. Add a new record to the Data Group to which you want to add validations as follows:

    1. Select Person Details under the Data Group node.

    2. In the Records section, click Create.

      Ensure that the Session Effective Date is 01/01/0001.

    3. Enter these details in the Create Extract Record section.

      Field

      Value

      Sequence

      Enter a unique value for the records within the Data Group. It is recommended to use a sequence number between 200 and 600.

      Note:

      Two records in the same Data Group can't use the same sequence number.

      Name

      Person Address Details

      Type

      Detail record

      Process Type

      Fast Formula

    4. Click Save.

  7. Add the database item attribute as follows.

    1. In the Extract Attributes section, click Create

    2. Complete the fields as shown in this table. This table lists the fields and the respective values for the extract attributes.

      Field

      Description

      Name

      Enter a suitable name, for example, Person Address Line 1 Attribute. This name is used in the validation message.

      Tag Name

      Person_Address_Line 1_Attribute

      Short Code

      Enter a suitable name to match the lookup code and remove the suffix, '>MC', for example, CST_PERSON_ADDRESS_LINE_1.

      Start Date

      01/01/0001

      End Date

      12/31/4712

      Data Type

      Enter a value appropriate to the data that you want to check. For example, Text for address details.

      Type

      Database item group

      Database Item Group

      Person Address Line 1

      Output Label

      Person Address Line 1

      Output Column

      6

      Note:

      If you don't find the Database Item Group that fetches the attribute value you want to validate, it could be that:

      • The Extract Attribute is added at an incorrect level (Data Group), or

      • The Database Item Group is unavailable. Verify the availability of the Database Item Groups by trying to add the extract attribute to other levels (Data Group). If the required Database Item Group is unavailable, you can contact Oracle Support.

      For more information, see Database Items for Extracts and Formulas in Oracle Fusion HCM guide on My Oracle Support (1565118.1).

    3. Click Save and Close.

  8. Create another attribute for the validation rule as follows:

    1. In the Extract Attributes section, click Create

    2. Complete the fields as shown in this table. This table lists the fields and the respective values for the validation rule.

      Field

      Value

      Name

      Person Address Line 1 Rule

      Tag Name

      RULE_TEXT

      Note:

      Enter this value exactly.

      Short Code

      CST_PERSON_ADDRESS_LINE_1>MC

      Note:

      The short code must include the short code of the database item attribute you created followed by a space and the suffix: >MC. The short code is case-sensitive.

      Start Date

      01/01/0001

      End Date

      12/31/4712

      Data Type

      Text

      Type

      Always set as Rule.

      Rule

      Global Attribute Mandatory Check

      Output Label

      Enter a value same as the Short Code, for example, CST_PERSON_ADDRESS_LINE_1-RULE.

      Output Column

      Enter a unique value within the record, 26.

      Results Display Option

      Summary and detail

    3. Click Save and Close.

  9. In the Actions menu, select Generate Formula.

  10. In the Actions menu, select Compile Formula.

  11. Click the Extract Execution Tree node and verify that all formulas are compiled.

  12. Click Submit.