July 29, 2015

R12 Bacis-GL





Oracle GL: Table Name

Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_AUTOGEN_MAP
GL_IEA_CLEARING_ACCOUNTS
GL_IEA_IMPORT_REGISTRY
GL_IEA_INTERFACE
GL_IEA_RECUR_BATCHES
GL_IEA_RECUR_LINES
GL_IEA_SEGMENT_MAP
GL_IEA_SEGMENT_RULE_MAP
GL_IEA_TRANSACTION_LINES
GL_IEA_TRANSACTION_TYPES
GL_IEA_TRANSACTIONS
GL_INTERCOMPANY_ACC_SETS
GL_INTERCOMPANY_ACCOUNTS
Setup Forms and Programs
GL_MC_BOOK_ASSIGNMENTS
GL_LEDGER_RELATIONSHIPS
GL_MC_CONVERSION_RULES
GL_JE_INCLUSION_RULES
GL_MC_REPORTING_OPTIONS
GL_LEDGER_RELATIONSHIPS
Financial Intelligence
GL_OASIS_FIN_ASSIGNMENTS
GL_OASIS_FIN_ITEMS
GL_OASIS_FIN_METRICS
Balances and Related Objects
GL_OPEN_INTERIM
GL_POSTING_INTERIM
Setup Forms and Programs
GL_SETS_OF_BOOKS
GL_LEDGERS
Financial Intelligence
GL_SHARES_ACTIVITY
GL_SHARES_OUTSTANDING
GL_SYSTEM_SETUP
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

Revaluation, Translation and Conversion Rates
GL_TRANSLATION_RATES

Setup Forms and Programs
GL_DAILY_RATES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_DIM_SEGMENTS
RG_DSS_DIMENSIONS
RG_DSS_HIERARCHIES
RG_DSS_HIERARCHY_DETAILS
RG_DSS_REQUESTS
RG_DSS_SEG_RANGE_SETS
RG_DSS_SEG_RANGES
RG_DSS_SYSTEM_SEG_ORDER
RG_DSS_SYSTEM_VARIABLES
RG_DSS_SYSTEMS
RG_DSS_VAR_DIMENSIONS
RG_DSS_VAR_SELECTIONS
RG_DSS_VAR_TEMPLATES
RG_DSS_VARIABLES

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
GL_ACCESS_SET_LEDGERS
Setup Forms and Programs
GL_ALC_LEDGER_RSHIPS_V
Journal Entry
GL_AUTOREV_CRITERIA_SETS_V
Budgets and Related Objects
GL_BUDGET_ASSIGNMENTS_UNIQUE_V
GL_BUDORG_BC_OPTIONS_V
Setup Forms and Programs
GL_DEFAS_ASSIGNMENTS_V
GL_DEFAS_RESP_ASSIGN_V
Balances and Related Objects
GL_ENTERED_CURRENCIES_V
Revaluation, Translation and Conversion Rates
GL_HISTORICAL_RATES_PERIOD_V
Journal Entry
GL_JE_LINES_RECON_V
Setup Forms and Programs
GL_LEDGER_LE_BSV_SPECIFIC_V
GL_LEDGER_LE_V
GL_LEDGER_NAMES_V
GL_LEDGER_NORM_BSVS_V
GL_LEDGER_SET_ASSIGNMENTS_V
GL_LEDGER_SET_NORM_ASSIGN_V
GL_LEDGER_SETS_V
GL_LEDGERS_PUBLIC_ALL_V
GL_LEDGERS_PUBLIC_V
GL_LEDGERS_V
Recurring Journals and Budgets
GL_REC_BATCHES_LOV_V
Setup Forms and Programs
GL_SECONDARY_LEDGER_RSHIPS_V
GL_SETS_OF_BOOKS
Summarization
GL_SUMMARY_BC_OPTIONS_V
GL_SUMMARY_TEMPLATES_V
Revaluation, Translation and Conversion Rates
GL_TRANSLATION_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

Setup Forms and Programs
GL_SETS_OF_BOOKS_V
Modify to refer to GL_LEDGERS instead of GL_SETS_OF_BOOKS
Setup Forms and Programs
GL_TAX_CODES_V
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

Setup Forms and Programs
GL_ALL_JE_CATEGORY_NAME_VIEW
Mass Allocations, Budgets and Encumbrances
GL_ALLOC_BATCHES_ACTIVE_V
Posting
GL_AUTOPOST_OPTIONS_CURRENT_V
Consolidation and Eliminations
GL_CONS_FLEXFIELD_MAP_HIGH
GL_CONS_FLEXFIELD_MAP_LOW
Journal Entry
GL_JE_BATCHES_AP_V
GL_JE_HEADERS_LOV_V
Setup Forms and Programs
GL_MC_BOOKS_ASSIGNMENTS_V
GL_MRC_REPORTING_SOB_PROFILE_V
GL_PERIOD_STATUSES_REV_BUD_V
Revaluation, Translation and Conversion Rates
GL_TRANS_BUDGET_PERIODS_V
GL_TRANS_PERIODS_BSV_V
GL_TRANSLATION_RATES_CURR_V
GL_TRANSLATION_RATES_PERIODS_V
GL_TRANSLATION_RATES_V
GL_TRANSLATION_TRACKING_V
Financial Statement Generator
RG_REPORT_STANDARD_AXES_V


No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...