Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center