Overview of Cross-Validation Rules in General Ledger

You can use cross-validation rules to determine the valid account combinations that can be dynamically created as users enter transactions or journal entries.

Once enabled, a cross-validation rule determines whether a selected value for a particular segment of an account combination can be combined with specific values in other segments to form a new account combination.

For example, your organization has determined that the company Operations can't use the Marketing cost center. You can define a cross-validation rule such that, if the company is Operations, then validate that the cost center isn't Marketing. New account combinations have to satisfy all of the cross-validation rules enabled for the chart of accounts before they can be created.

Entry and Maintenance

This table describes the different methods that you can use to enter and maintain cross-validation rules.

Method Navigation What You Can Do
Manage Cross-Validations page, Rules tab In the Setup and Maintenance work area, use the Manage Cross-Validation Rules task in the Financial Reporting Structures functional area.
Note: As an alternative navigation, select the Manage Cross-Validation Rules action on the Manage Chart of Accounts Configuration page.
  • Create
  • Edit
  • View
  • Upload to the interface table
  • Download from the interface table
  • Import from the interface table into the application
  • Download from the application
  • Submit the Manage Account Combination Validation Rules process
Cross-Validation Rules Import file-based data import (FBDI) Access the FBDI template from either of these locations:
  1. In the Oracle Help Center (https://docs.oracle.com), open the Oracle Fusion Cloud Financials File-Based Data Import (FBDI) for Financials guide.
  2. In the Setup and Maintenance work area, use the Manage Cross-Validation Rules task in the Financial Reporting Structures work area.
Create and edit large volumes of cross-validation rules
Create Cross-Validation Rules desktop-integrated spreadsheet In the Setup and Maintenance work area, use the Create Cross Validation Rules in Spreadsheet task in the General Ledger functional area. Create a large volume of cross-validation rules.

To edit error messages for cross-validation rules, use this task in the Setup and Maintenance work area:

  • Offering: Financials

  • Functional Area: Financial Reporting Structures

  • Task: Manage Messages for General Ledger

Tip: When you export or import cross-validation rules to a new instance using an export or import project in the Functional Setup Manager, you must add the Manage Messages for General Ledger task before the Manage Cross-Validation Rules task. You must export or import the messages before exporting or importing the cross-validation rules.

Existing Account Combinations

If existing account combinations violate newly enabled cross-validation rules, those account combinations continue to be valid. Before you disable existing account combinations that violate your rules and that you no longer use, move the balances in those accounts to the correct accounts. Then disable the account combinations to prevent further posting. Best practice is to define and enable cross-validation rules before account combinations are created, transactions or journal entries are imported or entered, and balances are loaded.