Wednesday, 6 November 2013

General Ledger Tables in R12

TABLE NAME
TABLE DESCRIPTION
GL_ACCESS_SETS
Data access set definitions
GL_ACCESS_SET_ASSIGNMENTS
Flattened data access set privilege assignments
GL_ACCESS_SET_NORM_ASSIGN
Data access set privilege assignments
GL_ACCOUNT_HIERARCHIES
Summary/Detail account hierarchies
GL_ALLOC_BATCHES
MassAllocations and MassBudget batches
GL_ALLOC_FORMULAS
MassAllocations and MassBudget formulas
GL_ALLOC_FORMULA_LINES
MassAllocations and MassBudget formula lines
GL_ALLOC_HISTORY
History of MassAllocation and MassBudget runs
GL_ALLOC_INTERIM_1
Temporary table for MassAllocations and MassBudgets
GL_ALLOC_INTERIM_2
Temporary table for MassAllocations and MassBudgets
GL_ALLOC_INTERIM_3
Temporary table for MassAllocations and MassBudgets
GL_ALLOC_TARGETS
Temporary table for MassAllocations and MassBudgets
GL_APPLICATION_GROUPS
Application product groups that use Oracle General Ledger accounting periods
GL_ARCHIVE_BALANCES
Archive account balances
GL_ARCHIVE_BATCHES
Archive journal batches
GL_ARCHIVE_DAILY_BALANCES
Archive daily aggregate balances
GL_ARCHIVE_HEADERS
Archive journal headers
GL_ARCHIVE_HISTORY
History of the archive and purges of journals and balances
GL_ARCHIVE_LINES
Archive journal entry lines
GL_ARCHIVE_REFERENCES
Archive table for GL_IMPORT_REFERENCES
GL_AUTHORIZATION_LIMITS
Journal approval authorization limits for employees
GL_AUTOMATIC_POSTING_OPTIONS
Individual automatic posting criteria
GL_AUTOMATIC_POSTING_SETS
Sets of automatic posting criteria
GL_AUTOREVERSE_OPTIONS
Reversal criteria for generating automatic journal reversals
GL_AUTOREV_CRITERIA_SETS
Journal reversal criteria sets
GL_AUTO_ALLOC_BATCHES
Assignments of MassAllocation, Mass Budgets, Mass Encumbrances,  Recurring Journals or Projects batches to an allocation set
GL_AUTO_ALLOC_BATCH_HISTORY
History of all batches included in an allocation set run
GL_AUTO_ALLOC_BAT_HIST_DET
Status of concurrent program submitted for each step in the allocation set
GL_AUTO_ALLOC_REV_BATCHES
Reverse journal batches generated by AutoAllocation rollback process
GL_AUTO_ALLOC_SETS
Autoallocation set definition for step-down or parallel allocations
GL_AUTO_ALLOC_SET_HISTORY
History of allocation set runs
GL_BALANCES
Account balances for both detail and summary accounts
GL_BALANCES_DELTA
Incremental changes to account balances
GL_BALANCES_DELTA_INTERIM
Interim tracking of incremental account balances
GL_BC_DUAL
Budgetary control concurrency table
GL_BC_DUAL2
Budgetary control concurrency table
GL_BC_EVENT_TIMESTAMPS
Budgetary control events (Summary Templates and Budget Assignment Ranges)
GL_BC_OPTIONS
Budgetary control options
GL_BC_OPTION_DETAILS
Budgetary control option details
GL_BC_PACKETS
Budgetary control queue table
GL_BC_PACKETS_HISTS
GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS.
GL_BC_PACKET_ARRIVAL_ORDER
Budgetary control packet processing sequence
GL_BC_PERIOD_MAP
Budgetary control period boundaries
GL_BUDGETS
Budget definitions
GL_BUDGET_ASSIGNMENTS
Budget organization accounts
GL_BUDGET_ASSIGNMENT_RANGES
Budget organization account ranges
GL_BUDGET_BATCHES
Budget formula batches
GL_BUDGET_ENTITIES
Budget organization definitions
GL_BUDGET_FROZEN_RANGES
Frozen account ranges for a budget or budget organization
GL_BUDGET_INTERFACE
Upload budget data from external sources
GL_BUDGET_INTERIM
Budget posting interim balances
GL_BUDGET_PERIOD_RANGES
Status of budget period ranges (open/not open)
GL_BUDGET_RANGE_INTERIM
Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms
GL_BUDGET_TYPES
Budget type definitions
GL_BUDGET_VERSIONS
Budget version definitions
GL_BUDORG_BC_OPTIONS

GL_BUD_DOWNLOAD_GT

GL_CAPTURED_INFO

GL_CARRYFORWARD_RANGES
Ranges of encumbrance accounts to carry across fiscal years
GL_COA_MAPPINGS
Chart of accounts mapping definitions
GL_CODE_COMBINATIONS
Account combinations
GL_CONCURRENCY_CONTROL
Concurrent process internal locking mechanism
GL_CONCURRENT_SCHEDULES
Oracle General Ledger concurrent schedule definitions
GL_CONSOLIDATION
Consolidation definitions
GL_CONSOLIDATION_ACCOUNTS
Account ranges for consolidating balances
GL_CONSOLIDATION_AUDIT
Audit data for consolidation run
GL_CONSOLIDATION_HISTORY
History of consolidation runs
GL_CONSOLIDATION_SETS
Consolidation sets
GL_CONS_BATCHES
Transaction method consolidation batches
GL_CONS_FLEXFIELD_MAP
Consolidation account rules
GL_CONS_FLEX_HIERARCHIES
Consolidation subsidiary segment hierarchies
GL_CONS_SEGMENT_MAP
Consolidation segment rules
GL_CONS_SET_ASSIGNMENTS
Assignments of consolidations to consolidation sets
GL_CROSS_RATE_RULES
Cross Rate Rules
GL_CROSS_RATE_RULE_DTLS
Cross Rate Rule Details
GL_DAILY_BALANCES
Daily aggregate balances for both detail and summary accounts
GL_DAILY_CONVERSION_RATES
Foreign currency daily exchange rates
GL_DAILY_CONVERSION_TYPES
Foreign currency daily conversion rate types
GL_DAILY_RATES
Daily conversion rates for foreign currency transactions
GL_DAILY_RATES_INTERFACE
Import daily conversion rates
GL_DATE_PERIOD_MAP
Date to period mappings
GL_DEFAS_ACCESS_SETS
Definition access set definitions
GL_DEFAS_ASSIGNMENTS
Definition access set privilege assignments
GL_DEFAS_RESP_ASSIGN
Assignment of definition access sets to responsibilities
GL_DOC_SEQUENCE_AUDIT
Sequential numbering audit table
GL_DRILL_ACCOUNT_RANGES_GT

GL_DYNAMIC_SUMM_COMBINATIONS
Newly created summary account combinations
GL_EFC_BUDGET_MAPPING
Budget and budget organization mappings for Euro as Functional Currency process
GL_EFC_CHANGED_TRX
Transactions that need to be reprocessed by the Euro as Functional Currency process
GL_EFC_DISABLED_TRIGGERS
Triggers disabled by the Euro as Functional Currency process
GL_EFC_RUN_HISTORY
Euro as Functional Currency process history
GL_ELIMINATION_HISTORY
Intercompany elimination history
GL_ELIMINATION_JOURNALS
Intercompany elimination journals
GL_ELIMINATION_SETS
Intercompany elimination set definitions
GL_ELIM_ACCOUNTS_MAP
Intercompany elimination account mappings
GL_ELIM_BAL_OPTIONS
Intercompany elimination balancing options.
GL_ENCUMBRANCE_TYPES
Encumbrance type definitions
GL_ENTITY_BUDGETS
Freeze budget organizations for particular budgets
GL_EXTRACT_HISTORY
Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract Incremental Balances
GL_FIXED_CONV_RATES
Fixed conversion rates for changes in national currency
GL_HISTORICAL_RATES
Foreign currency translation rates for historical accounts
GL_HISTORICAL_RATE_RANGES
Historical translation rates account ranges
GL_IEA_AUTOGEN_MAP
Automatic account generation mapping rules for the Global Intercompany System
GL_IEA_CLEARING_ACCOUNTS
Clearing accounts
GL_IEA_IMPORT_REGISTRY
Global Intercompany System import execution control
GL_IEA_INTERFACE
Transactional data for import into Global Intercompany System
GL_IEA_RECUR_BATCHES
Recurring intercompany batches
GL_IEA_RECUR_HISTORY
History of recurring intercompany batch runs
GL_IEA_RECUR_LINES
Recurring intercompany transaction lines
GL_IEA_RECUR_TRANSACTIONS
Recurring intercompany transactions
GL_IEA_SEGMENT_MAP
Automatic account generation segment mapping rules for the Global Intercompany System
GL_IEA_SEGMENT_RULE_MAP
Automatic account generation individual segment mapping rules for the Global Intercompany System
GL_IEA_SUBSIDIARIES
Subsidiary definitions
GL_IEA_TRANSACTIONS
Intercompany transactions
GL_IEA_TRANSACTION_LINES
Intercompany transaction lines
GL_IEA_TRANSACTION_TYPES
Intercompany transaction types
GL_IMPORT_REFERENCES
Cross-references between subledgers and Oracle General Ledger's journal entries
GL_IMP_COA_ERR_INTERFACE
Error message interface table for the Chart of Account Segment Values Import process.
GL_IMP_COA_NORM_HIER_INTERFACE
Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.
GL_IMP_COA_SEG_VAL_INTERFACE
Interface table to capture data for the import of Chart of Accounts Segment Values.
GL_INTERCOMPANY_ACCOUNTS
Assignments of intercompany due to and due from accounts to a source, category, and balancing segment value.
GL_INTERCOMPANY_ACC_SETS
Intercompany transaction processing rules
GL_INTERFACE
Import journal entry batches
GL_INTERFACE_CONTROL
Journal import execution control
GL_INTERFACE_HISTORY
Imported journal entry batches
GL_ISPEED_COA_SEGMENTS
Chart of Accounts segments information.
GL_ISPEED_COA_TEMPLATES
Chart of Accounts template definition.
GL_JE_BATCHES
Journal entry batches
GL_JE_CATEGORIES_TL
Journal entry categories
GL_JE_HEADERS
Journal entry headers
GL_JE_INCLUSION_RULES
Journal Inclusion rule
GL_JE_LINES
Journal entry lines
GL_JE_LINES_RECON

GL_JE_SEGMENT_VALUES
Journal entry balancing and management segment values.
GL_JE_SEGVALS_UPGRADE

GL_JE_SOURCES_TL
Journal entry sources
GL_JOURNAL_REPORTS_ITF
Interface table for RXi Oracle General Ledger journal reports.
GL_LEDGERS
Ledger definition
GL_LEDGER_BSV_GT

GL_LEDGER_CONFIGURATIONS
Primary ledgers
GL_LEDGER_CONFIG_DETAILS
Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup.
GL_LEDGER_LE_BSV_GT

GL_LEDGER_NORM_SEG_VALS
Valid balancing segment values for ledger
GL_LEDGER_RELATIONSHIPS
Relationships between ledgers
GL_LEDGER_SEGMENT_VALUES
Flattened valid balancing segment values for ledger
GL_LEDGER_SETS
Ledger set definition
GL_LEDGER_SET_ASSIGNMENTS
Flattened ledger set assignments
GL_LEDGER_SET_NORM_ASSIGN
Ledger set assignments
GL_LEDGER_SET_REQUESTS
Ledger set child request status.
GL_LEGAL_ENTITIES_BSVS
Legal entity balancing segment value assignments.
GL_LE_VALUE_SETS
Legal entity value set assignments.
GL_LOOKUPS_OLD
General Ledger lookups
GL_MC_BOOK_ASSIGNMENTS
Assignments of reporting sets of books to primary sets of books
GL_MC_BOOK_ASSIGNMENTS_11I
Assignments of reporting sets of books to primary sets of books
GL_MC_CONVERSION_RULES
Multiple reporting currency conversion rules for Oracle General Ledger
GL_MC_CONVERSION_RULES_11I
Multiple reporting currency conversion rules for Oracle General Ledger
GL_MC_REPORTING_OPTIONS
Multiple reporting currency conversion options by application
GL_MC_REPORTING_OPTIONS_11I
Multiple reporting currency conversion options by application/operating unit/asset book
GL_MC_UPGRADE_HISTORY
History of upgrade for each application and reporting set of books
GL_MC_UPGRADE_RATES
Exchange rates used for the multiple reporting currency upgrade programs
GL_MGT_SEG_UPGRADE
Management segment upgrade unprocessed journal batches.
GL_MGT_SEG_UPGRADE_H
History of management segment upgrade.
GL_MOVEMERGE_ACCOUNTS
Mass maintenance request account mappings
GL_MOVEMERGE_REQUESTS
Mass maintenance request definitions
GL_NET_INCOME_ACCOUNTS
Net income accounts
GL_OASIS_FIN_ASSIGNMENTS
Natural account value mappings for financial items
GL_OASIS_FIN_ASSIGNMENTS_11I
Natural account value mappings for financial items
GL_OASIS_FIN_ITEMS
Financial items
GL_OASIS_FIN_ITEMS_11I
Financial items
GL_OASIS_FIN_METRICS
The new table stores the summarized financial metrics.
GL_OASIS_FIN_METRICS_11I
Summarized financial metrics
GL_OASIS_SUMMARY_DATA
Summarized financial data needed for Business Intelligence System reports
GL_PERIODS
Calendar period definitions
GL_PERIOD_SETS
Calendar definitions
GL_PERIOD_STATUSES
Calendar period statuses
GL_PERIOD_TYPES
Calendar period types
GL_POSTING_INTERIM
Posting interim balances
GL_RECON_BALANCE

GL_RECURRING_BATCHES
Recurring journal entry and budget formula batches
GL_RECURRING_HEADERS
Recurring journal entry and budget formula headers
GL_RECURRING_LINES
Recurring journal entry and recurring budget formula target lines
GL_RECURRING_LINE_CALC_RULES
Recurring journal entry and budget formula lines
GL_REPORT_INTERFACE

GL_REVALUATION
Revaluation default gain/loss account
GL_REVALUATIONS
Revaluation definitions
GL_REVALUATION_ACCOUNTS
Revaluation account ranges
GL_REVAL_ACCOUNT_RANGES
Revaluation account ranges
GL_ROLLUP_GROUP_SCORES
Rollup group usages
GL_ROW_MULTIPLIERS
Constant row multipliers
GL_RX_TRIAL_BALANCE_ITF
Interface table for country-specific trial balance reports
GL_SEGMENT_FREQUENCIES
Segment value and period usages
GL_SEGVAL_INHERIT_HISTORY
Segment value inheritance history
GL_SEG_VAL_HIERARCHIES

GL_SEG_VAL_NORM_HIERARCHY

GL_SETS_OF_BOOKS
Set of books definitions
GL_SETS_OF_BOOKS_11I
Set of books definitions
GL_SHARES_ACTIVITY
Stock split or dividend
GL_SHARES_OUTSTANDING
Number of shares outstanding
GL_STAT_ACCOUNT_UOM
Statistical units of measure
GL_STORAGE_PARAMETERS
Interim table storage parameters
GL_SUMMARY_BC_OPTIONS

GL_SUMMARY_HIERARCHIES
Child segment value ranges for summary templates
GL_SUMMARY_HIERARCHY_INT
Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates
GL_SUMMARY_INTERIM
Temporary table for Summarization
GL_SUMMARY_TEMPLATES
Summary account templates
GL_SUSPENSE_ACCOUNTS
Additional suspense accounts for source/category combinations
GL_SYSTEM_SETUP
System setup information
GL_SYSTEM_SETUP_11I
System setup information
GL_SYSTEM_USAGES
System feature usage
GL_TAX_CODES

GL_TAX_OPTIONS
Setup tax options
GL_TAX_OPTION_ACCOUNTS
Setup tax options for natural account values
GL_TEMPORARY_COMBINATIONS
Newly created account combinations
GL_TRACK_DELTA_BALANCES
GL_TRACK_DELTA_BALANCES stores information about requests to track incremental balances using the GL_BALANCES_DELTA table.
GL_TRANSACTION_CALENDAR
Transaction calendar definitions
GL_TRANSACTION_DATES
Business vs. non-business days for transaction calendars
GL_TRANSACTION_RATE_EXCEPTIONS
No longer used
GL_TRANSLATION_INTERIM
Foreign currency translated interim balances
GL_TRANSLATION_RATES
Foreign currency translation rates
GL_TRANSLATION_RATES_11I
Foreign currency translation rates
GL_TRANSLATION_STATUSES
Foreign currency translation status of periods
GL_TRANSLATION_TRACKING
Foreign currency translation history
GL_UPDATE_RECOVERY_H
Updated columns history for update recovery
GL_UPGRADE_STATUS

GL_USSGL_ACCOUNT_PAIRS
USSGL account pairings
GL_USSGL_TRANSACTION_CODES
USSGL transaction codes
GL_WEIGHTED_AVG_DETAILS
No longer used
RG_DATABASE_LINKS
Database link definitions
RG_DSS_DIMENSIONS
Financial Analyzer dimensions
RG_DSS_DIM_SEGMENTS
Financial Analyzer dimension segment mappings
RG_DSS_HIERARCHIES
Financial Analyzer hierarchies
RG_DSS_HIERARCHY_DETAILS
Financial Analyzer hierarchy segment mappings
RG_DSS_REQUESTS
Financial Analyzer extract/load request tracking
RG_DSS_SEG_RANGES
Segment ranges for filters
RG_DSS_SEG_RANGE_SETS
Filters
RG_DSS_SYSTEMS
Financial Analyzer financial data sets
RG_DSS_SYSTEM_SEG_ORDER
Financial Analyzer financial data set segment sort order
RG_DSS_SYSTEM_VARIABLES
Assignments of financial data items to financial data sets
RG_DSS_VARIABLES
Financial Analyzer financial data items
RG_DSS_VAR_DIMENSIONS
Financial Analyzer financial data item dimensions
RG_DSS_VAR_SELECTIONS
Financial Analyzer financial data item selections
RG_DSS_VAR_TEMPLATES
Financial Analyzer financial data item summary templates
RG_LOOKUPS_OLD
Standard lookup codes
RG_REPORTS
Report definitions
RG_REPORT_AXES
Row and column definitions
RG_REPORT_AXIS_CONTENTS
Assignments of account ranges to rows and columns
RG_REPORT_AXIS_SETS
Row and column set definitions
RG_REPORT_CALCULATIONS
Calculations defined for rows and columns
RG_REPORT_CONTENT_OVERRIDES
Assignments of account ranges to content sets
RG_REPORT_CONTENT_SETS
Content set definitions
RG_REPORT_DISPLAYS
Assignments of report display groups to report display sets
RG_REPORT_DISPLAY_GROUPS
Report display group definitions
RG_REPORT_DISPLAY_SETS
Report display set definitions
RG_REPORT_EXCEPTIONS
Exception conditions for columns
RG_REPORT_EXCEPTION_FLAGS
Symbols used to indicate exceptions
RG_REPORT_PARAMETERS
Assignments of budgets, encumbrances, and currencies to reports
RG_REPORT_REQUESTS
Report request tracking and assignments of reports to report sets
RG_REPORT_REQUEST_LOBS
RG_REPORT_REQUEST_LOBS stores the XML output associated with each Financial Statement Generator request that is run in XML mode.  The XML output is used for drilldown purposes
RG_REPORT_SETS
Report set definitions
RG_REPORT_SET_REQUESTS
RG_REPORT_SET_REQUESTS tracks submission of report sets.  It stores the report set that was submitted, the it was submitted, and who it was submitted by.  If the report set was submitted using the Multiple Report Sets tab in the Run Financi
RG_REPORT_SET_REQ_DETAILS
RG_REPORT_SET_REQ_DETAILS tracks the individual reports that were run for each report set submission.  There will be one row in this table for each report run as part of a report set submission.
RG_REPORT_STANDARD_AXES
Amount types used in rows and columns
RG_REPORT_STANDARD_AXES_B
Amount types used in rows and columns
RG_REPORT_STANDARD_AXES_TL
Translations for RG_REPORT_STANDARD_AXES
RG_REPORT_SUB_REQUEST_RUNS
Sub request information for parallel content sets
RG_ROW_ORDERS
Row order definitions
RG_ROW_SEGMENT_SEQUENCES
Assignments of segments to row orders
RG_SIMPLE_WHERE_CLAUSES
Query information for specific amount types
RG_TABLE_SIZES
Sizes of selected Oracle General Ledger tables
RG_XBRL_ELEMENTS

RG_XBRL_MAP_ELEMENTS
Elements mapped to taxonomy
RG_XBRL_TAXONOMIES