0 Replies Latest reply on Oct 9, 2015 2:56 AM by RanayMoore

    Form Personalization: make a form query only but make 1 Field Editable

    RanayMoore

      Hi All,

       

      I am changing form: INVIDITM for a specific responsibility to query only, but I need only 1 field on this form updatable.

       

      I have tried 2 methods, but they don't seem to be working.

       

      Method 1:

      Link the Menu to a query only/view only Function: INV_INVIDITM_ORG_V

      Personalize Form: INVIDITM/ Function: INV_INVIDITM_ORG_V as follows:

      Condition

      Trigger Event: WHEN-NEW-BLOCK-INSTANCE

      Trigger Object: MTL_SYSTEM_ITEMS_QF

      Responsibility: "Resp  Name"

      Action

      Item = MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY_MIR

      INSERT_ALLOWED = True

      UPDATE_ALLOWED = True

      ENTERABLE = True

       

      Method 2:

      Menu is updateable

      Personalize Form: INVIDITM/ Function: INV_INVIDITM_ORG  as follows

      1st make form query only(this works)

      Condition

      Trigger Event: WHEN-NEW-ITEM-INSTANCE

      Trigger Object: MTL_SYSTEM_ITEMS.INVENTORY_ITEM_MIR

      Responsibility: "Resp  Name"

      Actions

      Block= MTL_SYSTEM_ITEMS

      INSERT_ALLOWED = False

      UPDATE_ALLOWED = False

       

      2nd make the 1 field updatable( note you have to go to a TAB on the form to see this field)

      Condition

      Trigger Event: WHEN-NEW-ITEM-INSTANCE

      Trigger Object: MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY_MIR

      Responsibility: "Resp  Name"

      Actions

      Item = MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY_MIR

      INSERT_ALLOWED = True

      UPDATE_ALLOWED = True

      ENTERABLE = True

       

      this does not work either, I played around with the trigger objects to WHEN-NEW-BLOCK-INSTANCE and WHEN-NEW-RECORD-INSTANCE, but it still does not work.

       

      I am on Oracle 12.1.3

       

      Your advice will be appreciated.

      Thank you