Cross Validation Rule (CVR) - EBS GL R12

Cross Validation Rule is very unique functionality that accountant used in Oracle to control the data entry of business financial transactions as Journal Voucher in chart of accounts. The basic purpose of applying such rule is to have accurate and actual financial position of the company. This validation rules applies at 2 or more than 2 segments of chart of Accounts

Definition

“Cross Validation Rule is used to restrict the combination of segments that only used for particular Chart of Accounts”

Scenario:

In your business, your management, expect you as expert Functional Consultant, to apply following restriction through Cross Validation Rule

1. User could not enter expense entry without using cost center (Department)
2. Assets Can booked with Cost Center (Department) rather it should booked based on your  Units Segment 

Chart of Accounts Structure:

Segments in used for Scenario:

• Company
• Units
• Cost Center
• Accounts

Overview of Account Segment

Accounts Segment Range Start:

Accounts Value	Accounts Name
1000	Equity
2000	Asset
3000	Liability
4000	Revenue
5000	Expense

 Configuration Steps:

Step 1

Find chart of Accounts

Responsibility:“System Administrator” or “GL Superuser”

Navigation -> Setup -> Financials -> Flex fields -> Key -> Segments

Select COA and uncheck “Freeze Flexfield Definition”

Step 2:

Enable Cross validation rule

Check by Click “Cross-Validate Segments”

Check by Click at “Freeze Flexfield Definitions

Click Button “Compile”

Step 3

Navigation -> Setup -> Financials -> Flex fields -> Key -> Rules

Find Application “General Ledger” and Structure” B8 ICI Chart of Account”

Step 4

Cross Validation Rule Name = “CC to ACA”

Step 5

Error Message prompts:

Error Segment:

Step 6

Designing Cross Validation Rule in “Cross-Validation Rule Elements” section. In our Scenario we have to design two exclusion and two inclusions with following:

	Center Value	Accounts	Detail
Exclude 1	00000	5000	Requirement 1: Exclude all Expenses (5000 to with "00000" Combination
Exclude 2	Other than 00000	Other than 5000	Requirement 2: Select all Cost Center except "00000" and select all Accounts except Expenses
Include 1	Other than 00000	5000	Select all Cost Center except "00000" and select only Expenses Accounts
Include 2	00000	Other than 5000	Select "00000" Cost Center and select all accounts except Expenses

Cost Centers are

Accounts Are:

Step 7

Exclude 1:

Step 8

Exclude 2:

Step 9

Include 1:

Step 10

Include 2:

Step 12

Verification of Cross Validation Rule

Enter Journal

System Prompt error whenever User enter Expense with CC "00000" combination 

System Prompt error whenever User enter Asset with any Cost center combination