Infolinks

Tuesday 15 May 2012

R12 CHANGES IN GL,AP,AR TABLES

=======================R12- AP Changes and Tables==================================

R12- AP Changes and Tables

    New Tables
    Table Name
    Feature Area
    CE_BANK_ACCOUNTS
    Internal Bank Accounts
    CE_PAYMENT_DOCUMENTS
    Payment Documents to be used for Printed type Payments
    IBY_EXTERNAL_PAYEES_ALL
    Payee (Trading Partner Info for paying invoices
    IBY_PMT_INSTR_USES_ALL
    Used for Remit to Bank Accounts
    AP_INVOICE_LINES_ALL
    Invoice Lines
    AP_ALLOCATION_RULES
    Invoice Lines
    AP_INVOICE_LINES_ALL
    Invoice Lines
    AP_ALLOCATION_RULES
    Invoice Lines
    AP_ALLOCATION_RULE_LINES
    Invoice Lines
    AP_ALLOCATION_RULE_LINES_GT
    Global Temp Table for Invoice Lines – Allocations
    AP_SELF_ASSESSED_TAX_DIST_ALL
    E-Business Tax
    AP_PRODUCT_REGISTRATIONS
    Invoice Lines
    AP_PRODUCT_SETUP
    Multi Org Access Control
    AP_TOLERANCE_TEMPLATES
    Support of complex PO Contracts
    AP_NEGOTIATION_HIST
    Invoice Requests
    AP_NEGOTIATION_HIST
    Holds Resolution Workflow
    Changed Tables
    Table Name
    Feature Area
    Brief Description of Change
    AP_INVOICES_ALL
    Invoice Lines, eBusiness Tax, Payments, SLA, Complex Work POs…
    Numerous columns were added to this table due to almost all the projects done for R12, for list of columns added please

refer to the TDD of the respective projects.
    AP_INVOICE_DISTRIBUTIONS_ALL
    Invoice Lines, eBusiness Tax…
    Number of columns were added to this table due to almost all the projects done for R12, for list of columns added please

refer to the TDD of the respective projects.
    AP_INV_APRVL_HIST_ALL
    Holds resolution workflow
    Hold_ID column was added.
    AP_CHECKS_ALL
    Payables Payments Data
    Some new columns are added to AP_CHECKS_ALL table for maintaining real time synchronization with Oracle Payments and Cash

Managements. Some existing columns from the same tables have been made obsolete.
    AP_HOLDS_ALL
    Holds Resolution Workflow
    New Columns Added were: Hold_id and wf_status.
    AP_HOLD_CODES
    Holds Resolution Workflow
    New Columns Added were: hold_instruction, wait_before_notify_days, reminder_days
    AP_INV_APRVL_HIST_ALL
    Holds Resolution and Invoice Approval Workflow
    This will be used to record history for both the Invoice level Approvals and Invoice Line level approvals. New Columns

Added were:line_number, hold_id and history_type
    AP_APINV_APPROVERS
    Invoice Approval Workflow
    New Columns Added were:child_process_item_key, child_process_item_type, item_type and item_key.
    Obsolete Tables
    Table Name
    Feature Area
    Replaced By
    AP_BANK_BRANCHES
    Bank/Bank Branches
    CE_BANK_BRANCHES_V
    AP_BANK_ACCOUNTS_ALL
    Bank Accounts including Internal and External
    CE_BANK_USES_OU_V/IBY_EXT_BANK_ACCOUNTS_V
    AP_BANK_ACCOUNTS_USES_ALL
    Remit to Bank Account Uses
    AP_CHECK_STOCKS_ALL
    Payments Documents
    CE_PAYMENT_DOCUMENTS
    AP_CHECK_FORMATS
    Payments Format
    AP_TAX_RECVRY_RULES_ALL
    EBusiness Tax
    Replaced by relevant EBTax tables/views.
    AP_TAX_RECVRY_RATES_ALL
    EBusiness Tax
    Replaced by relevant EBTax tables/views.
    AP_CHRG_ALLOCATIONS_ALL
    Invoice Lines - Allocations
    This feature is replaced by distributions itself, distributions itself represent the allocation of charges.
    AP_TAX_DERIVATIONS
    EBusiness Tax
    Replaced by relevant EBTax tables/views.
    AP_LINE_APRVL_HIST_ALL
    Invoice Approval Workflow
    AP_INV_APRVL_HIST_ALL
    New Views
    View Name
    Feature Area
    CE_BANK_BRANCHES_V
    Bank/Branches Info
    CE_BANK_ACCT_USES_OU_V
    Internal Bank Account Uses Info
    IBY_EXT_BANK_ACCOUNTS_V
    Remit to Bank Account Info
    AP_DOCUMENTS_PAYABLE
    This view will store interim payables check and payment schedules information. Based on this view Oracle Payments will

process data for formatting and building payment. As described in the “Single Payment real-time Flow” diagrams this view will

store real time payables data. As a result of this until or unless payment is created, this view will not contain any data for

quick payments.
    AP_INVOICE_LINES_V
    Invoice Lines project. This is the base view for the Lines block on invoice workbench.
    AP_PO_CORRECTIONS_V
    PO Corrections.
    AP_MATCH_CORRECTION_DISTS_V
    Distribution level PO/RCV Corrections.
    AP_RECEIPT_CORRECTIONS_V
    Receipt Corrections.
    AP_ALLOCATION_RULES_V
    Invoice Lines - Allocations.
    Changed Views
    View Name
    Feature Area
    AP_INVOICES_V
    All the columns that were added to the base table due to the various projects were added to this view too.
    AP_INVOICE_DISTRIBUTIONS_V
    All the columns that were added to the base table due to the various projects were added to this view too.
    PO_LINE_LOCATIONS_AP_V
    PO Matching
    AP_PO_DISTRIBUTIONS_AP2_V
    PO Matching at distribution level.
    PO_AP_RECEIPT_MATCH_V
    Receipt Matching view
    AP_APPLY_PREPAYS_V
    Invoice Lines – Prepayment Application
    AP_UNAPPLY_PREPAYS_V
    Invoice Lines – Prepayment Application
    AP_WF_APPROVAL_HISTORY_V
    Invoice Approval Workflow
    Obsolete Views
    View Name
    Feature Area
    AP_BANK_ACCOUNTS
    Internal/External Bank Accounts Multi-Org View
    AP_BANK_ACCOUNT_USES
    External Bank Account Uses Multi-Org View
    AP_BANK_ACCOUNT_USES_V
    External Bank Accounts Uses Reference View
    New TablesTCA Changes for Suppliers
    The following are the new tables added in Release 12 as a part of this initiative.
    Refer to the Oracle E-Business Suite Electronic Technical Reference Manual for the table and column descriptions..
    · AP_SUPPLIERS
    · AP_SUPPLIER_SITES_ALL
    · AP_SUPPLIER_CONTACTS
    · AP_SUPPLIER_INT_REJECTIONS
    New Views

    The following are the new views added in Release 12 as a part of this initiative.
    These are backwards compatible views that join the Suppliers table in Payables and the TCA tables,
    so that any teams using the old suppliers tables have no impact.
    · PO_VENDORS
    · PO_VENDOR_SITES_ALL
    · PO_VENDOR_CONTACTS
    The following tables are obsoleted:
    · PO_VENDORS
    · PO_VENDOR_SITES_ALL
    · PO_VENDOR_CONTACTS

========================== LINK B/W INVOICE AND PO===============
SELECT invoice_id
  FROM ap_invoice_distributions_all
 WHERE po_distribution_id IN (SELECT po_distribution_id
                                FROM po_distributions_all
                               WHERE po_header_id = <po_header_id>);
=====================GOOD PERFORMANCE QUERY=====================

GOOD PERFORMANCE QUERY

SELECT invoice_num FROM ap_invoice_all aia WHERE
EXISTS
         (
        SELECT 1
        FROM ap_invocie_distributions_all aida
        WHERE
        aida.invoice_id=aia.invoice_id
        AND
     EXISTS (
                SELECT 1
                FROM po_distributions_all  pod
                WHERE
                pod.distribution_id=aida.distribution_id
                AND
                EXISTS (
                        SELECT 1 FROM po_headers_all po
                        WHERE po.po_header_id=pod.po_header_id
                        AND
                        segment1='xxxx' AND org_id=xxx
                        )
                 )
           )

==========================BAD PERFORMANCE QUERY===================

BAD PERFORMANCE QUERY

SELECT
  PO.PO_HEADERS_ALL.SEGMENT1,
  PO.PO_LINES_ALL.LINE_NUM,
  AP.AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE,
  AP.AP_INVOICES_ALL.INVOICE_NUM
FROM
  PO.PO_LINES_ALL,
  PO.PO_HEADERS_ALL,
  AP.AP_INVOICE_DISTRIBUTIONS_ALL,
  AP.AP_INVOICES_ALL,
  PO.PO_DISTRIBUTIONS_ALL,
  PO.PO_LINE_LOCATIONS_ALL
WHERE
 PO.PO_LINES_ALL.PO_LINE_ID=PO.PO_LINE_LOCATIONS_ALL.PO_LINE_ID AND
 PO.PO_HEADERS_ALL.PO_HEADER_ID= PO.PO_LINES_ALL.PO_HEADER_ID AND

PO.PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID=PO.PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID
  AND  AP.AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID=AP.AP_INVOICES_ALL.INVOICE_ID
  AND  PO.PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID=AP.AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID AND
PO.PO_LINES_ALL.ORG_ID= 132 AND
 PO.PO_HEADERS_ALL.ORG_ID = 132 AND
AP.AP_INVOICE_DISTRIBUTIONS_ALL.ORG_ID= 132 AND 
AP.AP_INVOICES_ALL.ORG_ID= 132 AND
PO.PO_DISTRIBUTIONS_ALL.ORG_ID= 132 AND
PO.PO_LINE_LOCATIONS_ALL.ORG_ID= 132 AND
  AP.AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE  BETWEEN '01-01-2010 00:00:00' AND '13-01-2010 00:00:00'

=======================R12- AR Tables and Changes==========================

R12- AR Tables and Changes

    Here goes...
    AR R12 Tables
    New Tables
    Description of Change
    AR_REC_TRX_LE_DETAILS_ALL
    Added detail level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a receivables activity and the

sets of asset and liability tax codes by legal entity.
    AR_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_DEFERRED_LINES_ALL
    Revenue Deferral Reasons
    AR_RDR_PARAMETERS_GT
    Revenue Deferral Reasons
    AR_REVIEWED_LINES_GT
    Revenue Deferral Reasons
    Changed Tables
    Table Name
    Description of Change
    RA_CUSTOMER_TRX_LINES_ALL
    Added numerous columns to support E-Business Tax and line-level Ship To, Added Payment extension identifier.
    AR_MEMO_LINES
    Added tax_product_category to support E-Business Tax uptake.
    AR_TRX_LINES_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_TRX_LINES_TMP_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_ARCHIVE_DETAIL
    Added numerous columns to support E-Business Tax and line-level Ship To,
    RA_BATCH_SOURCES_ALL
    Obsoleted invalid_tax_rate_rule column.
    HZ_CUST_SITE_USES
    Migrated tax_code, tax_header_level_flag, tax_reference, and tax_classification to ZX_PARTY_TAX_PROFILE and

ZX_REGISTRATIONS tables.
    AR_CASH_RECEIPTS_ALL
    Added Payment extension identifier and obsoleted, approval_code,
    address_verification_code, payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID,

Added legal_entity_id column.
    AR_RECEIPT_METHODS
    Added Payment Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id, auto_print_program_id
    RA_CUSTOMER_TRX_ALL
    Added Payment extension identifier and Payment Attributes,
    obsoleted payment_server_order_num, approval_code, address_verification_code, Renamed column REMITTANCE_BANK_ACCOUNT_ID to

REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
    RA_INTERFACE_LINES_ALL
    Added Payment extension identifier and Payment Attributes, and obsoleted payment_server_order_num, approval_code,

address_verification_code, Added legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.
    AR_AUTOREC_EXCEPTIONS
    Renamed column REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCHES_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCH_SOURCES_ALL
    Renamed column DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_INTERIM_CASH_RECEIPTS_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_RECEIPT_METHOD_ACCOUNTS_ALL
    Renamed column BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_TRX_HEADER_GT
    Added legal_entity_id column
    AR_TRX_HEADER_TMP_GT
    Added legal_entity_id column
    AR_LINE_CONTS_ALL
    Added contingency_id as a foreign key to AR_DEFERRAL_REASONS
    AR_TRX_CONTINGENCIES_GT
    Added contingency_id, expiration_event_date and completed_flag.
    Obsolete Tables
    Table Name
    AR_TA_ASGN_TO_INT_ALL
    AR_TA_CASHAPP_OB_ALL
    AR_TA_CR_AGEN_INF_ALL
    AR_TA_CUST_HIER_CHILD
    AR_TA_CUST_HIER_PARNT
    AR_TA_CUST_INT_ALL
    AR_TA_CUST_TRXSTR_ALL
    AR_TA_DEDN_ASSGNS_ALL
    AR_TA_DEDN_INT_ALL
    AR_TA_DEDN_RELATE_ALL
    AR_TA_LEGACY_CUST_INT
    AR_TA_LEGACY_STAT_INT
    AR_TA_PAYMNT_HIST_ALL
    AR_TA_PROF_ASSGNT_ALL
    AR_TA_PROMOTIONS_ALL
    AR_TA_PROMOTIONS_INT
    AR_TA_PROM_CUST_ALL
    AR_TA_PROM_CUST_MAP
    AR_TA_PROM_LINES_INT
    AR_TA_PROM_PAYMNT_ALL
    AR_TA_PROM_PAYMNT_TYP
    AR_TA_PROM_PRODS_ALL
    AR_TA_PROM_STATUS_MAP
    AR_TA_RECON_INFO_ALL
    AR_TA_RECV_TRXSET_ALL
    AR_TA_REMIT_HIST_ALL
    AR_TA_REMIT_PROF_ALL
    AR_TA_RISK_COMENT_ALL
    AR_TA_RULES_ALL
    AR_TA_RULE_OUTPUT
    AR_TA_RULE_SETS_ALL
    AR_TA_RULE_SET_LN_ALL
    AR_TA_TRX_SETS_ALL
    AR_TA_TRX_SET_LN_ALL
    AR_TA_TRX_TO_CREATE
    AR_TA_TRX_TYP_INT_ALL
    AR_TA_VERSIONS
    New Views
    View Name
    Description of Change
    AR_MEMO_LINES_VL
    Added tax_product_category.
    AR_SHIP_ADDRESS_V
    Removed hz_loc_assignments.
    RA_CUSTOMER_TRX_LINES_V
    Added numerous columns
    AR_DOCS_RECEIVABLES_V
    AR_FUNDS_CAPTURE_ORDERS_V
    ARBR_DOCS_RECEIVABLES_V
    ARBR_DOCUMENT_LINES_V
    ARBR_FUNDS_CAPTURE_ORDERS_V
    AR_CBA_BANK_BRANCH_CONTACTS_V
    AR_CBA_BANK_ACCOUNT_CONTACTS_V
    AR_CBA_EFT_USER_NUMBER_V
    AR_LINE_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_LINE_CONTINGENCIES_V
    Revenue Deferral Reasons
    AR_RDR_ITEMS_V
    Reasons, Validation Set for RDR setup
    Changed Views
    View Name
    Description of Change
    AR_AUTOMATIC_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model

changes related to payment uptake project.
    AR_BOE_AUTO_RECEIPTS_V
    Added Payment extension identifier to view
    AR_BOE_REMIT_RECEIPTS_CBUNR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model

changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_NONCBR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model

changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_ASSIGNMENTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_MAIN_REMIT_BATCH_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_CASH_RECEIPTS_V
    Added Payment extension identifier and payment channel identifier to view
    AR_CUSTOMER_BILLS_TRX_V
    Added Payment extension identifier and payment channel identifier to view
    AR_REMITTED_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model

changes related to payment uptake project.
    RA_CUSTOMER_TRX_CM_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PART_CB_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PARTIAL_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    AR_AEL_GL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_AEL_SL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_CUSTOMER_BILLS_TRX_V
    Made changes to support the new Internal Bank Account data model.
    AR_BR_MAIN_REMIT_BATCH_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCHES_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCH_REMIT_V
    Made changes to support the new Internal Bank Account data model.
    AR_BOE_REMIT_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_INTERIM_CR_LINES_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Added legal_entity_id column
    AR_CUSTOMER_BILLS_TRX_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_PMT_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_TRX2_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_CR_TRX_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PARTIAL_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PART_CB_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_V
    Added legal_entity_id column
    RA_CUST_TRX_LINE_GL_DIST_V
    Added column user_generated_flag

=====================R12-GL Tables and Changes==============================================


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

====================================END======

No comments:

Post a Comment