what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?
- 2 Answers
- 16593 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 |
When does Sales order header get closed?
What are the FAQ's asked Functional consultants in SCM ? If any one knows please send.
What is the use of ADD to RECEIPT FILED in receipt localized? Then how to performing in SOURCE TYPE INTERNAL AND EXTERNAL?
what is the difference between item category and item catalog can you please give examples for both
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?
After pick released, can I change into backorder? If it is possible, how?
can you tel me what is the difference between workday calendar and accounting calendar??????
while shipping, under delivery tab if we didn’t mention organization/inventory will the order be back order?
How to make an Item as a Stock Item but not for Sale.
What if when physical count differs from system count?
When does Sales order header get closed?
Please let me know the important Interview concepts to be learnt for PO,OM and INV Modules
Oracle Apps Technical 
