1. Implementing Enterprise Structures and General Ledger
  2. How Cross-Validation Rules Import Data Is Processed

How Cross-Validation Rules Import Data Is Processed

Use the Cross-Validation Rules Import file-based data import (FBDI) to create, update, delete, and import cross-validation rules. You can download a spreadsheet template to use to prepare your cross-validation rules data.

The template contains an instruction sheet to help guide you through the process of entering your information. You can download the template from either the File-Based Data Import (FBDI) for Financials guide or the application.

To download the template from the FBDI guide:

  1. In the Oracle Help Center (https://docs.oracle.com), open the File-Based Data Import (FBDI) for Financials guide.
  2. In the General Ledger chapter, click Cross-Validation Rules Import.
  3. In the File Links section, click the link to the Excel template.

To access the template from the application:

  1. In the Setup and Maintenance work area, go to the Manage Cross-Validation Rules task:
    1. Offering: Financials
    2. Functional Area: Financial Reporting Structures
    3. Task: Manage Cross-Validation Rules
  2. On the Manage Cross-Validations page Rules tab, search for your chart of accounts.
  3. In the Actions menu, click Download Rules.

Follow these guidelines when preparing your data in the worksheet:

  • Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.
  • Don't change the order of the columns in the template.
  • You can hide or skip the columns you don't use, but don't delete them.

You can always add, update, or delete the cross-validation rules for a chart of accounts. Incremental changes and replacement of cross-validation rules must be audited, so you must enable auditing to manage cross-validation rules when you use the FBDI template.

To enable auditing in the Setup and Maintenance work area, go to the Manage Audit Policies task:

  • Offering: Financials
  • Functional Area: Application Extensions
  • Configure Business Object Attributes for Product: Oracle Middleware Extensions for Applications
  • Object Name: Key Flexfield Cross Validation Rule

The Cross-Validation Rules Import template contains an instructions tab plus a tab that represents the table where the data is loaded:

Spreadsheet Tab Description
Instructions and CSV Generation Contains an overview of the template.
GL_CROSS_VALIDATION_RULES_INT Information about the cross-validation rules that you’re adding or updating, such as the cross-validation rule name, action, conditions, validation filters, and rule error message details.

This table describes each column on the GL_CROSS_VALIDATION_RULES_INT tab.

Column Description
Chart of Accounts Code The code for the chart of accounts, which you can find on the Manage Chart of Accounts Configurations page.
Action The action for the cross-validation rule. This field supports two values:
  1. INSERT: Adds a new rule or updates an existing rule for the specified cross-validation rule name.
  2. DELETE: Deletes the existing cross-validation rule.
Name The name of the cross-validation rule.
Description (Optional) The description for the cross-validation rule.
From Date (Optional) The start date for the cross-validation rule in YYYY/MM/DD format.
To Date (Optional) The end date for the cross-validation rule in YYYY/MM/DD format.
Enabled The indicator for whether the cross-validation rule is enabled. Supported values are Y and N.
Rule Error Message Error message text to explain why an attempted account combination violates the cross-validation rule.
Condition Filter Segment Code The segment code for the condition filter. If you need to enter multiple conditions for different segments in a cross-validation rule, then enter the condition segment codes in a new row.

If you enter the same cross-validation rule in multiple lines, ensure all the other column values for that rule name, such as Chart of Accounts Code, Action, Description, From Date, To Date, Enabled, and Rule Error Message have the same values.
Condition Filter Operator The operator for the condition filter segment code and values in the cross-validation rule. If you need to enter multiple operators for a condition filter segment code, enter the different operators in a new row.
Condition Filter Values The segment values for the condition filter segment code and operator. You can enter multiple segment values by separating each value with a semicolon (;). To indicate a range of segment values for the Between operator, use a hyphen (-) as the separator.
Validation Filter Segment Code The segment code for the validation filter. If you need to enter multiple conditions for different segments in a cross-validation rule, then enter the validation segment codes in a new row.

If you enter the same cross-validation rule in multiple rows, ensure all the other column values for that rule name, such as Chart of Accounts Code, Action, Description, From Date, To Date, Enabled, and Rule Error Message have the same values.
Validation Filter Operator The operator for the validation filter segment code and values in the cross-validation rule. If you need to enter multiple operators for a validation filter segment code, enter the different operators in a new row.
Validation Filter Values The segment values for the validation filter segment code and operator. You can enter multiple segment values by separating each value with a semicolon (;). To indicate a range of segment values for the Between operator, use a hyphen (-) as the separator.

After you prepare the data in the spreadsheet, click Validate to verify that the template doesn't have errors.

To load the data into the interface table:

  1. Click the Generate CSV File button on the Instructions and CSV Generation tab to create a CSV file in a .zip file format.
  2. You can save the CrossValidationRules.zip file to a local folder.
  3. In the Setup and Maintenance area, go to the Manage Cross-Validation Rules task:
    1. Offering: Financials
    2. Functional Area: Financial Reporting Structures
    3. Task: Manage Cross-Validation Rules
  4. On the Actions menu, select Upload Rules.
  5. In the Upload dialog box, select the file you saved in step 2 and click Submit to launch the Load Interface File for Import process.

    Here's an example of the Upload dialog box.

    An image of the Upload dialog box.
  6. If the process ends in error or warning:
    1. Review the log and output files for details about the rows that caused the failure.
    2. Correct the errors in the spreadsheet.
    3. Repeat steps 1 through 5 until the errors are resolved.
    Note: You can also load the data into the interface table from the Scheduled Processes work area. Submit the Load Interface File for Import process for the Manage Account Combination Validation Rules import process.

Optionally, review the unprocessed rows in the GL_CROSS_VALIDATION_RULES_INT table:

  1. In the Setup and Maintenance area, go to the Manage Cross-Validation Rules task:
    1. Offering: Financials
    2. Functional Area: Financial Reporting Structures
    3. Task: Manage Cross-Validation Rules
  2. On the Manage Cross-Validation Rules page, search for your chart of accounts.
  3. On the Actions menu, select Download Unprocessed Rules.

To load the data from the interface table into the application:

  1. In the Setup and Maintenance Area, go to the Manage Cross-Validation Rules task:
    1. Offering: Financials
    2. Functional Area: Financial Reporting Structures
    3. Task: Manage Cross-Validation Rules
  2. On the Actions menu, select Manage Rules.
  3. In the Validation Type field, select Cross-validation rules.
  4. In the Action field, select Import.
  5. In the Chart of Accounts field, select the applicable chart of accounts. The list of values displays the names of all charts of accounts in the interface table. If your import file contains data for more than one chart of account, then you can select All.
  6. Select the applicable mode:
    • Select Increment when you’re uploading changes to existing cross-validation rules.
    • Select Replace mode only when you’re completely replacing all of the existing cross-validation rules with all new cross-validation rules. This mode supports integrations that send a complete replacement file.
      Caution: Use the Replace mode carefully. If the file you’re loading contains a subset of cross-validation rules, all other existing cross-validation rules in the application will be deleted. The Replace mode:
      • Inserts the new cross-validation rules from the file.
      • Updates the existing cross-validation rules with the changes from the file.
      • Deletes all other existing cross-validation rules from the application that aren’t included in the file.

    Here's an example of the Manage Rules dialog box.

    An image of the Manage Rules dialog box.
  7. Click Submit.

    A process is launched for each chart of accounts name. For example, if you selected ALL for the Chart of Accounts parameter and the interface table contains cross-validation rules for both the Vision Corporation and Vision Operations charts of accounts, two processes will launch.

    The import process follows an All or Nothing approach while importing cross-validation rules for a chart of accounts. If there are any validation errors for one or more cross-validation rules, then none of the cross-validation rules for the chart of accounts will be imported. If there are no validation errors, then the process will import all the cross-validation rules for the chart of accounts.

    Note: The interface records for the processed cross-validation rules are automatically deleted at the end of the process.
  8. If the process ends in error or warning:
    1. Review the report output file for the errors. The output file is in a .csv format with all of the columns from the original .csv file plus an extra Error column at the end with the error details.
    2. Correct the records in the original spreadsheet. Reload the file into the interface table to process all of the cross-validation rules in the file and resubmit the process to load the data into the application.

Related Topics