ITEM INTERFACE STEPS

ITEM INTERFACE

----------------------------

1.Create a Data File.

2.Create a Control File

3.Create a Stagging Tables

4.Move Data&Control File in gftp in This directory

/oracle2/VIS1211/apps/apps_st/appl/inv/12.0.0/bin

5.In Apps

Switch Responsibility->Application Developer->Concurrent->Executable

Executable :oit865

Short Name :oit865

Application :Inventory

Execution Method :SQL Loader

Execution File Name :oit865

Switch Responsibility->Application Developer->Concurrent->Program

Program :oit865

Short Name :oit865

Application :Inventory

Name :oit865

Switch Responsibility->System Administrator

Security->Responsibility->Request

Group :All Inclusive GUI

Application :Inventory

Give the Control File Name and save it.

Switch Responsibility->inventory,vision operations(USA)

View->Request->submit a new request

Name :oit865

click submit

Then the Program Will Compile and Run Normal.

Then the Data's are loaded into stagging table

Table Name:iteminterface

After Finishing the Stagging table move the table to interface table using PL/SQL Procedure.

Switch Responsibility->Application Developer->Concurrent->Executable

Executable :vimal_interface

Short Name :vimal_interface

Application :Inventory

Execution Method :PL/SQL Stored Procedure

Execution File Name :vimal_interface

Switch Responsibility->Application Developer->Concurrent->Program

Program :vimal_interface

Short Name :vimal_interface

Application :Inventory

Name :vimal_interface

Switch Responsibility->System Administrator

Security->Responsibility->Request

Group :All Inclusive GUI

Application :Inventory

Give the interface table name and save it.

Switch Responsibility->inventory,vision operations(USA)

view->request->submit a new request

Name :vimal_interface

click submit

Then the Program Will Compile and Run Normal.

Then the Data's are moved from stagging table to interface table.

Table Name:mtl_system_items_interface

Then we want to move from interface table to base table

Inventory Vision Operations->View->Request

Name :Import Items

click submit

Then the Program Will Compile and Run Normal.

mtl_system_items_interface

Then the Data's are moved from interface table to base table.

Table Name:select * from mtl_system_items_b order by creation_date desc;

mtl_system_items_interface