Oracle Item Import Interface - SQL Loader scripts

Item has to be loaded into Oracle. We can import items into Oracle using item interface table mtl_system_items_interface.

Steps to load item into Oracle.

1. Populate interface table mtl_system_items_interface through SQL Loader(no biz validation) or plsql programs with validation

2. Run "Import Items" concurrent program under Inventory responsibility.

Sample Control File for a .csv data file:

 load data

 infile 'datafile.csv' "str '|\r\n'"

 insert/replace/append into table mtl_system_items_interface  

 fields terminated by "," optionally enclosed by '"'               

 trailing nullcols

 (          Process_Flag,

            Set_Process_Id,

            Transaction_Type,

            Organization_Id,

            inventory_item_id,

            segment1,

            description

)

"str '|\r\n'" - this will help in getting the last field of every record without carriage return or linefeed character on it.

Command to run SQL Loader:

1. Login to UNIX box and run this, sqlldr usr/pwd@instance_sid control_file.ctl log_file.log

2. The SQL loader can also be run from our local PC if Oracle client is installed and it can be verified by checking under oracle_home/bin. Also the oracle_home/bin should be set under environment variable, so that if we type the sqlldr command in windows prompt, it should get executed.