OPEN -ITEM INTERFACE

ITEM INTERFACE

1. Create a Staging table

create table xx_item_interface

(

segment1 varchar2(40),

transaction_type varchar2(10),

process_flag varchar2(1),

description varchar2(240),

organization_code varchar2(3))

2. Create a flat file or date file.

 

Save the file with “XX_ITEM_INTERFACE.csv” (using double quote to save).

3. Create Control file

LOAD DATA

INFILE '/oracle2/VIS1213/apps/apps_st/appl/inv/12.0.0/bin/XX_ITEM_INTERFACE.csv'

INSERT INTO TABLE XX_ITEM_INTERFACE

FIELDS TERMINATED BY ','

(

segment1,

transaction_type,

process_flag,

description,

organization_code)

>>Save the file with “XX_ITEM_INTERFACE.ctl” (using double quote to save).

4. Move both csv and ctl files to corresponding top bin directory using FTP.

(/oracle2/VIS1213/apps/apps_st/appl/inv/12.0.0/bin/)

5. Run sqlloder(control file) using telnet

user/password: oracle >> /oracle/D1/visappl >>. APPSORA.env >> cd

inv/11.5.0/bin >> sqlldr apps/apps control = xx_item_interface

6. Create Validation Procedure in load

CREATE OR REPLACE PROCEDURE XX_ITEM_PRC AS

CURSOR C IS SELECT * FROM XX_ITEM_INTERFACE;

BEGIN

FOR I IN C LOOP

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

(

SEGMENT1,

TRANSACTION_TYPE,

PROCESS_FLAG,

DESCRIPTION,

ORGANIZATION_CODE)

VALUES

(

I.SEGMENT1,

I.TRANSACTION_TYPE,

I.PROCESS_FLAG,

I.DESCRIPTION,

I.ORGANIZATION_CODE);

END LOOP;

END;

7. Go to apps Res. Inventory vision operations vision

>>Import items >> Ok

 

CLICK>>IMPORT ITEMS

 

 

Go to Master items and check our date is update in the frontend or not.

 

Then search by your item name, what you gave in csv file.if it show's your item name, then your data will be successfully loaded into the base table. 

 thank you.