Oracle E-Business Suite contains two reports you can use to help maintain a consistent and logical set of rules and key flexfield combinations. The two new flexfield cross-validation reports appear in the System Administration responsibility.
This report (short name FNDRXR) provides a listing of all the previously-created flexfield combinations that violate your cross-validation rules for a given flexfield structure.
You can check for existing combinations that violate any of the cross-validation rules set up for a given structure. Alternatively, you can run this report for just one cross-validation rule at a time, to test to see if the specific rule is set up correctly by seeing which existing combinations violate that rule.
The report can be run for a range of cross-validation rules as well. Suppose there are 5 cross- validation rules regarding a structure. The report can be run for a range of 3 rules out of the 5.
You have the option to specify whether to include combinations that have an end date in the past, and therefore "inactive," or to include only "active" combinations. End-dated (inactive) combinations are considered to be those with an end date in the past or a start date in the future.
You can choose to show non-summary combinations. You can also choose to have the report program disable the existing non-summary combinations that violate your rules.
Alternatively, you can have the report show summary combinations. You have the option to have the report program disable the existing summary combinations that violate your rules. For example, you can use this report to disable (close) summary accounts by entering 'Yes' for Disable Summary Combinations.
Note that this report does not include combinations that violate a rule and are disabled.
Finally, if you are experiencing poor performance running the "Cross-Validation Rule Violation Report", then improved performance can be achieved running the "Cross-Validation Rule Violation Report/Parallel" (short name FNDRXRP). For this program to achieve its full potential, you must have a true parallel processing system.
Note: You might have to work with a support representative to set up a tier with concurrent managers across multiple nodes, which would be used with multiple CPUs to increase processing speed.
This report lists all the cross-validation rules that exist for a particular flexfield structure. This is the information you define using the Define Cross-Validation Rules form, presented in a multiple-rule format you can review and keep for your records.