Interested to Buy Any Domain ? << Click Here >> for more details...
what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
- 2 Answers
- 17987 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
REFER Item Import open interface in mfgapi user guide
| Is This Answer Correct ? | 1 Yes | 1 No |
In OM customer requested for Item A but shipped Item B (Substitute Item). If customer returns substitute item what steps we follow Is there any steps for substiture RMA returns?
can u tell me the upgradation issues in oracle apps
Please let me know the important Interview concepts to be learnt for PO,OM and INV Modules
what characters can i use in an item name(including special characters)???
What Should be the steps after approving purchase order want to change the quantity.
Scenarios for backorder?
Even though Item attributes are correctly set and item is assigned to OE Item validation organization still the item in not available while creating SO. What is the cause?
Differentiate between intra & inter UOM class conversion with examples????
Tell me is there a way to update schedule ship date for all lines of so in one go?
Explain the different levels of Inventory org structure ?
2 Answers Om Logistics, SAT InfoTech, TR,
How many item category flexifields you can have for an item and how will you assign an item category flexifields to an item?????
I have approved purchase requisition and it's status is IN PROCESS and it will go next level they are also approved and WF notification has been approved and closed but still purchase requisition status is IN process.what is the reason? How can u resolve?this is the issue i faced in Oracle India.
Oracle Apps Technical 
