what are the tables used for the item catalog conversion and similarly mandator

what are the tables used for the item catalog conversion and
similarly mandatory columns along with validations?

Question Posted / guest

2 Answers
17777 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the tables used for the item catalog conversion and similarly mandatory columns along with..

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

what are the tables used for the item catalog conversion and similarly mandatory columns along with..

Answer / guest

REFER Item Import open interface in mfgapi user guide

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Oracle Apps SCM Interview Questions

What is meant by Position Hierarchy and Supervisor Hierarchy ????

3 Answers

in the support project, what are issues u faced?

1 Answers iGate,

Is there a way to update schedule ship date for all lines of SO in one go?

1 Answers

Can you pls provide the interview questions on oracle apps SCM.including ASCP module.

0 Answers Infosys,

pl explain diffent types of hirarchies available in purchasing . and i also needs main key points in R12 FOR mfg modules

3 Answers Genpact,

how can we put sales order is on hold whenever we open the sales order form i want it will automatically go to hold without using credit check.How?

1 Answers Oracle,

diff between customer order and customer ordered attribute in oracle

2 Answers First American Corporation,

what is the significance of BILL OF LANDING PROGRAM in Order Management?

3 Answers Oracle,

What are the types of Calender? Where we are define it?

1 Answers

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?

2 Answers Intelligroup,

Scenarios for backorder?

3 Answers iGate,

How do i generate Taxes when i'm doing Return To Vendor Transaction?

0 Answers

For more Oracle Apps SCM Interview Questions Click Here