Oracle General Ledger Tables
Oracle General Ledger Module – List of database tables:
- GL_ACCESS_SETS
- GL_ACCESS_SET_ASSIGNMENTS
- GL_ACCESS_SET_NORM_ASSIGN
- GL_ACCOUNT_HIERARCHIES
- GL_ALLOC_BATCHES
- GL_ALLOC_FORMULAS
- GL_ALLOC_FORMULA_LINES
- GL_ALLOC_HISTORY
- GL_ALLOC_INTERIM_1
- GL_ALLOC_INTERIM_2
- GL_ALLOC_INTERIM_3
- GL_ALLOC_TARGETS
- GL_APPLICATION_GROUPS
- GL_ARCHIVE_BALANCES
- GL_ARCHIVE_BATCHES
- GL_ARCHIVE_DAILY_BALANCES
- GL_ARCHIVE_HEADERS
- GL_ARCHIVE_HISTORY
- GL_ARCHIVE_LINES
- GL_ARCHIVE_REFERENCES
- GL_AUTHORIZATION_LIMITS
- GL_AUTOMATIC_POSTING_OPTIONS
- GL_AUTOMATIC_POSTING_SETS
- GL_AUTOREVERSE_OPTIONS
- GL_AUTOREV_CRITERIA_SETS
- GL_AUTO_ALLOC_BATCHES
- GL_AUTO_ALLOC_BATCH_HISTORY
- GL_AUTO_ALLOC_BAT_HIST_DET
- GL_AUTO_ALLOC_REV_BATCHES
- GL_AUTO_ALLOC_SETS
- GL_AUTO_ALLOC_SET_HISTORY
- GL_BALANCES
- GL_BALANCES_DELTA
- GL_BALANCES_DELTA_INTERIM
- GL_BC_DUAL
- GL_BC_DUAL2
- GL_BC_EVENT_TIMESTAMPS
- GL_BC_OPTIONS
- GL_BC_OPTION_DETAILS
- GL_BC_PACKETS
- GL_BC_PACKETS_HISTS
- GL_BC_PACKET_ARRIVAL_ORDER
- GL_BC_PERIOD_MAP
- GL_BUDGETS
- GL_BUDGET_ASSIGNMENTS
- GL_BUDGET_ASSIGNMENT_RANGES
- GL_BUDGET_BATCHES
- GL_BUDGET_ENTITIES
- GL_BUDGET_FROZEN_RANGES
- GL_BUDGET_INTERFACE
- GL_BUDGET_INTERIM
- GL_BUDGET_PERIOD_RANGES
- GL_BUDGET_RANGE_INTERIM
- GL_BUDGET_TYPES
- GL_BUDGET_VERSIONS
- GL_BUDORG_BC_OPTIONS
- GL_CAPTURED_INFO
- GL_CARRYFORWARD_RANGES
- GL_COA_MAPPINGS
- GL_CODE_COMBINATIONS
- GL_CONCURRENCY_CONTROL
- GL_CONCURRENT_SCHEDULES
- GL_CONSOLIDATION
- GL_CONSOLIDATION_ACCOUNTS
- GL_CONSOLIDATION_AUDIT
- GL_CONSOLIDATION_HISTORY
- GL_CONSOLIDATION_SETS
- GL_CONS_BATCHES
- GL_CONS_FLEXFIELD_MAP
- GL_CONS_FLEX_HIERARCHIES
- GL_CONS_SEGMENT_MAP
- GL_CONS_SET_ASSIGNMENTS
- GL_CROSS_RATE_RULES
- GL_CROSS_RATE_RULE_DTLS
- GL_DAILY_BALANCES
- GL_DAILY_CONVERSION_RATES
- GL_DAILY_CONVERSION_TYPES
- GL_DAILY_RATES
- GL_DAILY_RATES_INTERFACE
- GL_DATE_PERIOD_MAP
- GL_DEFAS_ACCESS_SETS
- GL_DEFAS_ASSIGNMENTS
- GL_DEFAS_RESP_ASSIGN
- GL_DOC_SEQUENCE_AUDIT
- GL_DYNAMIC_SUMM_COMBINATIONS
- GL_EFC_BUDGET_MAPPING
- GL_EFC_CHANGED_TRX
- GL_EFC_DISABLED_TRIGGERS
- GL_EFC_RUN_HISTORY
- GL_ELIMINATION_HISTORY
- GL_ELIMINATION_JOURNALS
- GL_ELIMINATION_SETS
- GL_ELIM_ACCOUNTS_MAP
- GL_ELIM_BAL_OPTIONS
- GL_ENCUMBRANCE_TYPES
- GL_ENTITY_BUDGETS
- GL_EXTRACT_HISTORY
- GL_FIXED_CONV_RATES
- GL_HISTORICAL_RATES
- GL_HISTORICAL_RATE_RANGES
- GL_IEA_AUTOGEN_MAP
- GL_IEA_CLEARING_ACCOUNTS
- GL_IEA_IMPORT_REGISTRY
- GL_IEA_INTERFACE
- GL_IEA_RECUR_BATCHES
- GL_IEA_RECUR_HISTORY
- GL_IEA_RECUR_LINES
- GL_IEA_RECUR_TRANSACTIONS
- GL_IEA_SEGMENT_MAP
- GL_IEA_SEGMENT_RULE_MAP
- GL_IEA_SUBSIDIARIES
- GL_IEA_TRANSACTIONS
- GL_IEA_TRANSACTION_LINES
- GL_IEA_TRANSACTION_TYPES
- GL_IMPORT_REFERENCES
- GL_INTERCOMPANY_ACCOUNTS
- GL_INTERCOMPANY_ACC_SETS
- GL_INTERFACE
- GL_INTERFACE_CONTROL
- GL_INTERFACE_HISTORY
- GL_ISPEED_COA_SEGMENTS
- GL_ISPEED_COA_TEMPLATES
- GL_JE_BATCHES
- GL_JE_CATEGORIES_TL
- GL_JE_HEADERS
- GL_JE_INCLUSION_RULES
- GL_JE_LINES
- GL_JE_LINES_RECON
- GL_JE_SEGMENT_VALUES
- GL_JE_SEGVALS_UPGRADE
- GL_JE_SOURCES_TL
- GL_JOURNAL_REPORTS_ITF
- GL_LEDGERS
- GL_LEDGER_BSV_GT
- GL_LEDGER_CONFIGURATIONS
- GL_LEDGER_CONFIG_DETAILS
- GL_LEDGER_LE_BSV_GT
- GL_LEDGER_NORM_SEG_VALS
- GL_LEDGER_RELATIONSHIPS
- GL_LEDGER_SEGMENT_VALUES
- GL_LEDGER_SETS
- GL_LEDGER_SET_ASSIGNMENTS
- GL_LEDGER_SET_NORM_ASSIGN
- GL_LEDGER_SET_REQUESTS
- GL_LEGAL_ENTITIES_BSVS
- GL_LE_VALUE_SETS
- GL_LOOKUPS_OLD
- GL_MC_BOOK_ASSIGNMENTS
- GL_MC_BOOK_ASSIGNMENTS_11I
- GL_MC_CONVERSION_RULES
- GL_MC_CONVERSION_RULES_11I
- GL_MC_REPORTING_OPTIONS
- GL_MC_REPORTING_OPTIONS_11I
- GL_MC_UPGRADE_HISTORY
- GL_MC_UPGRADE_RATES
- GL_MGT_SEG_UPGRADE
- GL_MGT_SEG_UPGRADE_H
- GL_MOVEMERGE_ACCOUNTS
- GL_MOVEMERGE_REQUESTS
- GL_NET_INCOME_ACCOUNTS
- GL_OASIS_FIN_ASSIGNMENTS
- GL_OASIS_FIN_ASSIGNMENTS_11I
- GL_OASIS_FIN_ITEMS
- GL_OASIS_FIN_ITEMS_11I
- GL_OASIS_FIN_METRICS
- GL_OASIS_FIN_METRICS_11I
- GL_OASIS_SUMMARY_DATA
- GL_PERIODS
- GL_PERIOD_SETS
- GL_PERIOD_STATUSES
- GL_PERIOD_TYPES
- GL_POSTING_INTERIM
- GL_RECURRING_BATCHES
- GL_RECURRING_HEADERS
- GL_RECURRING_LINES
- GL_RECURRING_LINE_CALC_RULES
- GL_REVALUATION
- GL_REVALUATIONS
- GL_REVALUATION_ACCOUNTS
- GL_REVAL_ACCOUNT_RANGES
- GL_ROLLUP_GROUP_SCORES
- GL_ROW_MULTIPLIERS
- GL_RX_TRIAL_BALANCE_ITF
- GL_SEGMENT_FREQUENCIES
- GL_SEGVAL_INHERIT_HISTORY
- GL_SEG_VAL_HIERARCHIES
- GL_SEG_VAL_NORM_HIERARCHY
- GL_SETS_OF_BOOKS
- GL_SETS_OF_BOOKS_11I
- GL_SHARES_ACTIVITY
- GL_SHARES_OUTSTANDING
- GL_STAT_ACCOUNT_UOM
- GL_STORAGE_PARAMETERS
- GL_SUMMARY_BC_OPTIONS
- GL_SUMMARY_HIERARCHIES
- GL_SUMMARY_HIERARCHY_INT
- GL_SUMMARY_INTERIM
- GL_SUMMARY_TEMPLATES
- GL_SUSPENSE_ACCOUNTS
- GL_SYSTEM_SETUP
- GL_SYSTEM_SETUP_11I
- GL_SYSTEM_USAGES
- GL_TAX_CODES
- GL_TAX_OPTIONS
- GL_TAX_OPTION_ACCOUNTS
- GL_TEMPORARY_COMBINATIONS
- GL_TRACK_DELTA_BALANCES
- GL_TRANSACTION_CALENDAR
- GL_TRANSACTION_DATES
- GL_TRANSACTION_RATE_EXCEPTIONS
- GL_TRANSLATION_INTERIM
- GL_TRANSLATION_RATES
- GL_TRANSLATION_RATES_11I
- GL_TRANSLATION_STATUSES
- GL_TRANSLATION_TRACKING
- GL_UPDATE_RECOVERY_H
- GL_UPGRADE_STATUS
- GL_USSGL_ACCOUNT_PAIRS
- GL_USSGL_TRANSACTION_CODES
- GL_WEIGHTED_AVG_DETAILS
raghu said on January 30, 2013
good work …the classification looks good