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
|
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.
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
|
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
|
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
|
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.
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.
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
|
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
|
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
|
No comments:
Post a Comment