what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
- 2 Answers
- 16554 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 move Order Number is generated? I know it is Displayed Automatically,But i want to know How it is generated&any SETUP is required??? Regards, Santhosh
If customer is makes advance payment against to any SO, how to apply the amount while raising sales order in SO Form?
1 Answers Accenture, CSS Corp,
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?
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?
What Should be the steps after approving purchase order want to change the quantity.
When does Sales order header get closed?
Can you delete the Item from item masters ? How ? What are the pre-requisites to delete ???
Once the SO was booked, the line status changed to ‘Closed. What could be the cause?
In order management, how to reserve an item without booking?
what is the difference between item category and item catalog can you please give examples for both
If owner wants to self approve then what the set-ups required?
can you explain what documents are prepared as a functional consultant in implementation and supporting projects and also explain functionality of those documents?
Oracle Apps Technical 
