GeekInterview.com
Series: Subject: Topic:
Question: 83 of 354

Oracle Apps process of item conversion and interface tables

Hi! Any one can you send me the details and process of item conversion?
1.What are the interface tables in item conversion?
2.What are the base tables in item conversion?
3.what are the validations and what is the standard program in item conv.?
Asked by: jaalioracle | Member Since May-2008 | Asked on: May 17th, 2008

View all questions by jaalioracle   View all answers by jaalioracle

Showing Answers 1 - 6 of 6 Answers
neerajinfy

Answered On : Jul 9th, 2008

View all answers by neerajinfy

Interface tables involved in Item COnversion:MTL_SYSTEM_ITEMS_INTERFACEMTL_ITEM_CATEGORIES_INTERFACEMTL_ERRORS_INTERFACEBase Tables:MTL_SYSTEM_ITEMSMTL_ITEM_CATEGORIESStandard Import Program name: Item Import (INCOIN)This program does most of the standard validations.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Interface tables involved in Item Conversion:
MTL_SYSTEM_ITEMS_INTERFACE

Base Tables:
MTL_SYSTEM_ITEMS
MTL_PARAMETERS
MTL_UNITS_OF_MEASURE
MTL_ITEM_TEMPLATES
GL_CODE_COMBINATIONS_KFV
Validations:
Organization code
UOM code
Template name
Cost account
Expense account
Sales account

Yes  1 User has rated as useful.
  
Login to rate this answer.
manveshv

Answered On : Jan 15th, 2010

View all answers by manveshv

The interface table for holding errors in item interface is "MTL_INTERFACE_ERRORS"

  
Login to rate this answer.
harish_trash

Answered On : Aug 2nd, 2010

View all answers by harish_trash

Why exactly do we do 'item interface' when we can create the data using 'item> Master Item' window

  
Login to rate this answer.
Madhu

Answered On : Jul 21st, 2011

BASE TABLE: MTL_SYTEM_ITEMS_B
INTERFACE TABLE: MTL_SYSTEM_ITEMS_INTERFACE
ERROR_TABLE :MTL_INTERFACE_ERRORS

VALIDATIONS: ORGANIZATION IS VALID OR NOT
MANDATORY COLUMNS
ITEM IS EXITED OR NOT
AVOIDING DUPLICATE RECOREDS.

  
Login to rate this answer.
sree

Answered On : Oct 1st, 2011

Oracle Apps process of item conversion and interface tables.

Interface tables involved in Item Conversion:
MTL_SYSTEM_ITEMS_INTERFACE

Base Tables:
MTL_SYSTEM_ITEMS
MTL_PARAMETERS
MTL_UNITS_OF_MEASURE
MTL_ITEM_TEMPLATES
GL_CODE_COMBINATIONS_KFV

Validations:
Organization code
UOM code
Template name
Cost account
Expense account
Sales account

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.