4 Replies Latest reply on Nov 4, 2016 7:59 AM by SoundariyaKumar

    Forms personalization Require_property not working

    SoundariyaKumar

      Hi All,

      In Sales order organizer form i have a written a forms personalization to make Item_revision field as mandatory, but it is not working.

      In case of return lines when user clicks the reference field immediately item_revision field should be set to required.

       

      When i click the reference field item_revision field turns yellow in color as expected but even without entering any value i am able to go to next line and even book the order.

       

      Please suggest.

       

      Regards,

      Kumar.R

        • 1. Re: Forms personalization Require_property not working
          Srini Chavali-Oracle

          Pl post screenshots of your personalization setup. Have you reviewed MOS Doc 1266606.1 ?

          • 2. Re: Forms personalization Require_property not working
            SoundariyaKumar

            Hi Srini,

                 Here are the screenshots

             

             

            Please suggest.

            Regards,

            Kumar.R

            • 3. Re: Forms personalization Require_property not working
              PamNL

              The best thing to debug is to enable Help, Diagnostics, Custom Code, Show Custom Events. This will show you which events fire and when. In your case your personalization fires when you click in the RETURN_DF field and when  the return line type has a specific value. Since you mention the field becomes yellow and thus required it seems this fires well.

              Now the question is whether something else fires after that which makes the field either not required or the ITEM_REVISION field is not a database field perhaps so the system does not perform the check (although I think it should).

              It could be because the _DF field is quite a special field right (It's the flex field indicator). You could also add a WHEN-VALIDATE-RECORD trigger and simply check if ITEM_REVISION is null and if so display a message (with type error so you cannot continue).

              • 4. Re: Forms personalization Require_property not working
                SoundariyaKumar

                Hi all,

                     OK let me tell our exact issue what we are having.

                when our user enters a return line and enters a quantity say 5 and then chooses the return reference sales order number, now oracle overwrites the user entered quantity 5 with sales order quantity say 100.

                since there is no when validate item trigger in forms personalization.

                i am storing the user entered quantity in a global variable and written when item instance trigger on

                all the item fields on the form for reassigning the user entered quantity.

                i have written reassigning the user quantity in when validate record trigger also.

                all this is working fine for most of the cases.

                 

                Here is the case when it is not working.

                 

                User enters the return line and sales order reference and without clicking any of the item field directly clicks book order button.

                now the form re queries at the line level and overwrites the user entered quantity 5 with sales order quantity say 100.

                 

                this is happening because i cannot put DO_KEY COMMIT_FORM in the when validate record trigger, hence the qty 5 is not saved.

                 

                Please suggest.

                 

                Regards,

                Kumar