0 Replies Latest reply on Apr 27, 2017 1:09 PM by 1592120

    Form Personalization

    1592120

      Hi  All,

       

      I have requirement  like

       

      Whenever I create intra class unit of measure conversion against an item or update the existing conversion ,I need to eneque certain data into the oracle advance queue

      For this I have created  form personalization like  below.

       

      Trigger Name:WHEN-VALIDATE_RECORD

      Condition:-  :SYSTEM.RECORD_STATUS IN ('INSERT','CHANGED')

      Trigger Object:INTRA_CLASS_CONVERSIONS

      Processing Mode:- Both

       

      Level :User

      Action

      -------------

      Builtin type :execute Procedure

      Argument:calling below procedure and passing inventory item id value and inserting that value in to custom table for testing

      ='declare

      v_item_id number(30) ;

      begin

      erps_demo_forms_pers_prc('''||${item.INTRA_CLASS_CONVERSIONS.INVENTORY_ITEM_ID.value}||'''

      );

      end'

       

      When I'm creating new record (intra class uom conversion) the data is not inserting into custom table

      but when I'm updating the existing uom conversion its inserting one record into custom table.

      Could you Please let me what is wrong in my approach and which trigger I need to use to  execute a function when new Intra class conversion is created.