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
- 17976 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 can u put inventory on hand value is negative?
What is the difference between replenishment counting and kanban?
Oracle report builder 6i is view based then what about report builder 10g?
What is the use of ADD to RECEIPT FILED in receipt localized? Then how to performing in SOURCE TYPE INTERNAL AND EXTERNAL?
At Present Gate entry entered in manual register, Should be enter in ERP on line at the main gate against PO. How we can achieve this? (India Localization)
what is the difference between format trigger and action trigger?at what level can we write the format trigger frame or repeating frame or item?
How many KFF are there in Order management? What is the use of Sales Order Flex-Field?
How is the charge account defaulted in Purchasing document(Requisition, PO)?
what is the connection between wsh_delivery_details and oe_order_headers_all or oe_order_lines_all? what is the connection between invoice and check payments?
Is it possible to change the warehouse after booking the sales order, if yes how to de allocate the items booked in previous warehouse?
At what stage an order can not be cancelled?
what characters can i use in an item name(including special characters)???
Oracle Apps Technical 
