E-Business Suite Source System Tables
The E-Business Suite source system tables are used by Oracle Hyperion Financial Data Quality Management, Enterprise Edition. All tables require read privileges, unless noted otherwise.
Table B-1 E-Business Suite Source System Tables
| Table/View Name | Schema | Object Type | Privilege | Comments |
|---|---|---|---|---|
| FND_FLEX_VALIDATION_QUALIFIERS | APPLSYS | Table | Read only | |
| FND_FLEX_VALIDATION_TABLES | APPLSYS | Table | Read only | |
| FND_FLEX_VALUES | APPLSYS | View | Read only | |
| FND_FLEX_VALUES_TL | APPLSYS | View | Read only | |
| FND_FLEX_VALUE_CHILDREN_V | APPS | View | Read only | View based on FND_FLEX_VALUE_NORM_HIERARCHY, FND_FLEX_VALUE_SETS, and FND_FLEX_VALUES_VL |
| FND_FLEX_VALUE_NORM_HIERARCHY | APPLSYS | Table | Read only | |
| FND_FLEX_VALUE_SETS | APPLSYS | Table | Read only | |
| FND_FORM_FUNCTIONS | APPLSYS | Table | Read only | |
| FND_ID_FLEXS | APPLSYS | Table | Read only | |
| FND_ID_FLEX_SEGMENTS | APPLSYS | Table | Read only | |
| FND_ID_FLEX_SEGMENTS_TL | APPLSYS | Table | Read only | |
| FND_ID_FLEX_STRUCTURES | APPLSYS | Table | Read only | |
| FND_ID_FLEX_STRUCTURES_TL | APPLSYS | Table | Read only | |
| FND_LANGUAGES | APPLSYS | Table | Read only | |
| FND_NUMBER | APPLSYS | PL/SQL Package | Execute | |
| FND_RESPONSIBILITY | APPLSYS | Table | Read only | |
| FND_RESPONSIBILITY_TL | APPLSYS | Table | Read only | |
| FND_SEGMENT_ATTRIBUTE_VALUES | APPLSYS | Table | Read only | |
| GL_BALANCES | GL | Table | Read only | |
| GL_BALANCES_DELTA | GL | Table | Read only | |
| GL_BUDGETS | GL | Table | Read only | |
| GL_BUDGET_ENTITIES | GL | Table | Read only | |
| GL_BUDGET_INTERFACE | GL | Table | Read and write privileges are required. | |
| GL_BUDGET_VERSIONS | GL | Table | Read only | |
| GL_CODE_COMBINATIONS | GL | Table | Read only | |
| GL_CODE_COMBINATIONS_KFV | APPS | View | Read only | View based on GL_CODE_COMBINATIONS |
| GL_DAILY_BALANCES | GL | Table | Read only | |
| GL_DAILY_CONVERSION_TYPES | GL | Table | Read only | |
| GL_DAILY_CONVERSION_TYPES_V | APPS | View | Read only | View based on GL_DAILY_CONVERSION_TYPES |
| GL_DAILY_RATES | GL | Table | Read only | |
| GL_ENCUMBRANCE_TYPES | GL | Table | Read only | |
| GL_INTERFACE | GL | Table | Read/Write | |
| GL_JE_CATEGORIES | GL | Table | Read only | |
| GL_JE_CATEGORIES_TL | GL | Table | Read only | |
| GL_JE_SOURCES_TL | GL | Table | Read only | |
| GL_LEDGERS | Table | Read only | Table (R12 only) | |
| GL_PERIODS | GL | Table | Read only | |
| GL_PERIOD_SETS | GL | Table | Read only | |
| GL_PERIOD_STATUSES | GL | Table | Read only | |
| GL_PERIOD_TYPES | GL | Table | Read only | |
| GL_PERIOD_TYPES_V | APPS | View | Read only | View based on GL_PERIOD_TYPES |
| GL_SETS_OF_BOOKS | GL/APPS | View | Read only | Table (11i)/View based on GL_LEDGERS (R12) |
| GL_STAT_ACCOUNT_UOM | GL | Table | Read only | |
| GL_TRACK_DELTA_BALANCES | GL | Table | Read/Write | Read and write privileges are required. |