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

1 response to Oracle General Ledger Tables

  1. good work …the classification looks good

Leave a reply

Your email address will not be published. Required fields are marked *