Infolinks

Showing posts with label AR. Show all posts
Showing posts with label AR. Show all posts

Thursday, 7 June 2012

R12 General Ledger changes


General Ledger


1.1 New Tables

Table Name


Feature Area


FUN_SEQ_ASSIGNMENTS
Setup Forms and Programs
FUN_SEQ_CONTEXTS
Setup Forms and Programs
FUN_SEQ_ENTITIES
Setup Forms and Programs
FUN_SEQ_HEADERS
Setup Forms and Programs
FUN_SEQ_REQUESTS
Setup Forms and Programs
FUN_SEQ_RULES
Setup Forms and Programs
FUN_SEQ_VERSIONS
Setup Forms and Programs
GL_ACCESS_SET_ASSIGNMENTS
Setup Forms and Programs
GL_ACCESS_SET_NORM_ASSIGN
Setup Forms and Programs
GL_ACCESS_SETS
Setup Forms and Programs
GL_AUTOREV_CRITERIA_SETS
Journal Entry
GL_BC_PACKETS_HISTS
Budgets and related objects
GL_BUDORG_BC_OPTIONS
Budgets and related objects
GL_COA_MAPPINGS
Consolidation and Eliminations
GL_DEFAS_ACCESS_SETS
Setup Forms and Programs
GL_DEFAS_ASSIGNMENTS
Setup Forms and Programs
GL_DEFAS_RESP_ASSIGN
Setup Forms and Programs
GL_JE_INCLUSION_RULES
Setup Forms and Programs
GL_JE_LINES_RECON
Reconciliation
GL_JE_SEGMENT_VALUES
Journal Entry
GL_LE_VALUE_SETS
Setup Forms and Programs
GL_LEDGER_CONFIG_DETAILS
Setup Forms and Programs
GL_LEDGER_CONFIGURATIONS
Setup Forms and Programs
GL_LEDGER_NORM_SEG_VALS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
Setup Forms and Programs
GL_LEDGER_SEGMENT_VALUES
Setup Forms and Programs
GL_LEDGER_SET_ASSIGNMENTS
Setup Forms and Programs
GL_LEDGER_SET_NORM_ASSIGN
Setup Forms and Programs
GL_LEDGER_SET_REQUESTS
Setup Forms and Programs
GL_LEDGERS
Setup Forms and Programs
GL_LEGAL_ENTITIES_BSVS
Setup Forms and Programs
GL_MGT_SEG_UPGRADE
Other Issues
GL_MGT_SEG_UPGRADE_H
Other Issues
GL_SEG_VAL_HIERARCHIES
Setup Forms and Programs
GL_SEG_VAL_NORM_HIERARCHY
Setup Forms and Programs
GL_SUMMARY_BC_OPTIONS
Budgets and related objects

 

1.2 Changed Tables

The set_of_books_id column has been renamed to ledger_id in all tables with some exceptions as mentioned below.  All setups secured by definition access sets have a new security_flag column in the relevant tables. 
Table Name


Feature Area


Brief Description of Change


GL_ALLOC_FORMULAS
MassAllocations, Budgets and Encumbrances
Add currency_conversion_type to support foreign currency allocations
GL_AUTO_ALLOC_SETS
MassAllocations, Budgets and Encumbrances
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoAllocations across ledgers sharing the same chart of accounts and calendar
GL_AUTOMATIC_POSTING_OPTIONS
Posting
Add ledger_id to enable AutoPost across ledgers
GL_AUTOMATIC_POSTING_SETS 
Posting
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoPost Criteria Sets across ledgers sharing the same chart of accounts and calendar
GL_AUTOREVERSE_OPTIONS
Journal Entry
Add criteria_set_id to support AutoReverse criteria sets stored in the master table GL_AUTOREV_CRITERIA_SETS
GL_BALANCES
Balances and Related Objects
Add quarter_to_date_dr_beq, quarter_to_date_cr_beq, project_to_date_dr_beq and project_to_date_cr_beq to store entered ledger currency balances
GL_CODE_COMBINATIONS
Setup Forms and Programs
Add alternate_code_combination_id to support replacement for disabled accounts functionality implemented by Journal Import
GL_CONSOLIDATION
Consolidation and Eliminations
Add coa_mapping_id to enable consolidations to use chart of accounts mappings
GL_INTERFACE
Journal Import
Add ledger_id and retain set_of_books_id for backward compatibility
GL_JE_BATCHES
Journal Entry
Drop set_of_books_id and add chart_of_accounts_id, period_set_name and accounting_period_type to support batches containing journals for multiple ledgers sharing the same chart of accounts and calendar
GL_JE_HEADERS
Journal Entry
Add columns to store the accounting and reporting sequences
GL_PERIOD_STATUSES
Setup Forms and Programs
Add ledger_id and retain set_of_books_id for backward compatibility
GL_RECURRING_HEADERS
Recurring Journals and Budgets
Add currency_conversion_type to support foreign currency recurring journals
GL_SYSTEM_USAGES
Setup Forms and Programs
Add efb_upgrade_flag and reconciliation_upg_flag to track successfully completed optional post-update programs

 

2.3 Obsolete Tables

 

None of the obsolete tables have been dropped.  Some obsolete tables have been renamed with the suffix _11i.  Some obsolete tables are highlighted below.
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

 

2.4 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

2.5 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



2.6 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

R12 Purchasing changes


 Purchasing



9.1 New Tables

Table Name                                 
Feature Area                                          
Professional Buyer’s Work Center
PO_DRAFTS
Draft Architecture (see “Technical Architecture Considerations” below)
PO_HEADERS_DRAFT_ALL
Draft Architecture
PO_LINES_DRAFT_ALL
Draft Architecture
PO_LINE_LOCATIONS_DRAFT_ALL
Draft Architecture
PO_DISTRIBUTIONS_DRAFT_ALL
Draft Architecture
PO_GA_ORG_ASSIGN_DRAFT
Draft Architecture
PO_PRICE_DIFF_DRAFT
Draft Architecture
PO_NOTIFICATION_CTRL_DRAFT
Draft Architecture
PO_ATTRIBUTE_VALUES_DRAFT
Draft Architecture
PO_ATTRIBUTE_VALUES_TLP_DRAFT
Draft Architecture
Enhanced Catalog Access
PO_ATTRIBUTE_VALUES
Item attributes in Unified Catalog
PO_ATTRIBUTE_VALUES_TLP
Item attributes in Unified Catalog
PO_ATTR_VALUES_INTERFACE
Item attributes in Unified Catalog
PO_ATTR_VALUES_TLP_INTERFACE
Item attributes in Unified Catalog
PO_ATTR_VALUES_ARCHIVE
Item attributes in Unified Catalog
PO_ATTR_VALUES_TLP_ARCHIVE
Item attributes in Unified Catalog
Document Styles
 PO_DOC_STYLE_HEADERS
Document Styles
 PO_DOC_STYLE_VALUES
Document Styles
 PO_DOC_STYLE_LINES_B
Document Styles
 PO_DOC_STYLE_LINES_TL
Document Styles
New User Interface for Oracle Purchasing Setups
PO_CHANGE_ORDER_TOLERANCES_ALL
Tolerances 

Uptake Subledger Accounting for Funds Control

PO_BC_DISTRIBUTIONS
 Uptake Subledger Accounting for Funds Control
Purchase Document Open Interface Enhancements
PO_LINE_LOCATIONS_INTERFACE
Interface table for price breaks and standard PO shipments 
 PO_ATTR_VALUES_INTERFACE
Interface table for line non-translatable attribute values 
 PO_ATTR_VALUES_TLP_INTERFACE
 Interface table for line translatable attribute values 

9.2 Changed Tables

Table Name                                 
Feature Area                                          
Brief Description of Change                                                                  
Professional Buyer’s Work Center
 PO_HEADERS_ALL
PO Communication Details
Added columns (SUPPLIER_NOTIF_METHOD, FAX, EMAIL_ADDRESS) for capturing the Communication Details specified for a PO on the Create/Update Order page.
 PO_HEADERS_ARCHIVE_ALL
PO Communication Details
As above.
Enhanced Catalog Access
 PO_HEADERS_ALL
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
 PO_HEADERS_ARCHIVE_ALL
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
 PO_HEADERS_INTERFACE
Unified Catalog
Added new columns:
created_language
cpa_reference
last_updated_program
PO_LINES_ALL
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
last_updated_program
PO_LINES_ARCHIVE_ALL
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
last_updated_program
PO_LINES_INTERFACE
Unified Catalog
Added new columns:
catalog_name
supplier_part_auxid
ip_category_id
processing_id
PO_REQEXPRESS_LINES_ALL
Unified Catalog
Added new columns:
ip_category_id
last_updated_program
PO_INTERFACE_ERRORS
Unified Catalog
Added new column:
column_value
Document Styles
 PO_HEADERS_ALL
Document Styles
Added the STYLE_ID column for capturing the style of each document.
 PO_HEADERS_ARCHIVE_ALL
Document Styles
As above.
 PO_HEADERS_INTERACE
Document Styles
As above.
Procurement for Complex Services 
PO_LINES_ALL
 Complex Work Procurement
Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

PO_LINES_DRAFT_ALL
 Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

 PO_LINES_INTERFACE
  Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)
  • ADVANCE_AMOUNT(The amount of upfront financing provided as an Advance against this Contract line.)

PO_LINES_ARCHIVE_ALL
Complex Work Procurement
 Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments)
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

PO_LINE_LOCATIONS_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_DRAFT_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_ARCHIVE_ALL
Complex Work Procurement
Addition of the following Columns :
  • VALUE_BASIS(
  • MATCHING_BASIS
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
  • AMOUNT_SHIPPED
PO_LINE_LOCATIONS_INTERFACE
Complex Work Procurement
Addition of the following Columns :
  • PAYMENT_TYPE
  • DESCRIPTION
  • WORK_APPROVER_NAME
  • WORK_APPROVER_ID
  • BID_PAYMENT_ID
  • AUCTION_PAYMENT_ID   
PO_DISTRIBUTIONS_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
PO_DISTRIBUTIONS_DRAFT_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
PO_DISTRIBUTIONS_ARCHIVE_ALL
Complex Work Procurement
Addition of the following Columns :
  • QUANTITY_FINANCED
  • AMOUNT_FINANCED
  • QUANTITY_RECOUPED
  • AMOUNT_RECOUPED
  • RETAINAGE_WITHHELD_AMOUNT
  • RETAINAGE_RELEASED_AMOUNT
E-Business Tax
PO_HEADERS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_LINES_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_LINE_LOCATIONS_ALL
E-Business Tax Integration
Added columns tax_attribute_update_code and original_shipment_id
 PO_DISTRIBUTIONS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQUISITION_HEADERS_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQISITION_LINES_ALL
E-Business Tax Integration
Added columns tax_attribute_update_code and tax_name
 PO_RELEASES_ALL
E-Business Tax Integration
Added column tax_attribute_update_code
 PO_REQUISITIONS_INTERFACE_ALL
E-Business Tax Integration
Added column tax_name
Communicate Document Attachments to Suppliers
PO_SYSTEM_PARAMETERS_ALL
Zipped file attachments
Added columns (MAX_ATTACHMENT_SIZE and EMAIL_ATTACHMENT_FILENAME) for capturing the details regarding the zip file generated for the file attachments.  These correspond to the values stored during Setup
New User Interface for Oracle Purchasing Setups
PO_SYSTEM_PARAMETERS_ALL
Zipped file attachments in Purchasing Options Page
Added columns (MAX_ATTACHMENT_SIZE and EMAIL_ATTACHMENT_FILENAME) for capturing the details regarding the zip file generated for the file attachments

Uptake Subledger Accounting for Funds Control

PO_ENCUMBRANCE_GT
 SLA: Uptake Subledger Accounting for Funds Control
Added new columns like value_basis, payment_type to accommodate Complex Work uptake and  entered_amount, gl_period_date to accommodate new requirements for SLA.
 PO_ONLINE_REPORT_TEXT
SLA: Uptake Subledger Accounting for Funds Control
 Added the columns show_in_psa_flag, segment1, distribution_type to add support for reporting PO errors through the new SLA OA page(PSA: Budgetary Control Results Page).
Purchase Document Open Interface Enhancements
PO_HEADERS_INTERFACE
PDOI Processing
Add columns to support catalog upload as well as PDOI bulk processing
 PO_LINES_INTERFACE
PDOI Processing
Add columns to support catalog upload as well as PDOI bulk processing
 PO_DISTRIBUTIONS_INTERFACE
PDOI Processing
Add columns to support PDOI bulk processing
PO_PRICE_DIFF_INTERFACE
PDOI Processing
Add columns to support PDOI bulk processing
Charge Based Shikyu - Impacts to Purchasing
 PO_LINE_LOCATIONS_ALL
shikyu
Added a not null column OUTSOURCED_ASSEMBLY for capturing whether the item is a shikyu or not..
 PO_LINE_LOCATIONS_ARCHIVE_ALL
shikyu
As above.
PO_LINE_LOCATIONS_DRAFT_ALL
shikyu
As above.
Requisition Fulfillment - DBI
PO_HEADERS_ALL

Added column SUBMIT_DATE to record the date when purchase order is submitted for approval.
PO_HEADERS_ARCHIVE_ALL

Added column SUBMIT_DATE to record the date when purchase order is submitted for approval.
PO_REQUISITION_HEADERS_ALL

Added column APPROVED_DATE to record the approval date of the requisition.
PO_RELEASES_ALL

Added column SUBMIT_DATE to record the date when release is submitted for approval.
PO_LINE_LOCATIONS_ALL

Added columns SHIPMENT_CLOSED_DATE, CLOSED_FOR_INVOICE_DATE, and CLOSED_FOR_RECEIVING_DATE to record the various dates in lifetime of a requisition line.
PO_LINE_LOCATIONS_ARCHIVE_ALL

Added columns SHIPMENT_CLOSED_DATE, CLOSED_FOR_INVOICE_DATE, and CLOSED_FOR_RECEIVING_DATE to record the various dates in lifetime of a requisition line.

9.3 Obsoleted Tables

Table Name                                 
Feature Area                                          
Optional - Replaced By                                                                  
none








 9.4 New Views

View Name                                 
Feature Area                                          
Professional Buyer’s Work Center
PO_HEADERS_MERGE_V
Draft Architecture
PO_LINES_MERGE_V
Draft Architecture
PO_LINE_LOCATIONS_MERGE_V
Draft Architecture
PO_DISTRIBUTIONS_MERGE_V
Draft Architecture
PO_GA_ORG_ASSIGN_MERGE_V
Draft Architecture
PO_PRICE_DIFF_MERGE_V
Draft Architecture
PO_NOTIFICATION_CTRL_MERGE_V
Draft Architecture
PO_ATTR_VALUES_MERGE_V
Draft Architecture
PO_ATTR_VALUES_TLP_MERGE_V
Draft Architecture
Document Styles
 PO_DOC_STYLE_LINES_VL
Document Styles
 PO_ALL_DOC_STYLE_LINES
Document Styles
PO_STYLE_ENABLED_LINE_TYPES
Document Styles
PO_STYLE_ENABLED_PAY_ITEMS
Document Styles
PO_STYLE_ENABLED_PUR_BASES
Document Styles

Uptake Subledger Accounting for Funds Control

 PO_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control
PO_DISTS_REF_V
Uptake Subledger Accounting for Funds Control
PO_EXTRACT_HEADER_V
Uptake Subledger Accounting for Funds Control
PO_HEADERS_REF_V
Uptake Subledger Accounting for Funds Control
PO_LINES_REF_V
Uptake Subledger Accounting for Funds Control
PO_LINE_LOCATIONS_REF_V
Uptake Subledger Accounting for Funds Control
PO_RELEASE_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_REQ_DISTS_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control
PO_REQ_HEADERS_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_LINES_REF_V
Uptake Subledger Accounting for Funds Control
PO_REQ_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_TRANSACTION_V
Uptake Subledger Accounting for Funds Control
PO_REQ_EXTRACT_HEADER_V
Uptake Subledger Accounting for Funds Control
PO_RELEASES_REF_V
Uptake Subledger Accounting for Funds Control
 PO_EXTRACT_DETAIL_V
Uptake Subledger Accounting for Funds Control

9.5 Changed Views

View Name                                 
Feature Area                                          
Brief Description of Change                                                                  

Multi-Org Access Control

 PO_REQUISITION_LINES_MRC_V

  • Added ORG_ID
  • Removed the references to client_info
  • Only driving table would have secured synonym so that the security policy function is invoked just once, rest of the tables should be base tables (_ALL tables).
  • Join for ORG_ID across _ALL tables if the table UK/PK includes ORG_ID. Example for this would be PO_DOCUMENT_TYPES that needs ORG_ID join when joining to other tables with Document Type / Subtype.
  • Removed NVL for ORG_ID joins
 PO_EMPLOYEE_HIERARCHIES

 Same as above
 PO_ALERT_BLANKET_VIEW

  Same as above
PO_ALERT_CONTRACT_VIEW

 Same as above
PO_ALERT_CONTRACT_VIEW2

 Same as above
PO_ALERT_PLANNED_VIEW

 Same as above
PO_ALERT_SCHEDULED_VIEW

 Same as above
PO_AP_RECEIPT_MATCH_V

 Same as above
PO_AP_RETROACTIVE_DIST_V

 Same as above
PO_APPROVED_SUPPLIER_LIST_V

 Same as above
PO_ASL_SUPPLIERS_V

 Same as above
PO_AUTOSOURCE_DOCUMENTS_V

 Same as above
PO_AUTOSOURCE_RULES_V

 Same as above
PO_BY_BUYER_V

 Same as above
PO_CATALOG_QUOTES_ALL_V

 Same as above
PO_CONTRACTS_VAL_V

 Same as above
PO_DISTRIBUTIONS_AP_V

 Same as above
PO_DISTRIBUTIONS_AP2_V

 Same as above
PO_DISTRIBUTIONS_INQ_V

 Same as above
PO_DISTRIBUTIONS_MRC_V

 Same as above
PO_DISTRIBUTIONS_PRINT

 Same as above
PO_DISTRIBUTIONS_V

 Same as above
PO_DOCUMENT_HEADERS_VIEW

 Same as above
PO_DOCUMENT_TYPES_ALL_VL

 Same as above
PO_DOCUMENT_TYPES_V

 Same as above
PO_DOCUMENT_TYPES_VL

 Same as above
PO_EMPLOYEE_HIERARCHIES_ALL_V

 Same as above
PO_ENC_AEL_GL_V

 Same as above
PO_HEADER_RELEASE_V

 Same as above
PO_HEADERS_AP_V

 Same as above
PO_HEADERS_CHANGE_PRINT

 Same as above
PO_HEADERS_INQ_PO_V

 Same as above
PO_HEADERS_INQ_REL_V

 Same as above
PO_HEADERS_INQ_V

 Same as above
PO_HEADERS_MRC_V

 Same as above
PO_HEADERS_PRINT

 Same as above
PO_HEADERS_RFQQT_V

 Same as above
PO_HEADERS_V

 Same as above
PO_HEADERS_VIEW

 Same as above
PO_IMPORT_SOURCES_V

 Same as above
PO_ITEM_HISTORY_V

 Same as above
PO_ITEM_SOURCES

 Same as above
PO_LINE_LOCATIONS_AP_V

 Same as above
PO_LINE_LOCATIONS_CHANGE_PRINT

 Same as above
PO_LINE_LOCATIONS_INQ_V

 Same as above
PO_LINE_LOCATIONS_PRINT

 Same as above
PO_LINE_LOCATIONS_RELEASE_V

 Same as above
PO_LINE_LOCATIONS_RFQQT_V

 Same as above
PO_LINE_LOCATIONS_V

 Same as above
PO_LINES_ALL_V

 Same as above
PO_LINES_AP_V

 Same as above
PO_LINES_ARCHIVE_XML

 Same as above
PO_LINES_CHANGE_PRINT

 Same as above
PO_LINES_INQ_V

 Same as above
PO_LINES_PRINT

 Same as above
PO_LINES_RELEASE_ITEMS_V

 Same as above
PO_LINES_RFQQT_V

 Same as above
PO_LINES_SUPPLIER_ITEMS_ALL_V

 Same as above
PO_LINES_SUPPLIER_ITEMS_V

 Same as above
PO_LINES_V

 Same as above
PO_LINES_VAL_V

 Same as above
PO_LINES_XML

 Same as above
PO_MASSCANCEL_INTERIM_V

 Same as above
PO_NEGOTIATED_SOURCES_V

 Same as above
PO_NOTIFICATION_DETAILS_V

 Same as above
PO_OWNED_LINES

 Same as above
PO_OWNED_REQUISITION_LINES

 Same as above
PO_OWNED_SHIPMENTS

 Same as above
PO_POS_ALL_V

 Same as above
PO_POS_VAL_V

 Same as above
PO_PURCHASE_HISTORY_V

 Same as above
PO_PURCHASE_ORDER_V

 Same as above
PO_QUOTATION_APPROVALS_V

 Same as above
PO_QUOTATIONS_TO_APPROVE

 Same as above
PO_REL_LINE_V

 Same as above
PO_REL_TAX_LINES_SUMMARY_V

 Same as above
PO_RELEASES_V

 Same as above
PO_RELEASES_VAL_V

 Same as above
PO_REQ_DISTRIBUTIONS_V

 Same as above
PO_REQ_TAX_LINES_SUMMARY_V

 Same as above
PO_REQEXPRESS_LINES_V

 Same as above
PO_REQS_IN_POOL_V

 Same as above
PO_REQS_IN_TRANSIT_ALL_V

 Same as above
PO_REQUISITION_HEADERS_ALL_V

 Same as above
PO_REQUISITION_HEADERS_INQ_V

 Same as above
PO_REQUISITION_HEADERS_V

 Same as above
PO_REQUISITION_LINES_INQ_V

 Same as above
PO_REQUISITION_LINES_V

 Same as above
PO_REQUISITION_TEMPLATES_V

 Same as above
PO_RFQ_HEADERS_PRINT

 Same as above
PO_RFQ_LINE_LOCATIONS_PRINT

 Same as above
PO_RFQ_LINES_PRINT

 Same as above
PO_RFQ_VENDORS_V

 Same as above
PO_RFQQT_DOCUMENT_TYPES_ALL_V

 Same as above
PO_RFQS_ALL_V

 Same as above
PO_RFQS_FOR_QUOTE_ALL_V

 Same as above
PO_RFQS_VAL_V

 Same as above
PO_RULE_EXPENSE_ACCOUNTS_V

 Same as above
PO_SHIPMENTS_ALL_V

 Same as above
PO_SHIPMENTS_AP_V

 Same as above
PO_SHIPMENTS_VAL_V

 Same as above
PO_SOURCE_SHIPMENT_NUM_V

 Same as above
PO_SOURCE_VENDORS_V

 Same as above
PO_SUPPLIER_OPEN_POS_V

 Same as above
PO_SUPPLIER_PO_SITES_VAL_V

 Same as above
PO_SUPPLIER_SITES_VAL_V

 Same as above
PO_TAX_CODES_SUMMARY_V

 Same as above
PO_TAX_DISTRIBUTIONS_DETAIL_V

 Same as above
PO_TAX_HEADERS_DETAIL_V

 Same as above
PO_TAX_LINES_DETAIL_V

 Same as above
PO_TAX_LINES_SUMMARY_V

 Same as above
PO_TAX_SHIPMENTS_DETAIL_V

 Same as above
PO_VENDOR_LIST_ENTRIES_V

 Same as above
PO_VENDOR_SITES_ALL_V

 Same as above
PO_VENDOR_SITES_AP_V

 Same as above
PO_VENDOR_SITES_PAY_AP_V

 Same as above
PO_WF_NOTIFICATIONS_V

 Same as above
POFV_REQUISITIONS

 Same as above
Support for Contractor Purchasing Users
 HR_EMPLOYEES
 Contingent Worker Uptake
Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
 HR_EMPLOYEES_CURRENT_V
 Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
 PO_BUYERS_VAL_V
 Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y
PO_BUYERS_ALL_V
Contingent Worker Uptake
 Modified to return contingent workers along with the employees, depending upon the HR Contingent Profile is set to Y

 

9.6 Obsoleted Views

View Name                                 
Feature Area                                          
Optional - Replaced By                                                                  

 Multi-Org Access Control

 PO_ACCRUAL_ACCOUNTS_TEMP

 PO_ACCRUAL_ACCOUNTS_TEMP Secured Synonym
 PO_ACCRUAL_RECONCILE_TEMP

 PO_ACCRUAL_RECONCILE_TEMP Secured Synonym
 PO_ACCRUAL_WRITE_OFFS

 PO_ACCRUAL_WRITE_OFFS Secured Synonym
PO_AUTOSOURCE_DOCUMENTS

PO_AUTOSOURCE_DOCUMENTS Secured Synonym
PO_CONTROL_GROUPS

PO_CONTROL_GROUPS Secured Synonym
PO_DISTRIBUTIONS

PO_DISTRIBUTIONS Secured Synonym
PO_DISTRIBUTIONS_ARCHIVE

PO_DISTRIBUTIONS_ARCHIVE Secured Synonym
PO_DOCUMENT_TYPES_B

PO_DOCUMENT_TYPES_B Secured Synonym
PO_DOCUMENT_TYPES_TL

PO_DOCUMENT_TYPES_TL Secured Synonym
PO_HEADERS

PO_HEADERS Secured Synonym
PO_HEADERS_ARCHIVE

PO_HEADERS_ARCHIVE Secured Synonym
PO_HISTORY_POS

PO_HISTORY_POS Secured Synonym
PO_HISTORY_REQUISITIONS

PO_HISTORY_REQUISITIONS Secured Synonym
PO_LINES

PO_LINES Secured Synonym
PO_LINES_ARCHIVE

PO_LINES_ARCHIVE Secured Synonym
PO_LINE_LOCATIONS

PO_LINE_LOCATIONS Secured Synonym
PO_LINE_LOCATIONS_ARCHIVE

PO_LINE_LOCATIONS_ARCHIVE Secured Synonym
PO_LOCATION_ASSOCIATIONS

PO_LOCATION_ASSOCIATIONS Secured Synonym
PO_MASSCANCEL_INCLUDES

PO_MASSCANCEL_INCLUDES Secured Synonym
PO_NOTIFICATIONS

PO_NOTIFICATIONS Secured Synonym
PO_POSITION_CONTROLS

PO_POSITION_CONTROLS Secured Synonym
PO_QUOTATION_APPROVALS

PO_QUOTATION_APPROVALS Secured Synonym
PO_RELEASES

PO_RELEASES Secured Synonym
PO_RELEASES_ARCHIVE

PO_RELEASES_ARCHIVE Secured Synonym
PO_REQEXPRESS_HEADERS

PO_REQEXPRESS_HEADERS Secured Synonym
PO_REQEXPRESS_LINES

PO_REQEXPRESS_LINES Secured Synonym
PO_REQUISITIONS_INTERFACE

PO_REQUISITIONS_INTERFACE Secured Synonym
PO_REQUISITION_HEADERS

PO_REQUISITION_HEADERS Secured Synonym
PO_REQUISITION_LINES

PO_REQUISITION_LINES Secured Synonym
PO_REQ_DISTRIBUTIONS

PO_REQ_DISTRIBUTIONS Secured Synonym
PO_REQ_DIST_INTERFACE

PO_REQ_DIST_INTERFACE Secured Synonym
PO_SYSTEM_PARAMETERS

PO_SYSTEM_PARAMETERS Secured Synonym
PO_UNIQUE_IDENTIFIER_CONTROL

PO_UNIQUE_IDENTIFIER_CONTROL Secured Synonym
E-Business Tax
PO_REQ_TAX_LINES_SUMMARY_V
 E-Business Tax Integration

 PO_REL_TAX_LINES_SUMMARY_V
 E-Business Tax Integration

 PO_TAX_LINES_SUMMARY_V
 E-Business Tax Integration