Unable to perform wip over completion correctly using below script
INSERT
INTO wip_move_txn_interface
(
transaction_id ,
primary_item_id ,
organization_id ,
organization_code ,
process_phase ,
process_status ,
wip_entity_id ,
wip_entity_name ,
transaction_date ,
transaction_quantity ,
transaction_uom ,
transaction_type ,
fm_operation_seq_num ,
fm_intraoperation_step_type ,
to_operation_seq_num ,
to_intraoperation_step_type ,
created_by ,
created_by_name ,
creation_date ,
last_update_date ,
last_updated_by ,
last_update_login ,
last_updated_by_name,
OVERCOMPLETION_TRANSACTION_QTY,
OVERCOMPLETION_PRIMARY_QTY
)
VALUES
(
lv_transaction_id ,
i.primary_item_id ,
i.organization_id ,
i.organization_code,
lv_process_phase ,
lv_process_status ,
i.wip_entity_id, -- wip_entity_id