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

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

1 Answers  

---

If owner wants to self approve then what the set-ups required?

1 Answers  

---

Is it possible to change the warehouse after booking the sales order, if yes how to de allocate the items booked in previous warehouse?

0 Answers  

---

how do you change the control level for item attributes from master level to organization level for example?? when i try to change this in the attribute control form, I got the message :frm-40200: field protected against update..

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,

---

Is it possible to generate directly Blanket release by running min Max planning ? How ?

1 Answers  

---

If owner wants to self approve then what the set-ups required?

2 Answers   Cap Gemini, KPIT,

---

Hi, I just want to know the best institute to learn (oracle apps scm functional) in hyderabad ?

19 Answers  

---

How many KFF are there in Order management? What is the use of Sales Order Flex-Field?

6 Answers  

---

When a consultant decide or suggest to create OU and Inventory Organization ? Why the difference is ?

2 Answers   Systant,

---

What are the FAQ's asked Functional consultants in SCM ? If any one knows please send.

0 Answers   DAZ, TCS,

---

If any delivery grouping attributes in a sales order lines are different then what is the impact during pick release in shipping transaction form,What changes you observe?

1 Answers   Quest,

---