Scribd
Upload
8 views1 page

IOI Template for Inventory Management

This document provides SQL statements to truncate and insert records into several inventory interface tables in preparation for an import items process. It truncates four tables, inserts a new record into the MTL_SYSTEM_ITEMS_INTERFACE table with sample values, and provides instructions to run the import items process while specifying parameters including not deleting processed rows and using a create/update flag and set process ID of 1.

Uploaded by

Ravi Kumar Reddy Kalikiri
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
8 views1 page

IOI Template for Inventory Management

This document provides SQL statements to truncate and insert records into several inventory interface tables in preparation for an import items process. It truncates four tables, inserts a new record into the MTL_SYSTEM_ITEMS_INTERFACE table with sample values, and provides instructions to run the import items process while specifying parameters including not deleting processed rows and using a create/update flag and set process ID of 1.

Uploaded by

Ravi Kumar Reddy Kalikiri
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Truncate the following tables:

TRUNCATE TABLE INV.MTL_SYSTEM_ITEMS_INTERFACE;


TRUNCATE TABLE INV.MTL_INTERFACE_ERRORS;
TRUNCATE TABLE INV.MTL_ITEM_REVISIONS_INTERFACE;
TRUNCATE TABLE INV.MTL_ITEM_CATEGORIES_INTERFACE;

commit;

Insert script:

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE


(ORGANIZATION_ID,
DESCRIPTION,
SEGMENT1,
PROCESS_FLAG,
TRANSACTION_TYPE,
SET_PROCESS_ID)
VALUES
(&Orgid,
'&Desc',
'&Seg1',
1,
'CREATE', --CREATE or UPDATE
1);

commit;

Run Import Items:


Navigate: Inventory > Items > Import > Import Items
Use parameters:
Delete Processed Rows = No
Create/Update = 1
Set Process ID = 1

You might also like