1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12-GL Tables and Changes

Discussion in 'Oracle Apps Technical' started by Ramji, Feb 7, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    170
    Trophy Points:
    1,505
    Location:
    Nomad
    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
     
    Bharat likes this.