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

Pick and ship should be performed by application itself when i book the sales order.Is it possible in order management. I can do this by just using pick and ship action using transaction window but even i will not use transaction window also,Only i will book the sales order.Picking and shipping should be done by system automatically.

1 Answers  

---

When does Sales order header get closed?

3 Answers  

---

Hi Guys, I am looking for Oracle Apps SCM/Finance Functional Training in Bangalore. Please suggest me or Guide me

0 Answers   Wipro,

---

How move Order Number is generated? I know it is Displayed Automatically,But i want to know How it is generated&any SETUP is required??? Regards, Santhosh

3 Answers  

---

Tell me is there a way to update schedule ship date for all lines of so in one go?

0 Answers  

---

What are the version controllers?

1 Answers   Cap Gemini, TCS,

---

Can a Requisition be amended?

1 Answers  

---

how can we put sales order is on hold whenever we open the sales order form i want it will automatically go to hold without using credit check.How?

1 Answers   Oracle,

---

Oracle Needs to raise Purchase Order Automatically when the Item Quantity down in Inventory, without using min-max?

5 Answers   IBM,

---

What are the different types of excise exemptions?

0 Answers  

---

Can one ‘operating unit’ user see the sales order of other operating? How can we achieve this?

3 Answers   Cap Gemini,

---

What is the different between 11i and R12 in oracle ?

12 Answers   Cap Gemini, Deloitte, KPIT,

---