 |
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”
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
business, your management, expect you as expert Functional Consultant, to apply
following restriction through Cross Validation Rule
- User could not enter expense entry without using
cost center (Department) - 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
Account Segment
Accounts Segment Range Start:
Accounts Value | Accounts Name |
1000 | Equity |
2000 | Asset |
3000 | Liability |
4000 | Revenue |
5000 | Expense |
Step 1
Find
chart of Accounts
chart of Accounts
Responsibility:“System Administrator” or “GL Superuser”
Navigation -> Setup -> Financials -> Flex
fields -> Key -> Segments
fields -> Key -> Segments
Select COA and uncheck “Freeze Flexfield Definition”
Step 2:
Enable Cross
validation rule
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
fields -> Key -> Rules
Find Application
“General Ledger” and Structure” B8 ICI Chart of Account”
“General Ledger” and Structure” B8 ICI Chart of Account”
Step 4
Cross
Validation Rule Name = “CC to ACA”
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:
“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
 |