Update alternate resource by interface
Hi all,
I try to update rate or amount in alternate resource by interface.
the import done with success but the value doesn't update, I add information to bom_op_resources_interface and then run the import,
What is the required field to update alternate resource ?
Thanks,
Gil
insert into bom_op_resources_interface
(assembly_item_number,
organization_code ,operation_seq_num ,operation_sequence_id,
resource_seq_num,
resource_code ,schedule_seq_num,
effectivity_date , substitute_group_num,
usage_rate_or_amount_INVERSE,
process_flag ,
transaction_type)
select li.item_name,
li.organization_code,
bos1.operation_seq_num,
bso.operation_sequence_id,