Inventory item id in interface table

[Guest_imported]

Hi,
I want to insert a new record in the MTL_SYSTEM_ITEMS_INTERFACE table with the inventory item id because I need the inventory item id later in my PL/SQL program to update other interface tables.
But if I insert a record with inventory item id, it fails when I try to import. Is there any way where I can get the inventory item id of a new item before running import so that I can use it for other purposes.

Appreciate any help....this is urgent....

Thanks in advance,
Manish.

 

[vikramkalsi]

Hi Manish,
Whenever you insert into tables,esp INTERFACE tables, sequences are used to generate the Primary Keys(item_id in this case). MTL_SYSTEM_ITEMS_INTERFACE_S should be sequence used for MTL_SYSTEM_ITEMS_INTERFACE (Please confirm this first). So now when you insert into MTL_SYSTEM_ITEMS_INTERFACE table, you can generate the item_id from the sequence first and use it any where you like.
But, when you import data from the Interface table into the Main Table, again some other sequence will be used for generating the item_id for the Main Table.

This is how Oracle Apps usually works.

Hope this helps you to figure out the solution for your problem.