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

Questions by jaalioracle   answers by jaalioracle

Showing Answers 1 - 6 of 6 Answers

neerajinfy

  • Jul 9th, 2008
 

Interface tables involved in Item COnversion:

MTL_SYSTEM_ITEMS_INTERFACE

MTL_ITEM_CATEGORIES_INTERFACE

MTL_ERRORS_INTERFACE


Base Tables:

MTL_SYSTEM_ITEMS

MTL_ITEM_CATEGORIES


Standard Import Program name: Item Import (INCOIN)
This program does most of the standard validations.

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

Madhu

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

  Was this answer useful?  Yes

sree

  • 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

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions