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

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

Once the SO was booked, the line status changed to ‘Closed. What could be the cause?

7 Answers  


If owner wants to self approve then what the set-ups required?

1 Answers  


How to Raise SR to Oracle?

6 Answers   IBM,


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

3 Answers  


what is the purpose of item master organisations? can we define more than one item master?

11 Answers  






May i know some of the real time issues we face in oracle purchasing, inventory and Order Management.

0 Answers  


in what case consultant will suggest for more than one operating unit, reasons?

3 Answers   IBM, Tech Mahindra,


If owner wants to self approve then what the set-ups required?

2 Answers   Cap Gemini, KPIT,


Oracle report builder 6i is view based then what about report builder 10g?

0 Answers   iGate,


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..

4 Answers  


how do i change an item's UOM????

3 Answers   Satyam,


WHAT ARE THE DIFF TYPES OF CALENDERS IN R12 ??? PLS EXPLAIN THEIR FEATURES ????

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)