E-Business Suite Source System Tables

These E-Business Suite source system tables are used by ERP Integrator. All tables require read privileges, unless noted otherwise.

Table / View NameSchemaComments
FND_FLEX_VALIDATION_QUALIFIERS APPLSYS 
FND_FLEX_VALIDATION_TABLES APPLSYS 
FND_FLEX_VALUES APPLSYS 
FND_FLEX_VALUES_TL APPLSYS 
FND_FLEX_VALUE_CHILDREN_V APPSView based on FND_FLEX_VALUE_NORM_HIERARCHY, FND_FLEX_VALUE_SETS, and FND_FLEX_VALUES_VL
FND_FLEX_VALUE_NORM_HIERARCHYAPPLSYS 
FND_FLEX_VALUE_SETS APPLSYS 
FND_FORM_FUNCTIONS APPLSYS 
FND_ID_FLEXS APPLSYS 
FND_ID_FLEX_SEGMENTS APPLSYS 
FND_ID_FLEX_SEGMENTS_TL APPLSYS 
FND_ID_FLEX_STRUCTURESAPPLSYS 
FND_ID_FLEX_STRUCTURES_TL APPLSYS 
FND_LANGUAGES APPLSYS 
FND_RESPONSIBILITYAPPLSYS 
FND_RESPONSIBILITY_TL APPLSYS 
FND_SEGMENT_ATTRIBUTE_VALUESAPPLSYS 
GL_BALANCES GL  
GL_BALANCES_DELTA GL 
GL_BUDGETS GL 
GL_BUDGET_ENTITIES GL 
GL_BUDGET_INTERFACE GLRead and write privileges are required.
GL_BUDGET_VERSIONS GL 
GL_CODE_COMBINATIONS GL 
GL_CODE_COMBINATIONS_KFV APPSView based on GL_CODE_COMBINATIONS
GL_DAILY_BALANCES GL 
GL_DAILY_CONVERSION_TYPESGL 
GL_DAILY_CONVERSION_TYPES_V APPSView based on GL_DAILY_CONVERSION_TYPES
GL_DAILY_RATES GL 
GL_ENCUMBRANCE_TYPES GL 
GL_INTERFACE GLRead and write privileges are required.
GL_JE_CATEGORIESGL 
GL_JE_CATEGORIES_TLGL 
GL_JE_SOURCES_TL GL 
GL_PERIODS GL 
GL_PERIOD_SETS GL 
GL_PERIOD_TYPESGL 
GL_PERIOD_TYPES_V APPSView based on GL_PERIOD_TYPES
GL_LEDGERSGLTable (R12 only)
GL_SETS_OF_BOOKS GL/APPSTable (11i) / View based on GL_LEDGERS (R12)
GL_STAT_ACCOUNT_UOM GL 
GL_TRACK_DELTA_BALANCES GLRead and write privileges are required.