How can I disable accounts without affecting account inquiry?
I wish to establish cross validation rules to prevent certain combinations from being used together. There are some violations of the rules on the GL combinations table, which I need to disable before the rule will work. The issue I encounter is that when I disable the combination, the historical balances and transactions are no longer available for inquiry on the Account Analysis and Drilldown form. That form is looking for only valid combinations, which disqualifies my disabled combinations.
I've tried to just end-date the combination (instead of disabling) but it still doesn't appear on the Account Analysis form.
If I leave it enabled and just remove Posting and Budgeting rights to prevent further use of the combination, it does show up in the Account Analysis & Drilldown form. But because it's enabled, I don't think my cross validation rules will prevent future violations. The Oracle Guides state you need to disable violations of the rule before enabling the rule for it to work. I suppose I could just always take this same action on each combination that we don't wish to see in the GL (remove posting and budgeting) after the transactions are corrected but that seems to