Cross-Validation Rule(CVR) Oracle apps R12

By Jag - April 16, 2014
Cross-validation controls the combinations of values you can create when you enter values for key flexfields. A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments. Cross-validation is different from segment validation(Security Rule), which controls the values you can enter for a particular segment.
Cross-validation rules have no effect on combinations that already exist when you define your cross-validation rules.Suppose you define a new cross-validation rule, but have existing entries in your combinations table that violate the rule. Since the existing combinations pre-date the rule, your flexfield continues to treat them as valid.When user tries to create a new combination that violates your new rule, your flexfield returns an error message and rejects the combination.
1. Navigate to General Ledger Super User->Setup->Financials->Flexfields->Key->Segments
2. Enter the Application,Flexfield title and flexfield code.Ensure Cross-Validate segments option is checked.
3. Navigate to General Ledger Super User->Setup->Financials->Flexfields->Key->Rules
4. Enter the Application,Flexfield title and flexfield code.Then enter the Cross-Validation Rule name,Error message and Error segment.Also Enter the Cross-Validation rule elements.
5. Navigate to General Ledger Super User->Setup->Accounts->Combination.The try combination entering a combination that violates the new rule,the error message will be displayed.
  • Share:

You Might Also Like

0 comments