1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Validation rule returns false even if true

Discussion in 'Oracle Apps Technical' started by John DOENER, Sep 26, 2016.

  1. John DOENER

    John DOENER Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    PARIS
    Hi guys.

    Sorry if this is the wrong place to ask, but I'm writing this validation rule in Oracle Sales Cloud 11 on the account object (field : Address Line 1), and it always returns false even if true, I don't get it. I've tried several formulations, but the issue remains, thanks a lot for your help.

    if (PrimaryAddressLine1 ==null) {
    return false
    }
    else {return true}
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    What language are you using? As it's not evident, one usually uses IS NULL to check for NULL.
     
  3. John DOENER

    John DOENER Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    PARIS

    Attached Files:

    • err.JPG
      err.JPG
      File size:
      62.1 KB
      Views:
      1
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  5. John DOENER

    John DOENER Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    PARIS
    Thanks DTSIGuy, i've tried everything on that link already, without success unfortunately.

    I think there's a limit with validation rules when it comes to address standard fields.

    Thanks anyways ;)

    Cheers
     
  6. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    If that's the case, what if you copy the field contents to declared variables and then tested the latter? I also check the Oracle Forum and found this:

    https://community.oracle.com/message/9519028#9519028

    You could also check for != null...have you tried that? Short of that, you may have to visit MOS and maybe open an SR.

    ...sigh