Overview of Loading Costing Cross-Validation Rules

Using HCM Data Loader, you can create costing cross-validation rules that define validation across segments. These rules enforce whether a value of a particular segment can be combined with specific values of other segments to form a new combination.

Define cross-validation rules for payroll costing key flexfield segments. After enabling the rules, use them to determine the valid cost account combinations that you can create during the costing process.

Example: Use validation rules to check if you can combine a particular segment value with values in other segments to form a new cost account combination. Also, you can use these rules to prevent any invalid combinations that go to General Ledger.

Components of a Cross Validation Rule

A cross-validation rule includes a condition filter and a validation filter. The application evaluates the rule using this logical order:

If the condition filter is satisfied, then apply the validation filter.

The condition filter describes the event when the application evaluates the rule. As this figure shows, depending upon the event, the application applies the validation filter and creates the combination.

  • If the event specified in the condition filter isn't applicable, then the application doesn't evaluate the rule even if it's enabled.

  • If the event specified in the condition filter is applicable, the validation filter condition must be applied before the application can create a combination.

If the event specified in the condition filter isn't applicable, then the application doesn't evaluate the rule even if it's enabled.

Example

Your organization has determined that a certain company value called Operations can't use a specific cost center called Marketing.

As this figure shows, you can define a cross-validation rule to validate your combinations.

  1. The rule evaluates the company Condition Filter.

  2. When company is equal to Operations, the rule evaluates the cost center validation filter.

  3. When cost center is equal to Marketing, the rule prevents a combination from being created.

Note: Such a rule doesn't affect the creation of combinations with Marketing cost center and company values other than Operations.

This table lists the various segment codes that you can use in your DAT files.

Segment Name

Segment Code

Company

COMPANY

Business Unit

Business Unit

Cost Center

COST_CENTER

Activity Code

ACTIVITY_CODE

Activity Code Charged

ACTIVITY_CODE_CHARGED

Location

LOCATION

Note: Use Segment Code in the DAT file while loading the data. For example, you should use "COST_CENTER" in the DAT file instead of "Cost Center". If the segment code has spaces in it, use it with double quotes. For example, you should use "Business Unit" while defining a rule using business unit segment.