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
- 17891 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 |
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?
what characters can i use in an item name(including special characters)???
Navigation to change the serial numbers from Shipping Transaction form.
Wanted to send the Notification to the Supplier by e-mail.
Which documents in Purchasing can be autocreated?
Where to find the ISO accounting entry details?
We have 2 check boxes Purchase and purchasable in Purchase tab for Master Item attributes. What is the difference between them, and why can't we use make or buy if some one answers as we are purchasing from supplier we say purchasable....
3 Answers Cap Gemini, Jade Software,
Can you pls provide the interview questions on oracle apps SCM.including ASCP module.
Name of the reports in oracle inventory related to transaction????
How many item master organisations can be created in Multi org structure ??????
difference between purchase price variance and invoice price variance???
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?
Oracle Apps Technical 
