OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Inventory Open Item Interface

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inventory Open Item Interface [message #168413]

Thu, 20 April 2006 04:54

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

Report message to a moderator

Re: Inventory Open Item Interface [message #180357 is a reply to message #168413]

Mon, 03 July 2006 04:25

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

Report message to a moderator

Re: Inventory Open Item Interface [message #181430 is a reply to message #180357]

Mon, 10 July 2006 02:01

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 04:28:33 CDT 2024