Thursday, 7 June 2012

R12 General Ledger changes


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