Oracle Apps process of item conversion and interface tables

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

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

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.

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