General Ledger
1.1 New Tables
|
Table
Name
|
Feature
Area
|
|
FUN_SEQ_ASSIGNMENTS
|
Setup Forms and Programs
|
|
FUN_SEQ_CONTEXTS
|
Setup Forms and Programs
|
|
FUN_SEQ_ENTITIES
|
Setup Forms and Programs
|
|
FUN_SEQ_HEADERS
|
Setup Forms and Programs
|
|
FUN_SEQ_REQUESTS
|
Setup Forms and Programs
|
|
FUN_SEQ_RULES
|
Setup Forms and Programs
|
|
FUN_SEQ_VERSIONS
|
Setup Forms and Programs
|
|
GL_ACCESS_SET_ASSIGNMENTS
|
Setup Forms and Programs
|
|
GL_ACCESS_SET_NORM_ASSIGN
|
Setup Forms and Programs
|
|
GL_ACCESS_SETS
|
Setup Forms and Programs
|
|
GL_AUTOREV_CRITERIA_SETS
|
Journal Entry
|
|
GL_BC_PACKETS_HISTS
|
Budgets and related objects
|
|
GL_BUDORG_BC_OPTIONS
|
Budgets and related objects
|
|
GL_COA_MAPPINGS
|
Consolidation and Eliminations
|
|
GL_DEFAS_ACCESS_SETS
|
Setup Forms and Programs
|
|
GL_DEFAS_ASSIGNMENTS
|
Setup Forms and Programs
|
|
GL_DEFAS_RESP_ASSIGN
|
Setup Forms and Programs
|
|
GL_JE_INCLUSION_RULES
|
Setup Forms and Programs
|
|
GL_JE_LINES_RECON
|
Reconciliation
|
|
GL_JE_SEGMENT_VALUES
|
Journal Entry
|
|
GL_LE_VALUE_SETS
|
Setup Forms and Programs
|
|
GL_LEDGER_CONFIG_DETAILS
|
Setup Forms and Programs
|
|
GL_LEDGER_CONFIGURATIONS
|
Setup Forms and Programs
|
|
GL_LEDGER_NORM_SEG_VALS
|
Setup Forms and Programs
|
|
GL_LEDGER_RELATIONSHIPS
|
Setup Forms and Programs
|
|
GL_LEDGER_SEGMENT_VALUES
|
Setup Forms and Programs
|
|
GL_LEDGER_SET_ASSIGNMENTS
|
Setup Forms and Programs
|
|
GL_LEDGER_SET_NORM_ASSIGN
|
Setup Forms and Programs
|
|
GL_LEDGER_SET_REQUESTS
|
Setup Forms and Programs
|
|
GL_LEDGERS
|
Setup Forms and Programs
|
|
GL_LEGAL_ENTITIES_BSVS
|
Setup Forms and Programs
|
|
GL_MGT_SEG_UPGRADE
|
Other Issues
|
|
GL_MGT_SEG_UPGRADE_H
|
Other Issues
|
|
GL_SEG_VAL_HIERARCHIES
|
Setup Forms and Programs
|
|
GL_SEG_VAL_NORM_HIERARCHY
|
Setup Forms and Programs
|
|
GL_SUMMARY_BC_OPTIONS
|
Budgets and related objects
|
1.2 Changed Tables
The set_of_books_id column has been renamed to
ledger_id in all tables with some exceptions as mentioned below. All setups secured by definition access sets
have a new security_flag column in the relevant tables.
|
Table
Name
|
Feature
Area
|
Brief
Description of Change
|
|
GL_ALLOC_FORMULAS
|
MassAllocations, Budgets and Encumbrances
|
Add currency_conversion_type to support foreign currency
allocations
|
|
GL_AUTO_ALLOC_SETS
|
MassAllocations, Budgets and Encumbrances
|
Add chart_of_accounts_id, period_set_name and
accounting_period_type to enable sharing of AutoAllocations across ledgers
sharing the same chart of accounts and calendar
|
|
GL_AUTOMATIC_POSTING_OPTIONS
|
Posting
|
Add ledger_id to enable AutoPost across ledgers
|
|
GL_AUTOMATIC_POSTING_SETS
|
Posting
|
Add chart_of_accounts_id, period_set_name and
accounting_period_type to enable sharing of AutoPost Criteria Sets across
ledgers sharing the same chart of accounts and calendar
|
|
GL_AUTOREVERSE_OPTIONS
|
Journal Entry
|
Add criteria_set_id to support AutoReverse criteria sets
stored in the master table GL_AUTOREV_CRITERIA_SETS
|
|
GL_BALANCES
|
Balances and Related Objects
|
Add quarter_to_date_dr_beq, quarter_to_date_cr_beq,
project_to_date_dr_beq and project_to_date_cr_beq to store entered ledger
currency balances
|
|
GL_CODE_COMBINATIONS
|
Setup Forms and Programs
|
Add alternate_code_combination_id to support replacement
for disabled accounts functionality implemented by Journal Import
|
|
GL_CONSOLIDATION
|
Consolidation and Eliminations
|
Add coa_mapping_id to enable consolidations to use chart
of accounts mappings
|
|
GL_INTERFACE
|
Journal Import
|
Add ledger_id and retain set_of_books_id for backward
compatibility
|
|
GL_JE_BATCHES
|
Journal Entry
|
Drop set_of_books_id and add chart_of_accounts_id,
period_set_name and accounting_period_type to support batches containing
journals for multiple ledgers sharing the same chart of accounts and calendar
|
|
GL_JE_HEADERS
|
Journal Entry
|
Add columns to store the accounting and reporting
sequences
|
|
GL_PERIOD_STATUSES
|
Setup Forms and Programs
|
Add ledger_id and retain set_of_books_id for backward
compatibility
|
|
GL_RECURRING_HEADERS
|
Recurring Journals and Budgets
|
Add currency_conversion_type to support foreign currency
recurring journals
|
|
GL_SYSTEM_USAGES
|
Setup Forms and Programs
|
Add efb_upgrade_flag and reconciliation_upg_flag to track
successfully completed optional post-update programs
|
2.3 Obsolete Tables
None of the obsolete tables have been
dropped. Some obsolete tables have been
renamed with the suffix _11i. Some
obsolete tables are highlighted below.
|
Table
Name
|
Feature
Area
|
Replaced
By
|
|
GL_IEA_AUTOGEN_MAP
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_CLEARING_ACCOUNTS
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_IMPORT_REGISTRY
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_INTERFACE
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_RECUR_BATCHES
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_RECUR_LINES
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_SEGMENT_MAP
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_SEGMENT_RULE_MAP
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_TRANSACTION_LINES
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_TRANSACTION_TYPES
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_IEA_TRANSACTIONS
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_INTERCOMPANY_ACC_SETS
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_INTERCOMPANY_ACCOUNTS
|
Global Intercompany System
|
Advanced Global Intercompany System feature
|
|
GL_MC_BOOK_ASSIGNMENTS
|
Setup Forms and Programs
|
GL_LEDGER_RELATIONSHIPS
|
|
GL_MC_CONVERSION_RULES
|
Setup Forms and Programs
|
GL_JE_INCLUSION_RULES
|
|
GL_MC_REPORTING_OPTIONS
|
Setup Forms and Programs
|
GL_LEDGER_RELATIONSHIPS
|
|
GL_OASIS_FIN_ASSIGNMENTS
|
Financial Intelligence
|
|
|
GL_OASIS_FIN_ITEMS
|
Financial Intelligence
|
|
|
GL_OASIS_FIN_METRICS
|
Financial Intelligence
|
|
|
GL_OPEN_INTERIM
|
Balances and Related Objects
|
GL_POSTING_INTERIM
|
|
GL_SETS_OF_BOOKS
|
Setup Forms and Programs
|
GL_LEDGERS
|
|
GL_SHARES_ACTIVITY
|
Financial Intelligence
|
|
|
GL_SHARES_OUTSTANDING
|
Financial Intelligence
|
|
|
GL_SYSTEM_SETUP
|
Setup Forms and Programs
|
Relevant columns were moved to the GL: Number of formulas
to validate for each MassAllocation batch, GL: Number of formulas to validate
for each Recurring Journal batch and GL: Archive Journal Import Data profile
options
|
|
GL_TRANSLATION_RATES
|
Revaluation, Translation and Conversion Rates
|
GL_DAILY_RATES
|
|
RG_DSS_DIM_SEGMENTS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_DIMENSIONS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_HIERARCHIES
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_HIERARCHY_DETAILS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_REQUESTS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_SEG_RANGE_SETS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_SEG_RANGES
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_SYSTEM_SEG_ORDER
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_SYSTEM_VARIABLES
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_SYSTEMS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_VAR_DIMENSIONS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_VAR_SELECTIONS
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_VAR_TEMPLATES
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
|
RG_DSS_VARIABLES
|
Financial Analyzer
|
Enterprise Planning and Budgeting product
|
2.4 New Views
A number of new views have been added to support
UIs and processing of new features. Some
of the views are mentioned below.
|
View
Name
|
Feature
Area
|
|
GL_ACCESS_SET_LEDGERS
|
Setup Forms and Programs
|
|
GL_ALC_LEDGER_RSHIPS_V
|
Setup Forms and Programs
|
|
GL_AUTOREV_CRITERIA_SETS_V
|
Journal Entry
|
|
GL_BUDGET_ASSIGNMENTS_UNIQUE_V
|
Budgets and Related Objects
|
|
GL_BUDORG_BC_OPTIONS_V
|
Budgets and Related Objects
|
|
GL_DEFAS_ASSIGNMENTS_V
|
Setup Forms and Programs
|
|
GL_DEFAS_RESP_ASSIGN_V
|
Setup Forms and Programs
|
|
GL_ENTERED_CURRENCIES_V
|
Balances and Related Objects
|
|
GL_HISTORICAL_RATES_PERIOD_V
|
Revaluation, Translation and Conversion Rates
|
|
GL_JE_LINES_RECON_V
|
Journal Entry
|
|
GL_LEDGER_LE_BSV_SPECIFIC_V
|
Setup Forms and Programs
|
|
GL_LEDGER_LE_V
|
Setup Forms and Programs
|
|
GL_LEDGER_NAMES_V
|
Setup Forms and Programs
|
|
GL_LEDGER_NORM_BSVS_V
|
Setup Forms and Programs
|
|
GL_LEDGER_SET_ASSIGNMENTS_V
|
Setup Forms and Programs
|
|
GL_LEDGER_SET_NORM_ASSIGN_V
|
Setup Forms and Programs
|
|
GL_LEDGER_SETS_V
|
Setup Forms and Programs
|
|
GL_LEDGERS_PUBLIC_ALL_V
|
Setup Forms and Programs
|
|
GL_LEDGERS_PUBLIC_V
|
Setup Forms and Programs
|
|
GL_LEDGERS_V
|
Setup Forms and Programs
|
|
GL_REC_BATCHES_LOV_V
|
Recurring Journals and Budgets
|
|
GL_SECONDARY_LEDGER_RSHIPS_V
|
Setup Forms and Programs
|
|
GL_SETS_OF_BOOKS
|
Setup Forms and Programs
|
|
GL_SUMMARY_BC_OPTIONS_V
|
Summarization
|
|
GL_SUMMARY_TEMPLATES_V
|
Summarization
|
|
GL_TRANSLATION_RATES
|
Revaluation, Translation and Conversion Rates
|
2.5 Changed Views
All views used to support Discoverer workbooks have
been updated as necessary to uptake the data model changes. Views that retrieve balances have been
updated as necessary to retrieve entered ledger currency balances. A large number of other views have also been
updated to uptake various data model changes.
Some changed views are highlighted below.
|
View
Name
|
Feature
Area
|
Brief
Description of Change
|
|
GL_SETS_OF_BOOKS_V
|
Setup Forms and Programs
|
Modify to refer to GL_LEDGERS instead of GL_SETS_OF_BOOKS
|
|
GL_TAX_CODES_V
|
Setup Forms and Programs
|
Modify to uptake new eTax data model
|
|
|
|
|
2.6 Obsoleted Views
A number of views related to Global Intercompany
System and Oracle Financial Analyzer have been obsoleted. Some other obsolete views are mentioned
below.
|
View
Name
|
Feature
Area
|
Replaced
By
|
|
GL_ALL_JE_CATEGORY_NAME_VIEW
|
Setup Forms and Programs
|
|
|
GL_ALLOC_BATCHES_ACTIVE_V
|
MassAllocations, Budgets and Encumbrances
|
|
|
GL_AUTOPOST_OPTIONS_CURRENT_V
|
Posting
|
|
|
GL_CONS_FLEXFIELD_MAP_HIGH
|
Consolidation and Eliminations
|
|
|
GL_CONS_FLEXFIELD_MAP_LOW
|
Consolidation and Eliminations
|
|
|
GL_JE_BATCHES_AP_V
|
Journal Entry
|
|
|
GL_JE_HEADERS_LOV_V
|
Journal Entry
|
|
|
GL_MC_BOOKS_ASSIGNMENTS_V
|
Setup Forms and Programs
|
|
|
GL_MRC_REPORTING_SOB_PROFILE_V
|
Setup Forms and Programs
|
|
|
GL_PERIOD_STATUSES_REV_BUD_V
|
Setup Forms and Programs
|
|
|
GL_TRANS_BUDGET_PERIODS_V
|
Revaluation, Translation and Conversion Rates
|
|
|
GL_TRANS_PERIODS_BSV_V
|
Revaluation, Translation and Conversion Rates
|
|
|
GL_TRANSLATION_RATES_CURR_V
|
Revaluation, Translation and Conversion Rates
|
|
|
GL_TRANSLATION_RATES_PERIODS_V
|
Revaluation, Translation and Conversion Rates
|
|
|
GL_TRANSLATION_RATES_V
|
Revaluation, Translation and Conversion Rates
|
|
|
GL_TRANSLATION_TRACKING_V
|
Revaluation, Translation and Conversion Rates
|
|
|
RG_REPORT_STANDARD_AXES_V
|
Financial Statement Generator
|
|
No comments:
Post a Comment