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

What are the different types of excise exemptions?

0 Answers  

---

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  

---

How can i restrict a user for items selection on Receipts forms?

1 Answers  

---

Explain the different levels of Inventory org structure ? What is Operating Unit ? What is Legal Entity ? What is Inventory Organization ? What is Set Of Books ? In which setup you control the costing method ? What is Item master organization ? How many item master organization we can setup ? What is Subinventory ? What is Locator ? Are Subinventory or Locators mandatory ? Can you copy inventory org structure ? What is shipping network ? Explain UOM and UOM class ? Explain Item status controls ? How many Item attributes we can setup ? How you can provide custom item attributes ? What are status attributes ? Explain the functionality of Item templates ? How Item types are defined ? Explain the use of cross-references ? Explain Item categories ? What is the difference between category and category set ? How do you assign items to item categories ? How do you load /import items ? Explain the use of Item revisions ? How do you search items ? How do you delete items ? What are deletion constraints ? Can we have custom deletion constraints ? What are different type of serial number uniqueness ? How do you generate serial numbers ? Can serial numbers and lot numbers co-exists for an item ? Where do you enable or disable serial / lot number capabilities for an item ? What is material status ? Explain the use of material status ? List some of the seeded material transaction types ? What are transaction sources ? Can we have custom transaction sources / types ? What are the benefits of account aliases ? What is the difference between subinventory transfer and move order ? Can move orders support inter-organization transfer ? What is miscellaneous transactions ? Explain the use of shortage notifications ? Where do you enable the shortage notifications ? How do you do inter-org transfer ? Is sales order mandatory for inter-org transfer ? Explain the difference between direct transfer and intransit transfer ? Can we purge material transactions ? Can we import material transactions through API ? What is vendor managed Inventory (VMI) ? What consigned Inventory ? What is the difference between VMI & consigned inventory ? Explain the life cycle of move orders ? What are the different ways move orders are created ? What forecasting methods oracle inventory supports ? When do you generate forecast automatically and when do you setup manually ? Explain the min-max planning functionality ? Explain the Re-Order Planning (ROP) process ? What is the difference between Min-Max and ROP ? What is safety stock ? How safety stock is calculated ? Explain replenishment counting ? What is the purpose of ABC analysis ? Explain the cycle counting process ? Explain the physical inventory process ? When do you recommend cycle counting Vs physical inventory ? What are the key flex fields (KFF) in Oracle Inventory ? What are the descriptive flex fields (DFF) in oracle inventory ?

8 Answers   Deloitte, TCS,

---

waht is the difference between min-max planning and reorder point ?????

1 Answers   Oracle,

---

what is the purpose of item master organisations? can we define more than one item master?

11 Answers  

---

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

2 Answers  

---

what characters can i use in an item name(including special characters)???

1 Answers  

---

pl explain diffent types of hirarchies available in purchasing . and i also needs main key points in R12 FOR mfg modules

3 Answers   Genpact,

---

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 create sales order/purchase order for service items?

2 Answers   iGate, Mascom,

---

Can i make restrictions for sales order? Like, book the sales order only for 100 or above quantities?

1 Answers  

---