R 12 GL CHANGES

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

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