R12-GL Tables and Changes

in Oracle E-Business Suite & Oracle Fusion Applications; 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 ...
+ Post Reply + Post New Topic
Results 1 to 1 of 1
  1. #1
    Ramji's Avatar
    Ramji is offline Forum Guru
    Points: 17,920, Level: 85
    Join Date
    14 Jan 2012
    Location
    Nomad
    Posts
    523
    Points
    17,920

    R12-GL Tables and 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
    Bharat says Thanks.


Other Solutions
  1. Link between Invoice Tables - GL Tables
    By tomloera in forum Oracle Financials
    Replies: 0
    Last Post: 02-15-2011, 03:35 PM
  2. tables in a DBC and free tables
    By ali0482 in forum Interview and Jobs Discussions
    Replies: 1
    Last Post: 09-02-2010, 05:17 PM
  3. AP Tables
    By yknev in forum Oracle Apps Technical
    Replies: 1
    Last Post: 03-04-2010, 04:36 AM
  4. Link between PO Tables and AP Tables
    By Monziac in forum Oracle Apps Technical
    Replies: 8
    Last Post: 01-13-2010, 01:44 PM