General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Beth Bleijie
    When do Cross Validation Rules not apply?
    Topic posted April 16, 2019 by Beth BleijieBronze Trophy: 5,000+ Points, tagged Cash Management, Configuration, Financials, General Ledger, Payables, Receivables, Setup / Administration 
    98 Views, 3 Comments
    Title:
    When do Cross Validation Rules not apply?
    Summary:
    Under what conditions do CVRs not apply?
    Content:

    I have set up a network of Cross Validation Rules, but there seems to be times when they just don't get applied, and other times when they do.

    Under what conditions do CVRs not get applied?  And is there anyway to overcome that?

    Some entries post incorrectly because the CVRs are not applied, and then they have to be journaled to correct them, but the journal runs up against the CVRs so I have to turn off the CVRs, post my correcting journal, then turn them back on again.

    So why are they not applied for every entry?

    Beth

     

    Comment

     

    • Rohan Kamat

      Hi Beth

      You may check the below

      1. If the invalid code combination is already created which is violating the CVR , you may need to disable them from Manage Account combinations . Further Oracle has a utility to find out the code combinations already formed , which are violating an CVR which was setup post their creation .

      2. If you are using hierarchies , ensure that the hierarchies are not in DRAFT mode . They are audited and published

      Thanks

      Rohan

      • Beth Bleijie

        Thank you Rohan,

        I'm not sure I fully understand point 1.  The CVRs were created, then subsequent transactions which violate the CVRs still post to the ledger.  I am not 100% sure, but I believe in most, if not all cases, the transaction which is posting in violation of the CVR is system generated, where as journal entries (manual or imported via spreadsheet) always get stopped by the CVRs

        When we edit hierarchies we always flatten, audit, and publish them immediately, so I am pretty sure that is not the problem, but I'll keep an eye on that possibility.  This kind of editing does not take place very often.

        Beth

        • Vikash Sethi

          Hi Beth,

          Point 1 is that if there is already a code combination which violates the CV rule, the system will allow it to work (even though you have created the rule & does not allow it). You need go and fix it by running the program (see pic).

          Vikash