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
- 18108 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 |
Scenarios for backorder?
How is the charge account defaulted in Purchasing document(Requisition, PO)?
How do i generate Taxes when i'm doing Return To Vendor Transaction?
If any delivery grouping attributes in a sales order lines are different then what is the impact during pick release in shipping transaction form,What changes you observe?
Auto pick confirm whether required or not where is that set-up done? Other than OM System parameters where else?
how do you change the control level for item attributes from master level to organization level for example?? when i try to change this in the attribute control form, I got the message :frm-40200: field protected against update..
how do i change an item's UOM????
How do you create purchase order without requisition? Please provide the answer if you know
How does Oracle apps come to know that entered order is back to back or Standard sales order if in both the cases item is ATO type?
At what stage an order can not be cancelled?
How to define vacation rules in Oracle Purchasing upon User Request?
I have an Inv Org which is having 5 Stores. Each store is having an Individual Store Operator and is created as a User in Apps. Now, How can I restrict this Operator to his particular Store?
Oracle Apps Technical 
