GL Tables (215)

GL - General Ledger — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
GL_ACCESS_SETS 32 Data access set definitions
GL_ACCESS_SET_ASSIGNMENTS 12 Flattened data access set privilege assignments
GL_ACCESS_SET_LEDGERS 10
GL_ACCESS_SET_NORM_ASSIGN 33 Data access set privilege assignments
GL_ACCOUNT_HIERARCHIES 7 Summary/Detail account hierarchies
GL_ALLOC_BATCHES 13 MassAllocations and MassBudget batches
GL_ALLOC_FORMULAS 15 MassAllocations and MassBudget formulas
GL_ALLOC_FORMULA_LINES 56 MassAllocations and MassBudget formula lines
GL_ALLOC_HISTORY 17 History of MassAllocation and MassBudget runs
GL_APPLICATION_GROUPS 4 Application product groups that use Oracle General Ledger accounting periods
GL_ARCHIVE_HISTORY 20 History of the archive and purges of journals and balances
GL_AUTHORIZATION_LIMITS 24 Journal approval authorization limits for employees
GL_AUTOMATIC_POSTING_OPTIONS 28 Individual automatic posting criteria
GL_AUTOMATIC_POSTING_SETS 34 Sets of automatic posting criteria
GL_AUTOREVERSE_OPTIONS 28 Reversal criteria for generating automatic journal reversals
GL_AUTOREV_CRITERIA_SETS 25 Journal reversal criteria sets
GL_AUTO_ALLOC_BATCHES 27 Assignments of MassAllocation, Mass Budgets, Mass Encumbrances, Recurring Journals or Projects batches to an allocation set
GL_AUTO_ALLOC_BATCH_HISTORY 16 History of all batches included in an allocation set run
GL_AUTO_ALLOC_BAT_HIST_DET 11 Status of concurrent program submitted for each step in the allocation set
GL_AUTO_ALLOC_REV_BATCHES 12 Reverse journal batches generated by AutoAllocation rollback process
GL_AUTO_ALLOC_SETS 33 Autoallocation set definition for step-down or parallel allocations
GL_AUTO_ALLOC_SET_HISTORY 29 History of allocation set runs
GL_BALANCES 37 Account balances for both detail and summary accounts
GL_BALANCES_DELTA 29 Incremental changes to account balances
GL_BALANCES_DELTA_INTERIM 25 Interim tracking of incremental account balances
GL_BC_DUAL 1 Budgetary control concurrency table
GL_BC_DUAL2 1 Budgetary control concurrency table
GL_BC_EVENT_TIMESTAMPS 8 Budgetary control events (Summary Templates and Budget Assignment Ranges)
GL_BC_OPTIONS 25 Budgetary control options
GL_BC_OPTION_DETAILS 28 Budgetary control option details
GL_BC_PACKETS 89 Budgetary control queue table
GL_BC_PACKETS_HISTS 89 GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control pack
GL_BC_PACKET_ARRIVAL_ORDER 6 Budgetary control packet processing sequence
GL_BC_PERIOD_MAP 15 Budgetary control period boundaries
GL_BUDGETS 26 Budget definitions
GL_BUDGET_ASSIGNMENTS 30 Budget organization accounts
GL_BUDGET_ASSIGNMENT_RANGES 97 Budget organization account ranges
GL_BUDGET_BATCHES 8 Budget formula batches
GL_BUDGET_ENTITIES 60 Budget organization definitions
GL_BUDGET_FROZEN_RANGES 69 Frozen account ranges for a budget or budget organization
GL_BUDGET_INTERFACE 107 Upload budget data from external sources
GL_BUDGET_INTERIM 111 Budget posting interim balances
GL_BUDGET_PERIOD_RANGES 9 Status of budget period ranges (open/not open)
GL_BUDGET_RANGE_INTERIM 100 Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms
GL_BUDGET_TYPES 11 Budget type definitions
GL_BUDGET_VERSIONS 25 Budget version definitions
GL_BUDORG_BC_OPTIONS 10
GL_BUD_DOWNLOAD_GT 123
GL_CARRYFORWARD_RANGES 66 Ranges of encumbrance accounts to carry across fiscal years
GL_COA_MAPPINGS 13 Chart of accounts mapping definitions
GL_CODE_COMBINATIONS 112 Account combinations
GL_CONCURRENCY_CONTROL 8 Concurrent process internal locking mechanism
GL_CONCURRENT_SCHEDULES 27 Oracle General Ledger concurrent schedule definitions
GL_CONSOLIDATION 29 Consolidation definitions
GL_CONSOLIDATION_ACCOUNTS 69 Account ranges for consolidating balances
GL_CONSOLIDATION_AUDIT 43 Audit data for consolidation run
GL_CONSOLIDATION_HISTORY 31 History of consolidation runs
GL_CONSOLIDATION_SETS 31 Consolidation sets
GL_CONS_BATCHES 8 Transaction method consolidation batches
GL_CONS_FLEXFIELD_MAP 75 Consolidation account rules
GL_CONS_FLEX_HIERARCHIES 15 Consolidation subsidiary segment hierarchies
GL_CONS_SEGMENT_MAP 21 Consolidation segment rules
GL_CONS_SET_ASSIGNMENTS 24 Assignments of consolidations to consolidation sets
GL_CROSS_RATE_RULES 8 Cross Rate Rules
GL_CROSS_RATE_RULE_DTLS 9 Cross Rate Rule Details
GL_DAILY_BALANCES 163 Daily aggregate balances for both detail and summary accounts
GL_DAILY_CONVERSION_TYPES 30 Foreign currency daily conversion rate types
GL_DAILY_RATES 28 Daily conversion rates for foreign currency transactions
GL_DAILY_RATES_INTERFACE 29 Import daily conversion rates
GL_DATE_PERIOD_MAP 9 Date to period mappings
GL_DEFAS_ACCESS_SETS 26 Definition access set definitions
GL_DEFAS_ASSIGNMENTS 29 Definition access set privilege assignments
GL_DEFAS_RESP_ASSIGN 31 Assignment of definition access sets to responsibilities
GL_DOC_SEQUENCE_AUDIT 5 Sequential numbering audit table
GL_DRILL_ACCOUNT_RANGES_GT 77
GL_DRM_HIERARCHY_INTERFACE 3
GL_DRM_SEGVALUES_INTERFACE 45
GL_DYNAMIC_SUMM_COMBINATIONS 36 Newly created summary account combinations
GL_EFC_BUDGET_MAPPING 10 Budget and budget organization mappings for Euro as Functional Currency process
GL_EFC_CHANGED_TRX 13 Transactions that need to be reprocessed by the Euro as Functional Currency process
GL_EFC_DISABLED_TRIGGERS 2 Triggers disabled by the Euro as Functional Currency process
GL_EFC_RUN_HISTORY 25 Euro as Functional Currency process history
GL_ELIMINATION_HISTORY 28 Intercompany elimination history
GL_ELIMINATION_JOURNALS 27 Intercompany elimination journals
GL_ELIMINATION_SETS 31 Intercompany elimination set definitions
GL_ELIM_ACCOUNTS_MAP 83 Intercompany elimination account mappings
GL_ELIM_BAL_OPTIONS 30 Intercompany elimination balancing options.
GL_ENCUMBRANCE_TYPES 11 Encumbrance type definitions
GL_ENTITY_BUDGETS 14 Freeze budget organizations for particular budgets
GL_EXTRACT_HISTORY 14 Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract I
GL_FIXED_CONV_RATES 9 Fixed conversion rates for changes in national currency
GL_HISTORICAL_RATES 23 Foreign currency translation rates for historical accounts
GL_HISTORICAL_RATE_RANGES 72 Historical translation rates account ranges
GL_IEA_AUTOGEN_MAP 26 Automatic account generation mapping rules for the Global Intercompany System
GL_IEA_CLEARING_ACCOUNTS 23 Clearing accounts
GL_IEA_IMPORT_REGISTRY 3 Global Intercompany System import execution control
GL_IEA_INTERFACE 81 Transactional data for import into Global Intercompany System
GL_IEA_RECUR_BATCHES 34 Recurring intercompany batches
GL_IEA_RECUR_HISTORY 12 History of recurring intercompany batch runs
GL_IEA_RECUR_LINES 27 Recurring intercompany transaction lines
GL_IEA_RECUR_TRANSACTIONS 40 Recurring intercompany transactions
GL_IEA_SEGMENT_MAP 29 Automatic account generation segment mapping rules for the Global Intercompany System
GL_IEA_SEGMENT_RULE_MAP 27 Automatic account generation individual segment mapping rules for the Global Intercompany System
GL_IEA_SUBSIDIARIES 39 Subsidiary definitions
GL_IEA_TRANSACTIONS 116 Intercompany transactions
GL_IEA_TRANSACTION_LINES 62 Intercompany transaction lines
GL_IEA_TRANSACTION_TYPES 29 Intercompany transaction types
GL_IMPORT_REFERENCES 22 Cross-references between subledgers and Oracle General Ledger's journal entries
GL_IMP_COA_ERR_INTERFACE 14 Error message interface table for the Chart of Account Segment Values Import process.
GL_IMP_COA_NORM_HIER_INTERFACE 8 Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.
GL_IMP_COA_SEG_VAL_INTERFACE 18 Import of Chart of Accounts Segment Values
GL_INTERCOMPANY_ACCOUNTS 27 Assignments of intercompany due to and due from accounts to a source, category, and balancing segment value.
GL_INTERCOMPANY_ACC_SETS 28 Intercompany transaction processing rules
GL_INTERFACE 133 Import journal entry batches
GL_INTERFACE_CONTROL 9 Journal import execution control
GL_INTERFACE_HISTORY 130 Imported journal entry batches
GL_ISPEED_COA_SEGMENTS 11 Chart of Accounts segments information.
GL_ISPEED_COA_TEMPLATES 9 Chart of Accounts template definition.
GL_JE_BATCHES 73 Journal entry batches
GL_JE_CATEGORIES_TL 19 Journal entry categories
GL_JE_HEADERS 89 Journal entry headers
GL_JE_INCLUSION_RULES 26 Journal Inclusion rule
GL_JE_LINES 94 Journal entry lines
GL_JE_LINES_RECON 12
GL_JE_SEGMENT_VALUES 8 Journal entry balancing and management segment values.
GL_JE_SEGVALS_UPGRADE 1
GL_JE_SOURCES_TL 23 Journal entry sources
GL_JOURNAL_REPORTS_ITF 36 Interface table for RXi Oracle General Ledger journal reports.
GL_LEDGERS 89 Ledger definition
GL_LEDGER_BSV_GT 3
GL_LEDGER_CONFIGURATIONS 26 Primary ledgers
GL_LEDGER_CONFIG_DETAILS 12 Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup.
GL_LEDGER_LE_BSV_GT 14
GL_LEDGER_NORM_SEG_VALS 32 Valid balancing segment values for ledger
GL_LEDGER_RELATIONSHIPS 36 Relationships between ledgers
GL_LEDGER_SEGMENT_VALUES 14 Flattened valid balancing segment values for ledger
GL_LEDGER_SET_ASSIGNMENTS 10 Flattened ledger set assignments
GL_LEDGER_SET_NORM_ASSIGN 27 Ledger set assignments
GL_LEDGER_SET_REQUESTS 11 Ledger set child request status.
GL_LEGAL_ENTITIES_BSVS 10 Legal entity balancing segment value assignments.
GL_LE_VALUE_SETS 7 Legal entity value set assignments.
GL_MC_BOOK_ASSIGNMENTS_11I 17 Assignments of reporting sets of books to primary sets of books
GL_MC_CONVERSION_RULES_11I 36 Multiple reporting currency conversion rules for Oracle General Ledger
GL_MC_REPORTING_OPTIONS_11I 42 Multiple reporting currency conversion options by application/operating unit/asset book
GL_MC_UPGRADE_HISTORY 16 History of upgrade for each application and reporting set of books
GL_MC_UPGRADE_RATES 8 Exchange rates used for the multiple reporting currency upgrade programs
GL_MGT_SEG_UPGRADE 7 Management segment upgrade unprocessed journal batches.
GL_MGT_SEG_UPGRADE_H 10 History of management segment upgrade.
GL_MOVEMERGE_ACCOUNTS 83 Mass maintenance request account mappings
GL_MOVEMERGE_REQUESTS 31 Mass maintenance request definitions
GL_NET_INCOME_ACCOUNTS 12 Net income accounts
GL_OASIS_FIN_ASSIGNMENTS_11I 25 Natural account value mappings for financial items
GL_OASIS_FIN_ITEMS_11I 25 Financial items
GL_OASIS_FIN_METRICS_11I 15 Summarized financial metrics
GL_OASIS_SUMMARY_DATA 22 Summarized financial data needed for Business Intelligence System reports
GL_PERIODS 28 Calendar period definitions
GL_PERIOD_SETS 16 Calendar definitions
GL_PERIOD_STATUSES 30 Calendar period statuses
GL_PERIOD_TYPES 18 Calendar period types
GL_POSTING_INTERIM 61 Posting interim balances
GL_RECON_BALANCE 8
GL_RECURRING_BATCHES 34 Recurring journal entry and budget formula batches
GL_RECURRING_HEADERS 30 Recurring journal entry and budget formula headers
GL_RECURRING_LINES 23 Recurring journal entry and recurring budget formula target lines
GL_RECURRING_LINE_CALC_RULES 57 Recurring journal entry and budget formula lines
GL_REPORT_INTERFACE 8
GL_REVALUATIONS 95 Revaluation definitions
GL_REVAL_ACCOUNT_RANGES 84 Revaluation account ranges
GL_ROLLUP_GROUP_SCORES 6 Rollup group usages
GL_ROW_MULTIPLIERS 6 Constant row multipliers
GL_RX_TRIAL_BALANCE_ITF 25 Interface table for country-specific trial balance reports
GL_SEGMENT_FREQUENCIES 4 Segment value and period usages
GL_SEGVAL_INHERIT_HISTORY 11 Segment value inheritance history
GL_SEG_VAL_HIERARCHIES 10
GL_SEG_VAL_NORM_HIERARCHY 10
GL_SETS_OF_BOOKS_11I 69 Set of books definitions
GL_SHARES_ACTIVITY 27 Stock split or dividend
GL_SHARES_OUTSTANDING 29 Number of shares outstanding
GL_STAT_ACCOUNT_UOM 9 Statistical units of measure
GL_STORAGE_PARAMETERS 15 Interim table storage parameters
GL_SUMMARY_BC_OPTIONS 11
GL_SUMMARY_HIERARCHIES 12 Child segment value ranges for summary templates
GL_SUMMARY_HIERARCHY_INT 15 Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates
GL_SUMMARY_TEMPLATES 58 Summary account templates
GL_SUSPENSE_ACCOUNTS 15 Additional suspense accounts for source/category combinations
GL_SYSTEM_SETUP_11I 9 System setup information
GL_SYSTEM_USAGES 9 System feature usage
GL_TAX_OPTIONS 34 Setup tax options
GL_TAX_OPTION_ACCOUNTS 28 Setup tax options for natural account values
GL_TEMPORARY_COMBINATIONS 52 Newly created account combinations
GL_TRACK_DELTA_BALANCES 12 GL_TRACK_DELTA_BALANCES stores information about requests to track incremental balances using the GL_BALANCES_DELTA table.
GL_TRANSACTION_CALENDAR 32 Transaction calendar definitions
GL_TRANSACTION_DATES 25 Business vs. non-business days for transaction calendars
GL_TRANSLATION_INTERIM 55 Foreign currency translated interim balances
GL_TRANSLATION_RATES_11I 22 Foreign currency translation rates
GL_TRANSLATION_STATUSES 18 Foreign currency translation status of periods
GL_TRANSLATION_TRACKING 16 Foreign currency translation history
GL_UPDATE_RECOVERY_H 10 Updated columns history for update recovery
GL_UPGRADE_STATUS 2
GL_USSGL_ACCOUNT_PAIRS 25 USSGL account pairings
GL_USSGL_TRANSACTION_CODES 28 USSGL transaction codes
GL_XFR_CALENDARS 32
GL_XFR_CALENDAR_MAPPINGS 12 This table is used to store calendar mappings between EBS and Fusion ledger.
GL_XFR_CCID_MAPPINGS 9 This table contains the account mappings for each period for a ledger mapping.
GL_XFR_INTERFACE 140 This table is a custom version of the gl_interface table for use by the balance transfer.
GL_XFR_LEDGERS 110
GL_XFR_LEDGER_BSV_MAPS 10 Stores specific Balancing segment values of a Fusion Ledger that can be used for booking balances by the external instances.
GL_XFR_LEDGER_MAPPINGS 13 This table is used to store ledger mappings between EBS and Fusion ledger.
GL_XFR_LED_MAP_PERIODS 11 This table contains the transfer information for each period that has been transferred for a ledger mapping.
GL_XFR_PERIODS 29
GL_XFR_PERIOD_MAPPINGS 9 Uses Calendar Mapping Id and stores mapping between EBS periods to Fusion Periods.
GL_XFR_REJECTED_BSVS_GT 1
GL_XFR_SOURCE_SYSTEMS 12 Stores the list of External Instances with URL info that will be used to drill down from Fusion GL balances to the external instance
GL_XFR_SYSTEM_LEDGERS 10 Stores the list of Fusion Ledgers with their corresponding BSV assignment type.
GL_XFR_TRACKING 13 This table contains the tracking information that Golden Gate will use to launch Journal Import.