0 Replies Latest reply on Aug 9, 2013 7:01 AM by user11655073

    How to restrict user to enter duplicate items in Purchase Order Lines?

    user11655073

      I have to do form personalization so that user cannot enter duplicate items in the PO.

       

      At when-new-item-instance in PO-Approve field, I have created a database function that is taking the count of items and returning the count value.

       

      In the condition I have given condition:

       

      1<(select func_name(parameter) from dual)

       

      10       message                 duplicate items in the po

       

      But its not working fine.

       

      Thanks & Regards

      Sunny