Cross validation rules include exclude

Cross validation rules include exclude

In this post , We will we discuss about Cross validation rules in oracle apps and how we can implement these rules. Cross validation implementation rule works on the principle of Include and Exclude. We first include all the DFF segment values and then Exclude those Values of the KFF segments which we want to restrict to stop entering by business user. Here below is the complete working example of Cross validation rules include exclude.

 

 

Working Example of Cross validation rules include exclude.

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)