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.
