General Technical Discussions for Service

Get Involved. Join the Conversation.

Topic

    Amy Chan
    Add logic validation on standard field in cloud.Answered
    Topic posted March 14, 2019 by Amy ChanSilver Medal: 2,000+ Points 
    113 Views, 3 Comments
    Title:
    Add logic validation on standard field in cloud.
    Summary:
    Add logic validation on standard field in cloud.
    Content:

    Is it possible to add logic validation on standard field in cloud? For example: when user submits Purchase Order for approval, one of the DFF value requires start with "ABC", otherwise a message return.

    Please share.

    Best Comment

    Sebastiaan Draaisma

    Hi Amy.

    Do you mean a message for the agent within the agent desktop or a message on the customer portal, or maybe in reporting?

    All of these are possible. If the message has to be a popup message for the agent handeling the case this would have to be done through a workspace rule. If its on the customer portal it will have to be done through javascript and if it's in a report a simple IF statement would do the trick.

    Reports

    if(incidents.c$customfield LIKE 'ABC%','Starts with ABC','ELSE')

    Javascript example

    <script>
            document.getElementById("rn_TextInput_11_Incident.Subject").onchange = function() {myFunction()};
            </script>

    <script>
    function myFunction() {
        var x = document.getElementsByName("Contact.Emails.PRIMARY.Address")[0].value;
    if (x == "anonymous@customer.com") {
        document.getElementById("Message").innerHTML = "Don't forget to state an email address if you would like an answer from us";
    }
        
    }
    </script>

    Workspace rule

    Comment

     

    • Sebastiaan Draaisma

      Hi Amy.

      Do you mean a message for the agent within the agent desktop or a message on the customer portal, or maybe in reporting?

      All of these are possible. If the message has to be a popup message for the agent handeling the case this would have to be done through a workspace rule. If its on the customer portal it will have to be done through javascript and if it's in a report a simple IF statement would do the trick.

      Reports

      if(incidents.c$customfield LIKE 'ABC%','Starts with ABC','ELSE')

      Javascript example

      <script>
              document.getElementById("rn_TextInput_11_Incident.Subject").onchange = function() {myFunction()};
              </script>

      <script>
      function myFunction() {
          var x = document.getElementsByName("Contact.Emails.PRIMARY.Address")[0].value;
      if (x == "anonymous@customer.com") {
          document.getElementById("Message").innerHTML = "Don't forget to state an email address if you would like an answer from us";
      }
          
      }
      </script>

      Workspace rule

      • Amy Chan

        Hi,

        We are using Oracle Financial module in cloud basis. We would like to add logic validation on standard field in cloud.

        Please see my screen print and show me the workspace rule location.

        Many thanks.

    • Sebastiaan Draaisma

      Hi Amy.

      Thanks for the update and document. I'm afraid you placed your topic in the wrong forum. This is the Oracle Service Cloud forum (a different product). Your forum may be one of these forums:

      Welcome to the Procurement Discussion Forums!

      These forums are intended for Oracle Procurement Cloud customers and partners to network and collaborate on real-life challenges, solutions and best practices.

      Welcome to the Financials Discussion Forums!

      These forums are intended for Oracle Financials Cloud customers and partners to network and collaborate on real-life challenges, solutions and best practices.

      Please create your topic in the the correct forum and mark this one as solved as people in this forum are unable to help you as we are specialized in a different product.