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.
Condition:- :SYSTEM.RECORD_STATUS IN ('INSERT','CHANGED')
Processing Mode:- Both
Builtin type :execute Procedure
Argument:calling below procedure and passing inventory item id value and inserting that value in to custom table for testing
v_item_id number(30) ;
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.