=======================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======
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