Fusion and E-Business Suite Source System Tables

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

Table/View NameSchemaObject TypePrivilegeComments
FND_FLEX_VALIDATION_QUALIFIERS APPLSYSTableRead only 
FND_FLEX_VALIDATION_TABLES APPLSYSTableRead only 
FND_FLEX_VALUES APPLSYSViewRead only 
FND_FLEX_VALUES_TL APPLSYSViewRead only 
FND_FLEX_VALUE_CHILDREN_V APPSViewRead onlyView based on FND_FLEX_VALUE_NORM_HIERARCHY, FND_FLEX_VALUE_SETS, and FND_FLEX_VALUES_VL
FND_FLEX_VALUE_NORM_HIERARCHYAPPLSYSTableRead only 
FND_FLEX_VALUE_SETS APPLSYSTableRead only 
FND_FORM_FUNCTIONS APPLSYSTableRead only 
FND_ID_FLEXS APPLSYSTableRead only 
FND_ID_FLEX_SEGMENTS APPLSYSTableRead only 
FND_ID_FLEX_SEGMENTS_TL APPLSYSTableRead only 
FND_ID_FLEX_STRUCTURESAPPLSYSTableRead only 
FND_ID_FLEX_STRUCTURES_TL APPLSYSTableRead only 
FND_LANGUAGES APPLSYSTableRead only 
FND_NEW_MESSAGESAPPLSYSTableRead only 
FND_NUMBERAPPLSYSPL/SQL PackageExecute 
FND_RESPONSIBILITYAPPLSYSTableRead only 
FND_RESPONSIBILITY_TL APPLSYSTableRead only 
FND_SEGMENT_ATTRIBUTE_VALUESAPPLSYSTableRead only 
GL_BALANCES GL TableRead only 
GL_BALANCES_DELTA GLTableRead only 
GL_BUDGETS GLTableRead only 
GL_BUDGET_ENTITIES GLTableRead only 
GL_BUDGET_INTERFACE GLTableRead and write privileges are required. 
GL_BUDGET_VERSIONS GLTableRead only 
GL_CODE_COMBINATIONS GLTableRead only 
GL_CODE_COMBINATIONS_KFV APPSViewRead onlyView based on GL_CODE_COMBINATIONS
GL_DAILY_BALANCES GLTableRead only 
GL_DAILY_CONVERSION_TYPESGLTableRead only 
GL_DAILY_CONVERSION_TYPES_V APPSViewRead onlyView based on GL_DAILY_CONVERSION_TYPES
GL_DAILY_RATES GLTableRead only 
GL_ENCUMBRANCE_TYPES GLTableRead only 
GL_INTERFACE GLTableRead/Write 
GL_JE_CATEGORIESGLTableRead only 
GL_JE_CATEGORIES_TLGLTableRead only 
GL_JE_SOURCES_TL GLTableRead only 
GL_LEDGERS TableRead onlyTable (R12 only)
GL_PERIODS GLTableRead only 
GL_PERIOD_SETS GLTableRead only 
GL_PERIOD_STATUSESGLTableRead only 
GL_PERIOD_TYPESGLTableRead only 
GL_PERIOD_TYPES_V APPSViewRead onlyView based on GL_PERIOD_TYPES
GL_SETS_OF_BOOKS GL/APPSViewRead onlyTable (11i) / View based on GL_LEDGERS (R12)
GL_STAT_ACCOUNT_UOM GLTableRead only 
GL_TRACK_DELTA_BALANCES GLTableRead/WriteRead and write privileges are required.