GL Views (279)

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

ViewDescription
GLBV_ACTUAL_BALANCES
GLBV_ACTUAL_JOURNAL_BATCHES
GLBV_ACTUAL_JOURNAL_ENTRIES
GLBV_BUDGET_BALANCES
GLBV_BUDGET_JOURNAL_BATCHES Budget journal batches are groups of journal entries that represent the estimated results of future financial operations.
GLBV_BUDGET_JOURNAL_ENTRIES Budget journal entries are groups of journal lines that represent the estimated results of future financial operations.
GLBV_CHARTS_OF_ACCOUNTS
GLBV_CURRENCIES
GLBV_ENCUMBRANCE_BALANCES
GLBV_ENCUMB_JOURNAL_BATCHES
GLBV_ENCUMB_JOURNAL_ENTRIES
GLBV_GLOBAL_INTERCO_SUBS
GLBV_GLOBAL_INTERCO_TRANS
GLBV_GLOBAL_INTERCO_TRAN_LINES
GLBV_GL_ACCOUNTING_CALENDARS
GLBV_GL_ACCOUNTS
GLBV_GL_AVERAGE_BALANCES
GLBV_GL_BUDGETS
GLBV_GL_BUDGET_ASSIGNMENTS
GLBV_GL_BUDGET_ORGANIZATIONS
GLBV_GL_CONVERSION_TYPES
GLBV_GL_DAILY_EXCHANGE_RATES
GLBV_GL_ENCUMBRANCE_TYPES
GLBV_GL_PERIODS
GLBV_GL_PERIOD_EXCHANGE_RATES
GLBV_GL_SETS_OF_BOOKS
GLBV_GL_STANDARD_BALANCES
GLBV_JOURNAL_BATCHES
GLBV_JOURNAL_ENTRIES
GLBV_JOURNAL_LINES
GLFV_ACTUAL_BALANCES
GLFV_ACTUAL_JOURNAL_BATCHES Actual journal batches are groups of journal entries that represent the results of financial operations.
GLFV_ACTUAL_JOURNAL_ENTRIES
GLFV_BUDGET_BALANCES
GLFV_BUDGET_JOURNAL_BATCHES
GLFV_BUDGET_JOURNAL_ENTRIES
GLFV_CHARTS_OF_ACCOUNTS A chart of accounts is the account structure defined for recording transactions and maintaining account balances to fit the specified needs
GLFV_CURRENCIES Currencies include Oracle Applications predefined ISO currencies,user-defined non-ISO currencies, and the statistical currency . Every set o
GLFV_ENCUMBRANCE_BALANCES Encumbrance Balances are commitments, obligations, and other planned expenditures. You may only have functional currency encumbrance balanc
GLFV_ENCUMB_JOURNAL_BATCHES Encumbrance journal batches are groups of journal entries that represent commitments, obligations, and other planned expenditures.
GLFV_ENCUMB_JOURNAL_ENTRIES
GLFV_GLOBAL_INTERCO_SUBS
GLFV_GLOBAL_INTERCO_TRANS
GLFV_GLOBAL_INTERCO_TRAN_LINES
GLFV_GL_ACCOUNTING_CALENDARS General Ledger accounting calendars define fiscal years and consist of groups of General Ledger Periods.
GLFV_GL_ACCOUNTS
GLFV_GL_ACCOUNTS_DESCR General Ledger accounts are account code combinations defined for a chart of accounts. Shows codes and descriptions.
GLFV_GL_AVERAGE_BALANCES
GLFV_GL_BUDGETS General Ledger budgets are a collection of estimated amounts for a range of accounting periods.
GLFV_GL_BUDGET_ASSIGNMENTS General Ledger budget assignements are accounts associated with a budget organization.
GLFV_GL_BUDGET_ORGANIZATIONS
GLFV_GL_CONVERSION_TYPES General Ledger conversion types are daily conversion rate types defined by users or predefined by Oracle General Ledger.
GLFV_GL_DAILY_EXCHANGE_RATES
GLFV_GL_ENCUMBRANCE_TYPES General Ledger encumbrance types are different categories of encumbrances, such as commitments and obligations.
GLFV_GL_PERIODS General Ledger periods are intervals of time that are grouped together to form the basis for fiscal years and accounting calendars.
GLFV_GL_PERIOD_EXCHANGE_RATES General Ledger period exchange rates are average, period-end, and revaluation conversion rates defined between any two currencies.
GLFV_GL_SETS_OF_BOOKS General Ledger sets of books are accounting organizations. Each set of books is defined by a particular functional currency, charts of accou
GLFV_GL_STANDARD_BALANCES
GLFV_JOURNAL_BATCHES General Ledger journal batches are groups of related journal entries which share the same General Ledger period.
GLFV_JOURNAL_ENTRIES General Ledger journal entries are groups of related journal lines that record debit and credit amounts to General Ledger accounts.
GLFV_JOURNAL_LINES General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas to calculate journal amounts for Gen
GL_ACCESS_SETS_V
GL_ACCESS_SET_LEDGERS_V
GL_ACCESS_SET_NORM_ASSIGN_V
GL_ALC_LEDGER_RSHIPS_V
GL_ALLOC_BATCHES_ACTIVE_V 10SC ONLY
GL_ALLOC_BATCHES_LOV_V 10SC ONLY
GL_ALLOC_BATCHES_V 10SC ONLY
GL_ALLOC_FORMULAS_LOV_V 10SC ONLY
GL_ALLOC_FORMULAS_V
GL_ALLOC_FORMULA_LINES_V 10SC ONLY
GL_ALL_BUD_ORGS_VIEW Review accounts for all budget organizations
GL_ALL_ENC_TYPES_VIEW Review transactions associated with all encumbrance types
GL_ALL_JE_CATEGORY_NAME_VIEW Review all of your journal entry categories
GL_ALL_JE_SOURCE_NAME_VIEW Review all of your journal entry sources
GL_ALL_LEDGER_NAME_VIEW
GL_ALL_LSET_PERIOD_NAME_VIEW
GL_ALL_PERIOD_NAME_VIEW
GL_AUTHORIZATION_LIMITS_V
GL_AUTOMATIC_POSTING_OPTIONS_V
GL_AUTOMATIC_POSTING_SETS_V
GL_AUTOREVERSE_OPTIONS_V
GL_AUTOREV_CRITERIA_SETS_V
GL_AUTO_ALLOC_BATCHES_V
GL_AUTO_ALLOC_BATCH_HISTORY_V
GL_AUTO_ALLOC_BAT_HIST_DET_V
GL_AUTO_ALLOC_SETS_V
GL_AUTO_ALLOC_SET_HISTORY_V
GL_AVGBAL_CALENDAR_V 10SC ONLY
GL_BALANCES_V
GL_BC_OPTION_DETAILS_V 10SC ONLY
GL_BC_PACKETS_V 10SC ONLY
GL_BIS_IEA_TRANS_RECEIVER_V
GL_BIS_IEA_TRANS_SENDER_V
GL_BIS_IEA_TRAN_LINES_V
GL_BUDGETS_AUTOCOPY_V 10SC ONLY
GL_BUDGETS_CONTROL_BUDGETS_V 10SC ONLY
GL_BUDGETS_CURRENT_V 10SC ONLY
GL_BUDGETS_NAME_V 10SC ONLY
GL_BUDGETS_NO_JOURNALS_V 10SC ONLY
GL_BUDGETS_REQUIRE_JOURNALS_V 10SC ONLY
GL_BUDGETS_SOURCE_BUDGETS_V 10SC ONLY
GL_BUDGETS_TARGET_BUDGETS_V 10SC ONLY
GL_BUDGETS_V 10SC ONLY
GL_BUDGETS_WITH_DATES_V 10SC ONLY
GL_BUDGET_ASSIGNMENTS_UNIQUE_V
GL_BUDGET_ASSIGNMENTS_V 10SC ONLY
GL_BUDGET_ASSIGNMENT_RANGES_V 10SC ONLY
GL_BUDGET_DEPENDENT_AMTS_V 10SC ONLY
GL_BUDGET_DEP_BALANCES_V 10SC ONLY
GL_BUDGET_DETAIL_BALANCES_V 10SC ONLY
GL_BUDGET_ENTITIES_CURRENT_V 10SC ONLY
GL_BUDGET_ENTITIES_UNFROZEN_V
GL_BUDGET_JOURNALS_V 10SC ONLY
GL_BUDGET_TRANSFER_V 10SC ONLY
GL_BUDORG_BC_OPTIONS_V
GL_BUD_ASSGNMNT_PRD_RANGES_V 10SC ONLY
GL_BUD_PERIOD_RANGES_V 10SC ONLY
GL_BUD_REC_BATCHES_V 10SC ONLY
GL_COA_MAPPINGS_V
GL_CODE_COMBINATIONS_KFV 10SC ONLY
GL_CODE_COMBINATIONS_V
GL_CONSOLIDATION_AUDIT_V
GL_CONSOLIDATION_HISTORY_V
GL_CONSOLIDATION_NAMES_V
GL_CONSOLIDATION_V
GL_CONS_BUDGET_NAMES_V 10SC ONLY
GL_CONS_BUDGET_PERIODS_V 10SC ONLY
GL_CONS_FLEXFIELD_MAP_HIGH Columns SEGMENT1_HIGH through SEGMENT30_HIGH of GL_CONS_FLEXFIELD_MAP table
GL_CONS_FLEXFIELD_MAP_LOW Columns SEGMENT1_LOW through SEGMENT30_LOW of GL_CONS_FLEXFIELD_MAP table
GL_CONS_MAP_SET_V
GL_CONS_ROLLUP_RANGES_V 10SC ONLY
GL_CONS_SEGMENT_ACTIONS_V
GL_CONS_SEGMENT_MAP_V 10SC ONLY
GL_CONS_SET_ASSIGNMENTS_V
GL_CONS_SET_ASSIGN_V
GL_CONS_SET_NAMES_V
GL_CONTROL_BUDGET_BALANCES_V
GL_DAILY_CONVERSION_TYPES_V 10SC ONLY
GL_DAILY_RATES_V
GL_DEFAS_ASSIGNMENTS_V
GL_DEFAS_RESP_ASSIGN_V
GL_DETAIL_BALANCES_V 10SC ONLY
GL_ELIMINATION_HISTORY_V
GL_ELIM_SET_HISTORY_V
GL_ENCUMBRANCE_TYPES_CURRENT_V 10SC ONLY
GL_ENCUMBRANCE_TYPES_V 10SC ONLY
GL_ENTERED_CURRENCIES_V
GL_ENTITY_BUDGETS_V 10SC ONLY
GL_FUNCTIONAL_BALANCES_V
GL_HISTORICAL_RATES_CURRENCY_V
GL_HISTORICAL_RATES_PERIOD_V
GL_HISTORICAL_RATES_USAGE_V
GL_HISTORICAL_RATES_V 10SC ONLY
GL_HR_EMPLOYEES_CURRENT_V
GL_IEA_AUTOGEN_MAP_V
GL_IEA_RECUR_BATCHES_V
GL_IEA_RECUR_TRANSACTIONS_V
GL_IEA_SEGMENT_MAP_V
GL_IEA_SEGMENT_RULE_MAP_V
GL_IEA_SUBSIDIARIES_MAP_V
GL_IEA_SUBSIDIARIES_V
GL_IEA_SUBS_ACTIVE_V
GL_IEA_TRANSACTIONS_V
GL_IEA_TRANSACTION_TYPES_MAP_V
GL_IEA_TRANSACTION_TYPES_V
GL_IEA_TYPES_ACTIVE_V
GL_INTERCOMPANY_ACCTS_V 10SC ONLY
GL_INTERCOMPANY_ACC_SETS_V
GL_INTERCO_ACCT_V 10SC ONLY
GL_INTERFACE_GROUPS_V 10SC ONLY
GL_INTERFACE_SOURCES_V 10SC ONLY
GL_JE_BATCHES_HEADERS_V
GL_JE_BATCHES_LOV_V 10SC ONLY
GL_JE_BATCHES_POST_V
GL_JE_BATCHES_V
GL_JE_CATEGORIES_V
GL_JE_CATEGORIES_VL
GL_JE_CATEGORY_NAMES_V 10SC ONLY
GL_JE_CONS_BALANCES_V
GL_JE_HEADERS_LOV_V 10SC ONLY
GL_JE_HEADERS_REVERSE_V
GL_JE_HEADERS_V
GL_JE_JOURNAL_LINES_V
GL_JE_LINES_RECON_V
GL_JE_LINES_V
GL_JE_SOURCES_V
GL_JE_SOURCES_VL
GL_JE_SOURCE_NAMES_V 10SC ONLY
GL_JOURNAL_REPORTS_ITF_V
GL_LEDGERS_PUBLIC_ALL_V
GL_LEDGERS_PUBLIC_V
GL_LEDGERS_V
GL_LEDGER_LE_BSV_SPECIFIC_V
GL_LEDGER_LE_V
GL_LEDGER_NAMES_V
GL_LEDGER_NORM_BSVS_V
GL_LEDGER_NORM_MSVS_V
GL_LEDGER_SETS_V
GL_LEDGER_SET_ASSIGNMENTS_V
GL_LEDGER_SET_NORM_ASSIGN_V
GL_LOOKUPS
GL_LOOKUPS_AMOUNT_TYPES_V 10SC ONLY
GL_LOOKUPS_AVG_AMOUNT_TYPES_V 10SC ONLY
GL_LOOKUPS_BATCH_TYPE_V 10SC ONLY
GL_LOOKUPS_BOUNDARIES_V 10SC ONLY
GL_LOOKUPS_BUDGET_INQ1_V 10SC ONLY
GL_LOOKUPS_BUDGET_INQ3_V 10SC ONLY
GL_LOOKUPS_BUDGET_STATUSES_V 10SC ONLY
GL_LOOKUPS_FACTORS_V 10SC ONLY
GL_LOOKUPS_MJE_BATCH_STATUS_V 10SC ONLY
GL_LOOKUPS_MJE_FUNDS_STATUS_V 10SC ONLY
GL_LOOKUPS_PERIOD_STATUSES_V 10SC ONLY
GL_LOOKUPS_RATE_TYPE_V 10SC ONLY
GL_LOOKUPS_YES_NO_V 10SC ONLY
GL_MC_BOOK_ASSIGNMENTS_V
GL_MRC_REPORTING_SOB_PROFILE_V
GL_OASIS_SUMMARY_DATA_V
GL_PERIODS_AND_TYPES_V 10SC ONLY
GL_PERIODS_V 10SC ONLY
GL_PERIOD_NAMES_ALL_V 10SC ONLY
GL_PERIOD_SETS_V 10SC ONLY
GL_PERIOD_STATUSES_ACTUAL_V 10SC ONLY
GL_PERIOD_STATUSES_BUD_UPD_V 10SC ONLY
GL_PERIOD_STATUSES_BUD_V
GL_PERIOD_STATUSES_ENC_V 10SC ONLY
GL_PERIOD_STATUSES_FIRST_60_V 10SC ONLY
GL_PERIOD_STATUSES_NAME_V 10SC ONLY
GL_PERIOD_STATUSES_REV_BUD_V 10SC ONLY
GL_PERIOD_STATUSES_V 10SC ONLY
GL_PERIOD_STAT_BUD_PERA_V
GL_PERIOD_TYPES_V 10SC ONLY
GL_RECURRING_BATCHES_V 10SC ONLY
GL_RECURRING_HEADERS_V 10SC ONLY
GL_RECURRING_VALID_PERIODS_V 10SC ONLY
GL_REC_BATCHES_LOV_V
GL_SECONDARY_LEDGER_RSHIPS_V
GL_SEGMENT_MAP_CONS_V
GL_SETS_OF_BOOKS
GL_SETS_OF_BOOKS_V
GL_SOB_NAMES_V 10SC ONLY
GL_SRS_CLVAL_PERIOD_SET_V
GL_SRS_DEL_JI_GROUPS_V
GL_SRS_DEL_JI_LEDGERS_V
GL_SRS_GLRTB2_ABE_START_PERIOD
GL_SRS_GLRTB2_START_PERIOD Review period names
GL_SRS_IEA_SUBS_V
GL_SRS_JI_GROUPS_V
GL_SRS_JI_LEDGERS_V
GL_SRS_JI_REQUESTS_V
GL_SRS_LEDGER_BUD_ENCUM_NAME Review budget names and encumbrance types
GL_SRS_LEDGER_PERIOD_START Review valid periods for actuals, budgets, and encumbrances
GL_SRS_RECON_CURRENCIES_V
GL_STAT_ACCOUNT_UOM_V 10SC ONLY
GL_STORAGE_PARAMETERS_QF_V 10SC ONLY
GL_STORAGE_PARAMETERS_V 10SC ONLY
GL_SUMMARY_BALANCES_V 10SC ONLY
GL_SUMMARY_BC_OPTIONS_V
GL_SUMMARY_CODE_COMBS_V 10SC ONLY
GL_SUMMARY_COMBINATIONS_V 10SC ONLY
GL_SUMMARY_TEMPLATES_NAMES_V 10SC ONLY
GL_SUMMARY_TEMPLATES_V
GL_SUSPENSE_ACCOUNTS_LOV_V 10SC ONLY
GL_SUSPENSE_ACCOUNTS_V 10SC ONLY
GL_TAX_CODES_V
GL_TAX_OPTIONS_V
GL_TRANSACTION_CALENDAR_V 10SC ONLY
GL_TRANSACTION_CODES_ACTIVE_V 10SC ONLY
GL_TRANSLATION_RATES
GL_TRANSLATION_RATES_CURR_V 10SC ONLY
GL_TRANSLATION_RATES_PERIODS_V 10SC ONLY
GL_TRANSLATION_RATES_V
GL_TRANSLATION_STATUSES_V
GL_TRANSLATION_TRACKING_V 10SC ONLY
GL_TRANS_BUDGET_PERIODS_V 10SC ONLY
GL_TRANS_PERIODS_BSV_V 10SC ONLY
GL_VARIANCE_BALANCES_V
GL_VARIANCE_SEC_BALANCES_V
GL_WF_ROLES_V