How to Define Cross Validation Rules in Oracle | 11 Steps with images

By Jag - November 18, 2014

Flex field checks cross-validation rules whereas making an attempt to form a replacement combination of Flex field values (for example, a replacement Accounting Flex field combination).

Your cross-validation rules haven't any impact on Flex field mixtures that exist already. If you wish to disable associate degree existing combination, you need to disable that combination specifically victimisation the acceptable window. as an example, you'll be able to disable associate degree existing Accounting Flex field combination using the outline Accounting Flex field combinations window.

Suggestion: we tend to suggest that you just outline several rules that every have few rule components instead of many rules that every have several rule components. The a lot of rules you give, the a lot of specific you'll be able to build your error message text.

STEPS

N: Setup > Financials > Flexfield > Key > Segments Query Application as 

General Ledger and Flexfield Title as Accounting Flexfield

Query Structure as India Accounting Flex


Cross-Validate Segments























4.Click on Freeze Flexfield Definition
5. Enable Cross-Validate Segments
6. Enable Freeze Flexfield Definition then click on Compile button
7. A concurrent Program Flexfield View Generator is run by system
8. Find the request



N: View -> Request -> Find -> Refresh Data



Cross validation rules























Define the Cross validation rules

N: Setup > Financials > Flexfield > Key > Rules


10. Query your structure and enter the rules name, message and rules (Include and Exclude)

11. Create journal with excluded code combination then your get a error message defined in rules as below


Create journal with excluded code combination

  • Share:

You Might Also Like

1 comments