what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
- 2 Answers
- 17097 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 |
how do i change an item's UOM????
What is the use of LC? How is it useful in export sales?
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?
What are the FAQ's asked Functional consultants in SCM ? If any one knows please send.
Diff b/w Discrete mfg and Process manfactureing? If anyone have the detailed steps on this topic, please forward to me yakumar47@gmail.com
WHERE IS DEFINE RECEIPT & RECEIPT TRANSACTIONS FORM CONTROLS?
What is the use of ADD to RECEIPT FILED in receipt localized? Then how to performing in SOURCE TYPE INTERNAL AND EXTERNAL?
How many item master organisations can be created in Multi org structure ??????
How can i restrict a user for items selection on Receipts forms?
How many KFF are there in Order management? What is the use of Sales Order Flex-Field?
New Item is manufactured and we can do internal transaction but this item would be ready for sale from August 1st. where do we update start date for this item to available in Sales order?
Is it possible to change the wearhouse after booking the Sales order, If Yes how to de allocate the items booked in previous wearehouse?
Oracle Apps Technical 
