Answer / manish sharma

After creation of Master Item, Revision and Category
Item Catalog interfaced with reference to item.

Item catalog is defined on Master level only, which is
applicable for all assigned organizations.

For Catalog Interface, MTL_DESC_ELEM_VAL_INTERFACE
interface table is used then interface the data to Base
Table MTL_DESCR_ELEMENT_VALES with reference to Master Item.

Columns for Catalog Interfacing are :

INVENTORY_ITEM_ID, ELEMENT_NAME, ELEMENT_VALUE, REQUEST_ID,
PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
DEFAULT_ELEMENT_FLAG, ELEMENT_SEQUENCE, TRANSACTION_ID,
PROCESS_FLAG, ITEM_NUMBER, SET_PROCESS_ID including Who
columns.

Mandatory column is Set_Process_Id as per oracle standard.

The other Required columns are :
ELEMENT_NAME, ELEMENT_VALUE, , ELEMENT_SEQUENCE,
DEFAULT_ELEMENT_FLAG, PROCESS_FLAG,
ITEM_NUMBER ,INVENTORY_ITEM_ID.

Once data is populated in interface table then it moves in
Base table through API INVPPRCI.

Answer / guest

REFER Item Import open interface in mfgapi user guide

I have an Inv Org which is having 5 Stores. Each store is having an Individual Store Operator and is created as a User in Apps. Now, How can I restrict this Operator to his particular Store?

3 Answers  

---

If customer is makes advance payment against to any SO, how to apply the amount while raising sales order in SO Form?

1 Answers   Accenture, CSS Corp,

---

How many item category flexifields you can have for an item and how will you assign an item category flexifields to an item?????

1 Answers  

---

Is it possible to change the wearhouse after booking the Sales order, If Yes how to de allocate the items booked in previous wearehouse?

1 Answers   Accenture,

---

how to find customer is new or old in order management

4 Answers  

---

---

1.Is it mandetory to recieve an expenses item,if we do not recieve what would be the PO status.? 2.Can we Open a closed PO.?If yes,How...?

4 Answers   Idhasoft, Oracle,

---

Differentiate between intra & inter UOM class conversion with examples????

3 Answers  

---

The item attribute ‘Reservable’ is No - what is the impact?

2 Answers  

---

Explain the different levels of Inventory org structure ?

2 Answers   Om Logistics, SAT InfoTech, TR,

---

What Should be the steps after approving purchase order want to change the quantity.

3 Answers   Atlas Systems,

---

can you explain what documents are prepared as a functional consultant in implementation and supporting projects and also explain functionality of those documents?

3 Answers  

---

what are the tables used for the item catalog conversion and similarly mandatory columns along with validations?

2 Answers  

---