In this Document

APPLIES TO:

GOAL

What does the "Sync items" option for item import do?

When running the Import Items program, the last parameter has a prompt "Create or Update Items"
1 is create, 2 is update, 3 is "Sync Items". What does option 3 mean?

SOLUTION

You can use the ‘SYNC‘ transaction type to create the item, if the item does not exist, OR update the item, if the item exists.

Example
Created the item . since it did not exist
insert into mtl_system_items_interface
(process_flag, set_process_id, transaction_type,organization_id,segment1, description,template_name)
values
(1,1,‘SYNC‘,204,‘sync_item‘, ‘Testing through the interface‘,‘Finished Good‘);

Update the Transactable flag since the item already existed .

insert into mtl_system_items_interface
(process_flag, set_process_id, transaction_type,organization_id,segment1,description,MTL_TRANSACTIONS_ENABLED_FLAG)
values
(1,1,‘SYNC‘,204,‘sync_item‘, ‘Testing through the interface ‘,‘N‘);

NOTE:  In Oracle Inventory, Item import does not process records with
       transaction type ‘SYNC‘ when import is run with null process set.

       When using SYNC, always populate the process set in the Import Items parameters.

       This issue is fixed in incoin.opp 120.1

Item Import: What Does "Sync" Items Do? (Doc ID 417887.1)