How to define cross validation rules in oracle r12

How to define cross validation rules in oracle r12

Here we are going to discuss about Cross Validation rules in oracle r12. Cross Validation rules are related to the Chart of Accounts. These rules we apply on our chart of Account Structure. The purpose of this rule is more about security and control in the application. We put some restrictions in the  Char of Accounts or in the Accounting Key flex fields using this Cross Validation rules. Cross validation rules we creates in the General Ledger responsibility. These rules works for all Business units based on the Which Chart of Accounts we have applied this cross Validation rule. Here below I will try to explain and shows the steps to define cross validation rules in oracle r12.

 

 

Important Facts of Cross validation rules in oracle apps

1.These Rules only apply to the Char of Account or Key Flex Field Structure.

2.These Rules works Globally , We have no control to restrict these rolls on the basis of User , Responsibility and Business Units.

3.We uses the Cross validation rules to restrict the Key Flex fields segment values so that no user can use these values in the Account KFF during entering the Transactions.

4.The Cross Validations rules works for all the segments of the char of Accounts or KFF. We have no control to put the restrictions on specific segments of the char of Accounts or KFF.

 

Steps to define cross validation rules in oracle r12

Example :- I am using the one Example in this for better understanding. Suppose , We have one Chart of Accounts having 4 segments.

Step1:- For Example these below are my Char of Accounts Name and Available Values .

 

Segment1 == > BU ==> VALUES (00,12,14,15,ZZ)

Segment2 ==> Location ==> Values( 000,123,124,ZZZ)

Segment3==> Department==> Values (0000,2345,5678,ZZZZ)

Segment4==>Account==> Values(00000,34567,35678,45667,46788,89999,87766,ZZZZZ)

 

Step2:- Now I have requirement , I want to put Restrictions in the system that , If Any user Will select the BU with Value (15) is should not able to Use the Location Value (123) So this restriction we can implement with the Help of cross validation rules in oracle r12.

 

Step3:- We will Design the cross validation rules for this above Requirment as below.

 

INCLUDE : For BU ==>  00 TO ZZ (00 to ZZ means all the values available in the BU will be included)

For Location ==> 000 TO ZZZ (000 to ZZZ means all the values available in the Location will be included)

For Department==> 0000 TO ZZZZ (0000 to ZZZZ means all the values available in the Department will be included)

For Account ==> 00000 TO ZZZZZ (00000 to ZZZZZ means all the values available in the Account will be included)

 

Now to Put Restriction We will be create another Line With 'EXCLUDE'

 

EXCLUDE : For BU ==>  15 TO 15

For Location ==> 123 TO 123

For Department==> 0000 TO ZZZZ (0000 to ZZZZ means all the values available in the Department will be included)

For Account ==> 00000 TO ZZZZZ (00000 to ZZZZZ means all the values available in the Account will be included)