Home » Applications » Oracle Fusion Apps & E-Business Suite » Inventory Open Item Interface
Inventory Open Item Interface [message #168413] Thu, 20 April 2006 04:54 Go to next message
Lachmi
Messages: 18
Registered: June 2004
Junior Member
Hi,

I am trying to learn the Inventory Open Item Interface utility to create New Items from flat file data available from Legacy System dumped into MTL_SYSTEM_ITEMS_INTERFACE using the Vision Demo setup. The Application User's Guide says it is advisable to populate the Segmentn Column rather then Item Number. I am unable to build up the Segment1 column data. The Category Assignment comes after Master Data is created. By giving random numbers to the items, the data import is failing, however no errors are being reported while running the Standard API Import Items. However, the data is not getting inserted into standard tables.

Can anyone please explain the concept/steps to build the Segment1 column (flexfield) data. What supporting tables must one look into for gathering the data.

Thanks in advance
Re: Inventory Open Item Interface [message #180357 is a reply to message #168413] Mon, 03 July 2006 04:25 Go to previous messageGo to next message
konka_kiran
Messages: 56
Registered: May 2006
Location: Bangalore
Member

Hai,

Have you checked the System Items Key-Felx-Field. This Key-Felx-Field, should be compiled and freezed first of all for the item-master creation, segmen1 population. This activity is required even you are not using the any combination to generate and form the item id.

Check out this, and let me know if you still have the problem.

Regards,
Kiran
Re: Inventory Open Item Interface [message #181430 is a reply to message #180357] Mon, 10 July 2006 02:01 Go to previous message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Hi,
Check the following in MTL_SYSTEMS_ITEM_INTERFACE

Process_flag = 1
Trasaction_type ='CREATE'
Set_process_id=any batch number

For a simple test try the following :

>insert into mtl_system_items_interface
(process_flag,set_process_id,transaction_type,organization_id,
segment1,description)
values
(1,1,'CREATE',<Vision Operations org id>,'TESTITEMIMPORT', 'Testing Item Import');
commit;

Run the item import using
set_process_id=1

Verify the result

Regards
Vinod


Previous Topic: Which price will be picked up?
Next Topic: DOCUMENTIONS
Goto Forum:
  


Current Time: Mon Dec 23 17:47:38 CST 2024