|
INSERT into bom_bill_of_mtls_interface
(assembly_item_id,
organization_id,
bill_sequence_id,
process_flag,
organization_code,
item_number,
assembly_type,
delete_group_name,
last_updated_by,
created_by,
transaction_type)
VALUES
(
11816,
204,
45042,
1,
'V1',
'MARK_BOM_T',
1,
'BILLS',
-1,
-1,
'DELETE')
/
INSERT into bom_inventory_comps_interface
(component_item_number,
last_updated_by,
created_by,
operation_seq_num,
effectivity_date,
transaction_type,
delete_group_name,
process_flag,
component_quantity,
assembly_item_number,
organization_code)
VALUES
('MARK_ONE',
-1,
-1 ,
'1',
sysdate,
'DELETE',
'Components',
1,
3,
'MARK_BOM_T',
'V1')
/
-- Load inventory components (children) of BOM
-- ISV_ITEM2C
INSERT into bom_inventory_comps_interface
(component_item_number,
last_updated_by,
created_by,
operation_seq_num,
effectivity_date,
bill_sequence_iD,
transaction_type,
delete_group_name,
process_flag,
component_quantity,
assembly_item_number,
organization_code)
VALUES
('MARK_TWO',
-1,
-1 ,
'1',
sysdate,
45042,
'DELETE',
'Components',
1,
3,
'MARK_BOM_T',
'V1')
/
这个时候执行在LOG里面会出现错误信息：
Entity: RC. Row Identifier: 6898. Entity index: 1.
You cannot update or delete component MARK_ONE since it does not exist for item MARK_BOM_T.
Entity: RC. Row Identifier: 6899. Entity index: 2.
You cannot update or delete component MARK_TWO since it does not exist for item MARK_BOM_T.
Entity: BO. Row Identifier: 6897. Entity index: 1.
An error occured while processing business object MARK_BOM_T in organization V1. Please check the data in this business object and re-run the import process.
|
