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:

      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.