Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

2Apr/150

General Ledger tables

These are the general ledger module tables and the purpose they are used for

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_HISTORY History of MassAllocation and MassBudget runs
GL_ALLOC_INTERIM_1 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_DAILY_BALANCES Archive daily aggregate balances
GL_ARCHIVE_HEADERS Archive journal headers
GL_ALLOC_INTERIM_2 Temporary table for MassAllocations and MassBudgets
GL_ALLOC_FORMULAS MassAllocations and MassBudget formulas
GL_ALLOC_INTERIM_3 Temporary table for MassAllocations and MassBudgets
GL_ALLOC_FORMULA_LINES MassAllocations and MassBudget formula lines
GL_ARCHIVE_BATCHES Archive journal batches
GL_ARCHIVE_BALANCES Archive account balances
GL_ARCHIVE_LINES Archive journal entry lines
GL_ARCHIVE_HISTORY History of the archive and purges of journals and balances
GL_AUTOMATIC_POSTING_OPTIONS Individual automatic posting criteria
GL_AUTOMATIC_POSTING_SETS Sets of automatic posting criteria
GL_ARCHIVE_REFERENCES Archive table for GL_IMPORT_REFERENCES
GL_AUTHORIZATION_LIMITS Journal approval authorization limits for employees
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_AUTOREV_CRITERIA_SETS Journal reversal criteria sets
GL_AUTOREVERSE_OPTIONS Reversal criteria for generating automatic journal reversals
GL_AUTO_ALLOC_BAT_HIST_DET Status of concurrent program submitted for each step in the allocation set
GL_AUTO_ALLOC_SETS Autoallocation set definition for step-down or parallel allocations
GL_AUTO_ALLOC_SET_HISTORY History of allocation set runs
GL_AUTO_ALLOC_REV_BATCHES Reverse journal batches generated by AutoAllocation rollback process
GL_BC_DUAL2 Budgetary control concurrency table
GL_BC_EVENT_TIMESTAMPS Budgetary control events (Summary Templates and Budget Assignment Ranges)
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_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_BUDGETS Budget definitions
GL_BUDGET_ASSIGNMENTS Budget organization accounts
GL_BC_PACKET_ARRIVAL_ORDER Budgetary control packet processing sequence
GL_BUDGET_ENTITIES Budget organization definitions
GL_BC_PERIOD_MAP Budgetary control period boundaries
GL_BUDGET_FROZEN_RANGES Frozen account ranges for a budget or budget organization
GL_BUDGET_INTERFACE Upload budget data from external sources
GL_BUDGET_ASSIGNMENT_RANGES Budget organization account ranges
GL_BUDGET_BATCHES Budget formula batches
GL_BUDGET_INTERIM Budget posting interim balances
GL_BUDGET_TYPES Budget type definitions
GL_BUDGET_PERIOD_RANGES Status of budget period ranges (open/not open)
GL_CARRYFORWARD_RANGES Ranges of encumbrance accounts to carry across fiscal years
GL_BUDGET_RANGE_INTERIM Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms
GL_CONCURRENCY_CONTROL Concurrent process internal locking mechanism
GL_BUDGET_VERSIONS Budget version definitions
GL_CONCURRENT_SCHEDULES Oracle General Ledger concurrent schedule definitions
GL_COA_MAPPINGS Chart of accounts mapping definitions
GL_CONSOLIDATION_SETS Consolidation sets
GL_CONS_BATCHES Transaction method consolidation batches
GL_CONSOLIDATION Consolidation definitions
GL_CONSOLIDATION_ACCOUNTS Account ranges for consolidating balances
GL_CONSOLIDATION_AUDIT Audit data for consolidation run
GL_CONS_SEGMENT_MAP Consolidation segment rules
GL_CONS_SET_ASSIGNMENTS Assignments of consolidations to consolidation sets
GL_CONSOLIDATION_HISTORY History of consolidation runs
GL_CONS_FLEXFIELD_MAP Consolidation account rules
GL_CONS_FLEX_HIERARCHIES Consolidation subsidiary segment hierarchies
GL_DAILY_BALANCES Daily aggregate balances for both detail and summary accounts
GL_DAILY_CONVERSION_RATES Foreign currency daily exchange rates
GL_CROSS_RATE_RULES Cross Rate Rules
GL_DAILY_RATES_INTERFACE Import daily conversion rates
GL_DATE_PERIOD_MAP Date to period mappings
GL_CROSS_RATE_RULE_DTLS Cross Rate Rule Details
GL_DEFAS_ACCESS_SETS Definition access set definitions
GL_DEFAS_ASSIGNMENTS Definition access set privilege assignments
GL_DAILY_RATES Daily conversion rates for foreign currency transactions
GL_CODE_COMBINATIONS Account combinations
GL_DAILY_CONVERSION_TYPES Foreign currency daily conversion rate types
GL_DEFAS_RESP_ASSIGN Assignment of definition access sets to responsibilities
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_DOC_SEQUENCE_AUDIT Sequential numbering audit table
GL_DYNAMIC_SUMM_COMBINATIONS Newly created summary account combinations
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_ELIM_ACCOUNTS_MAP Intercompany elimination account mappings
GL_ENTITY_BUDGETS Freeze budget organizations for particular budgets
GL_FIXED_CONV_RATES Fixed conversion rates for changes in national currency
GL_ELIMINATION_SETS Intercompany elimination set definitions
GL_ELIM_BAL_OPTIONS Intercompany elimination balancing options.
GL_HISTORICAL_RATE_RANGES Historical translation rates account ranges
GL_ENCUMBRANCE_TYPES Encumbrance type definitions
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_IEA_AUTOGEN_MAP Automatic account generation mapping rules for the Global Intercompany System
GL_HISTORICAL_RATES Foreign currency translation rates for historical accounts
GL_IEA_CLEARING_ACCOUNTS Clearing accounts
GL_IEA_INTERFACE Transactional data for import into Global Intercompany System
GL_IEA_RECUR_HISTORY History of recurring intercompany batch runs
GL_IEA_SEGMENT_RULE_MAP Automatic account generation individual segment mapping rules for the Global Intercompany System
GL_IEA_SEGMENT_MAP Automatic account generation segment mapping rules for the Global Intercompany System
GL_IEA_IMPORT_REGISTRY Global Intercompany System import execution control
GL_IEA_SUBSIDIARIES Subsidiary definitions
GL_IEA_RECUR_BATCHES Recurring intercompany batches
GL_IEA_RECUR_LINES Recurring intercompany transaction lines
GL_IEA_RECUR_TRANSACTIONS Recurring intercompany transactions
GL_IEA_TRANSACTIONS Intercompany transactions
GL_IEA_TRANSACTION_LINES Intercompany transaction lines
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_SEG_VAL_INTERFACE 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_IEA_TRANSACTION_TYPES Intercompany transaction types
GL_INTERFACE_CONTROL Journal import execution control
GL_IMP_COA_NORM_HIER_INTERFACE Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.
GL_ISPEED_COA_SEGMENTS Chart of Accounts segments information.
GL_INTERCOMPANY_ACC_SETS Intercompany transaction processing rules
GL_ISPEED_COA_TEMPLATES Chart of Accounts template definition.
GL_INTERFACE Import journal entry batches
GL_INTERFACE_HISTORY Imported journal entry batches
GL_JE_INCLUSION_RULES Journal Inclusion rule
GL_JE_SEGMENT_VALUES Journal entry balancing and management segment values.
GL_JE_SOURCES_TL Journal entry sources
GL_JE_CATEGORIES_TL Journal entry categories
GL_JE_HEADERS Journal entry headers
GL_JE_LINES Journal entry lines
GL_JE_BATCHES Journal entry batches
GL_JOURNAL_REPORTS_ITF Interface table for RXi Oracle General Ledger journal reports.
GL_LEDGERS Ledger definition
GL_LEDGER_CONFIG_DETAILS Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup.
GL_LEDGER_NORM_SEG_VALS Valid balancing segment values for ledger
GL_LEDGER_SETS Ledger set definition
GL_LEDGER_CONFIGURATIONS Primary ledgers
GL_LEDGER_SET_NORM_ASSIGN Ledger set assignments
GL_LEDGER_RELATIONSHIPS Relationships between ledgers
GL_LEDGER_SEGMENT_VALUES Flattened valid balancing segment values for ledger
GL_LEDGER_SET_ASSIGNMENTS Flattened ledger set assignments
GL_LEDGER_SET_REQUESTS Ledger set child request status.
GL_LEGAL_ENTITIES_BSVS Legal entity balancing segment value assignments.
GL_LOOKUPS_OLD General Ledger lookups
GL_LE_VALUE_SETS Legal entity value set assignments.
GL_MC_BOOK_ASSIGNMENTS 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_BOOK_ASSIGNMENTS_11I Assignments of reporting sets of books to primary sets of books
GL_MC_UPGRADE_RATES Exchange rates used for the multiple reporting currency upgrade programs
GL_MC_UPGRADE_HISTORY History of upgrade for each application and reporting set of books
GL_MC_REPORTING_OPTIONS_11I Multiple reporting currency conversion options by application/operating unit/asset book
GL_MGT_SEG_UPGRADE Management segment upgrade unprocessed journal batches.
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_MGT_SEG_UPGRADE_H History of management segment upgrade.
GL_MOVEMERGE_ACCOUNTS Mass maintenance request account mappings
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_MOVEMERGE_REQUESTS Mass maintenance request definitions
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_RECURRING_BATCHES Recurring journal entry and budget formula batches
GL_RECURRING_HEADERS Recurring journal entry and budget formula headers
GL_REVALUATION Revaluation default gain/loss account
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_REVALUATIONS Revaluation definitions
GL_REVALUATION_ACCOUNTS 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_REVAL_ACCOUNT_RANGES Revaluation account ranges
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_SETS_OF_BOOKS Set of books definitions
GL_SUMMARY_HIERARCHY_INT Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates
GL_SUMMARY_INTERIM Temporary table for Summarization
GL_SETS_OF_BOOKS_11I Set of books definitions
GL_SUMMARY_HIERARCHIES Child segment value ranges for summary templates
GL_SYSTEM_SETUP System setup information
GL_SUMMARY_TEMPLATES Summary account templates
GL_SYSTEM_SETUP_11I System setup information
GL_SYSTEM_USAGES System feature usage
GL_SUSPENSE_ACCOUNTS Additional suspense accounts for source/category combinations
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_DATES Business vs. non-business days for transaction calendars
GL_TRANSACTION_CALENDAR Transaction calendar definitions
GL_TRANSACTION_RATE_EXCEPTIONS No longer used
GL_UPDATE_RECOVERY_H Updated columns history for update recovery
GL_TRANSLATION_RATES Foreign currency translation rates
GL_TRANSLATION_INTERIM Foreign currency translated interim balances
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_USSGL_ACCOUNT_PAIRS USSGL account pairings
GL_USSGL_TRANSACTION_CODES USSGL transaction codes
GL_XFR_CALENDAR_MAPPINGS This table is used to store calendar mappings between EBS and Fusion ledger.
GL_XFR_CCID_MAPPINGS This table contains the account mappings for each period for a ledger mapping.
GL_XFR_INTERFACE This table is a custom version of the gl_interface table for use by the balance transfer.
GL_WEIGHTED_AVG_DETAILS No longer used
GL_XFR_LEDGER_BSV_MAPS Stores specific Balancing segment values of a Fusion Ledger that can be used for booking balances by the external instances.
GL_XFR_LED_MAP_PERIODS This table contains the transfer information for each period that has been transferred for a ledger mapping.
GL_XFR_PERIOD_MAPPINGS Uses Calendar Mapping Id and stores mapping between EBS periods to Fusion Periods.
GL_XFR_LEDGER_MAPPINGS This table is used to store ledger mappings between EBS and Fusion ledger.
GL_XFR_SOURCE_SYSTEMS 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 Stores the list of Fusion Ledgers with their corresponding BSV assignment type.
GL_XFR_TRACKING This table contains the tracking information that Golden Gate will use to launch Journal Import.
Filed under: General Ledger No Comments
25Oct/130

Terms and Definitions Used in Intercompany Accounting

Intercompany Journal
This is a journal entry which has transactions for at least
two different companies (or balancing segment values).

Intercompany Journal Out of Balance
An out of balance intercompany journal is one which does not have equal
credit and debit totals for each group of lines by company.

Balancing Segment
This is the accounting flexfield segment that has the balancing segment
qualifier assigned to it. Typically the balancing segment stores the company
values. However, it could represent the cost center, the department or some
other values.
The terms balancing segment and company segment are usually interchangeable.
It is mandatory that one segment of your accounting flexfield be designated
as the balancing segment.

Intercompany Segment
The intercompany segment is the accounting flexfield segment that has
the intercompany segment qualifier assigned to it. This qualifier is only
available in release 11i and is optional. This segment shares the same
value set as the balancing segment.

Clearing Account
A clearing account is a temporary account that holds amounts to be
transferred to another account.

Clearing Company
This is the company value used to clear payables or receivables transactions.
General Ledger uses this company to balance intercompany transactions.

Trading Partner
Trading partner is the company against which the line transaction is made.

Transaction Types
Transactions types are the classifications for journal entries based on
the number of companies involved in the credit and debit side
of the transaction.

The different transaction types are:

One to One: Two different companies in the journal. One company
has the net debit balance and the other has a net credit balance.

Many to One: Different companies have net debit balance and one
company has net credit balance.

One to Many: One Company has net debit balance and more than one
companies have net credit balance.

Many to Many: Two or more companies have net debit balance and
two or more companies have net credit balance.

Filed under: General Ledger No Comments
22May/120

RECURRING JOURNALS

RECURRING JOURNALS are the entries which are posted every period like monthly rent, utility bills etc..

Filed under: General Ledger Continue reading
22May/120

JOURNAL APPROVAL

Journal Approval feature is used to ensure that journal entries and batches are approved by appropriate management personnel before the journals can be posted to your account balances

Filed under: General Ledger Continue reading
22May/120

AUTO POST in GL

Auto Post is a process in GL that enables users to post Journal Entries automatically once they are created in GL.

Filed under: General Ledger Continue reading
22May/120

ROLL UP GROUPS IN GL

• Defining rollup groups allows a little more flexibility in your summary templates. Rollup groups provide a form of intermediate information and are a collection of parent values.

Filed under: General Ledger Continue reading
22May/120

SUMMARY ACCOUNTS IN GL

•SUMMARY ACCOUNTS –

–A summary account is an account whose balance is the sum of balances of multiple detail accounts. Summary accounts are used to perform online summary inquiries, as well as speed the processing of financial reports, Mass Allocations, and recurring journal formulas. Summary Templates are used to create summary accounts.

Filed under: General Ledger Continue reading
22May/120

TRANSLATION IN GL

Translation is the process of translating account balances from your functional currency to another currency. This process translates balances only, it does not translate individual transactions.

Filed under: General Ledger Continue reading
22May/120

GL TERMINOLOGY

Below are few of the buzz words in GL and what they signify –

1.Ledger – A financial reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Oracle General Ledger secures transaction information (journal entries, balances) by Ledgers. When you use Oracle General Ledger, you choose a responsibility that specifies a Ledger. You then see information for that Ledger only.

–Formerly called Set of Book in R11i. Ledger is an accounting book.

Filed under: General Ledger Continue reading
22May/120

JOURNAL IMPORT

Accounting transactions are originated as a result of normal business activities in Financial and Manufacturing modules of Oracle Applications, as well as in external modules. In order to register those transactions into the

Filed under: General Ledger Continue reading

Recent Posts

Recent Comments

Archives

Categories