Oracle Advanced Planning Command Center Release Notes, Release 12.1.3.8

2. Documentation

This section provides information on the following topics:

2.1 Online Help and PDF Documentation
2.2 Technical Documentation
2.3 Integration Repository
2.4 Release Content Document
2.5 White Papers

2.1 Online Help and PDF Documentation

The consolidated documentation patch for Oracle E-Business Suite Release 12.1.3 is Patch 9239095. For the product families that are included in Release 12.1.3, the consolidated documentation patches are listed below:

Patch	Product Family
Patch 9400185	Applications Technology (ATG_PF)
Patch 9403775	Customer Relationship Management (CC_PF)
Patch 9403767	Financials (FIN_PF)
Patch 9401789	Human Resources (HR_PF)
Patch 9403759	Procurement (PRC_PF)
Patch 9403770	Projects (PJ_PF)
Patch 9403704	Supply Chain Management (SCM_PF)
Patch 9403751	Value Chain Planning (SCP_PF)

Oracle strongly recommend the installation of these patches.

In addition, the following Oracle Advanced Planning Command Center documentation is available as part of the Online Documentation Library on My Oracle Support (formerly MetaLink) and Oracle Technology Network for this release:

Oracle Advanced Planning Command Center User's Guide,
Part No. E12277-12, November 2010
HTML | PDF
Oracle Advanced Planning Command Center User's Guide Supplement,
Part No. E35592-02, September 2012
Oracle Value Chain Planning Installation Guide,
Part No. E21577-01, March 2011
HTML | PDF
Oracle Value Chain Planning Installation Guide Supplement,
Part No. E37632-01, September 2012
HTML | PDF

Documentation patches and Adobe Acrobat PDFs are cumulative; they include updated documentation for all Oracle Advanced Planning Command Center 12.1.3 changes.

2.2 Technical Documentation

The following technical documentation is available:

First-time TOI users: Follow the setup instructions in Document 403349.1.

2.2.1 Data Model Comparison Report

The EBS data model comparison report provides the database object definition changes between two EBS releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

For more information about the EBS Data Model Comparison report, see the EBS Data Model Comparison Report Overview Document 1290886.1.

2.2.2 EBS ATG Seed Data Comparison Report

The EBS ATG Seed Data Comparison Report provides the differences between two EBS releases by documenting the seed data changes delivered by the product data loader files (.ldt extension) based on the EBS ATG loader control files (.lct extension). This report enables advanced users to review changes prior to an upgrade.

For more information about the EBS ATG Seed Data Comparison Report, see Document 1327399.1.

2.3 Integration Repository

The Oracle Integration Repository is a compilation of information about the service endpoints displayed by the Oracle E-Business Suite of applications. It provides a complete catalog of Oracle E-Business Suite's business service interfaces. The tool lets users easily discover and deploy the appropriate business service interface for integration with any system, application, or business partner.

The Oracle Integration Repository is shipped as part of the E-Business Suite. As your instance is patched, the repository is automatically updated with content appropriate for the precise revisions of interfaces in your environment.

You can navigate to the Oracle Integration Repository through Oracle E-Business Suite Integrated SOA Gateway.

2.4 Release Content Document

Refer to Document 561580.1, Release Content Document for information about the features and enhancements for Oracle E-Business Suite Release 12.1.3.

2.5 White Papers

There are no relevant white papers for this product in this release.

3. New and Changed Features

In Release 12.1.3, Oracle Advanced Planning Command Center has added or changed the following features since its last release. For a complete list of new features within Oracle E-Business Suite Release 12.1.3, refer to the Document 561580.1, Release Content Document.

Use this section to access the following delta information for each feature:

New, Changed, Obsolete Components
Implementation Considerations
Customizations and Extensions
Minimum Level Requirements
Technology Stack Incompatibilities
Technology Architecture Considerations
Troubleshooting Tips

This release provides the following new features and enhancements:

3.1 Analysis of Inventory and Service Levels
3.2 Analysis of Excess and Obsolescence
3.3 Enhanced Sales and Operations Planning Dashboard
3.4 Supply Chain Risk Management Dashboard
3.5 Revenue Gap Analysis
3.6 Collaboration Workspaces for Unstructured Collaboration
3.7 Enhanced Exceptions Analysis
3.8 Integration with Rapid Planning
3.9 Material Plan User Interface
3.10 Resource Plan User Interface
3.11 Orders User Interface
3.12 Launch Plan from APCC Dashboard
3.13 Edit Item Simulation Set User Interface
3.14 OBIEE 11g Upgrade

3.1 Analysis of Inventory and Service Levels

Description

The current Supply Chain Analyst (SCA) dashboard in APCC has been enhanced with new measures and related reports to support Inventory Analysis workflows. The following new reports are included in a new tab in the SCA dashboard.

Inventory Performance Summary
Top N - Service Level Short Fall by Category
Top N - Inventory Value
Safety Stock - Postponement Analysis
Inventory Measures Trend
Inventory Measures Trend by Category-Organization

Some of the new measures introduced as part of this include the following:

Safety Stock (Days)
Percent Safety Stock - Demand Variability
Percent Safety Stock - Supplier Lead Time Variability
Percent Safety Stock - Manufacturing Lead Time Variability
Percent Safety Stock - Transportation Lead Time Variability

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Advanced Planning Command Center in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists windows and pages that are new.

New Window or Page Name	Technical Name	Description
Inventory Analysis	MSC_SCA_DASHBOARD	The new Inventory Analysis page is part of Supply Chain Analysis Dashboard.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

This table lists the new reports.

New Report Name	Technical Name	Description
Inventory Performance Summary	-	Provides information on the investment required to achieve a given service level and the profit that is derived from it.
Top N - Service Level Short Fall by Category	-	Reports Top N categories that have the greatest difference between achieved service level and target service level for a given plan.
Top N - Inventory Value	-	Displays projected inventory value.
Safety Stock - Postponement Analysis	-	Analysis of Inventory and Service Levels displays the material positioning across plans.
Inventory Measures Trend	-	Analyzes inventory performance using key measures of safety stock and service levels.
Inventory measures trend by Category-Organization	-	Analyzes inventory performance using key measures of safety stock and service levels for a given plan or organization.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customer generating APCC fact table files using third party tools, perform the following:

Refer to file templates is available in Load Fact Data page for file format.
Refer to APCC BI meta data repository (AdvancedPlanning.rpd) for usage of physical tables and columns.
Prepare APCC dimension data in APS operational data store by running collection.

Minimum Level Requirements

The following are required for this feature to function:

XML Development Kit

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCCconcurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.2 Analysis of Excess and Obsolescence

Description

The current Supply Chain Analyst (SCA) dashboard in APCC has been enhanced with new measures and related reports to support analysis of Excess and Obsolete inventory. The following new reports are included in the SCA dashboard.

Excess and Obsolescence Summary
Excess Details
Obsolescence Details
Excess Details across Plans
Obsolescence Details across Plans

Some of the new measures introduced as part of this include the following:

Demand within Obsolescence Horizon
Demand within Excess Horizon
Excess On-order in Units and Value in Multiple Currencies
Excess On-hand in Units and Value in Multiple Currencies
Obsolete On-order in Units and Value in Multiple Currencies
Obsolete On-hand in Units and Value in Multiple Currencies
Total Excess in Units and Value in Multiple Currencies
Total Obsolescence in Units and Value in Multiple Currencies

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

This table lists the windows and pages that are changed.

New Window or Page Name	Technical Name	Description
Supply Chain Analyst Dashboard	MSC_SCA_DASHBOARD	Added or updated OBIEE Answers to show Excess and Obsolescence data.
Sales and Operations Planning Analyst Dashboard	MSC_SOP_DASHBOARD	Added or updated OBIEE Answers to show Excess and Obsolescence data.
Supply Chain Risk Management Dashboard	MSC_SCRM_DASHBOARD	Added or updated OBIEE Answers to show Excess and Obsolescence data.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

This table lists the new tables.

Table Name	Description
MSC_ITEMS_F	New fact table at organization-item granularity, for Excess and Obsolescence measures.
MSC_ST_ITEMS_F	New interface table of MSC_ITEMS_F.

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

This table lists the new SQL Loader Files.

SQL Loader File Name	Description
MSC_ST_ITEMS_F.ctl	CTL for new interface table MSC_ST_ITEMS_F.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

This table lists the new profile options.

Profile Option Name	Feature Area	Description
MSC: APCC SNO Item Simulation Set	ETL	Item simulation set for SNO plans. APCC calculates SNO Excess and Obsolescence data based on E&O horizons defined in this item simulation set.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Advanced Planning Command Center in Release 12.1.3. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation section.

Define Excess and Obsolescence horizons for each item in a item simulation set.
Assign item simulation set to plans, or set profile option "MSC: APCC SNO Item Simulation Set" to it for SNO plans.
Launch plan and archive to APCC.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

MSC_ITEMS_F Doesn't have much extra space requirement since it doesn't have date context.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customer generating APCC fact table files using third party tools, perform the following:

Refer to file templates is available in Load Fact Data page for file format.
Refer to APCC BI meta data repository (AdvancedPlanning.rpd) for usage of physical tables and columns.
Prepare APCC dimension data in APS operational data store by running collection.

Minimum Level Requirements

The following are required for this feature to function properly:

XML Development Kit

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCC concurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.3 Enhanced Sales and Operations Planning Dashboard

Description

The Sales and Operations Planning (S&OP) dashboard is enhanced to include the following new measures:

Shipment history - Lag by 52 week
Operating Plan
Financial Forecast

In addition, the existing reports have been updated with new usability enhancements and new navigations to more drill-down reports. Also, a new tab called Financial Review has been added with the following reports:

Financial Summary
Operating Plan and Financial Forecast Comparison
Top % Difference - Operating Plan and Budget by Category
Financial Trend Analysis
Profit & Loss Monthly
Margin Difference by Category
Year-over-Year Financials
Financial Forecast and Budget Comparison
Top % Difference - Budget and Annual Plan by Organization
Top Revenue
Cost by Organization
Bottom Margin
Profitability KPI
Cost Breakdown KPI

This new Financial Review page enables planners and executives to answer questions like:

Are we on plan financially?
How are product categories performing financially?
What has changed financially since last fiscal quarter/month?
How/Where/Why has profitability changed?
Is there any need to revise financial forecast?

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists windows and pages that are new.

New Window or Page Name	Technical Name	Description
Financial Review	MSC_SOP_DASHBOARD	Financial Review is a new page in S&OP Dashboard.

Changed Windows or Pages

This table lists the windows and pages that are changed.

Changed Window or Page Name	Technical Name	Description
Executive Review	-	Page layout changed for Fiscal Year from drop-down to multi-select.
Demand Review	-	S&OP Dashboard page reports changes.
Supply Review	-	S&OP Dashboard page reports changes.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

This table lists the new reports.

New Report Name	Technical Name	Description
Top difference - Operating Plan and Financial Forecast by Category	-	Report on S&OP Dashboard Executive Review page
Top Abs Diff - Consensus and Financial Forecast by Category	-	Report on S&OP Dashboard Demand Review page.
Financial Summary	-	Report on S&OP Dashboard Financial Review page.
Operating Plan and Financial Forecast Comparison	-	Report on S&OP Dashboard Financial Review page
Top % Difference - Operating Plan and Budget by Category	-	Report on S&OP Dashboard Financial Review page
Financial Trend Analysis	-	Report on S&OP Dashboard Financial Review page
Profit & Loss Monthly	-	Report on S&OP Dashboard Financial Review page.
Margin Difference by Category	-	Report on S&OP Dashboard Financial Review page.
Financial Forecast and Budget Comparison	-	Report on S&OP Dashboard Financial Review page.
Top % Difference - Budget and Annual Plan by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Revenue	-	Report on S&OP Dashboard Financial Review page.
Cost by Organization	-	Report on S&OP Dashboard Financial Review page.
Bottom Margin	-	Report on S&OP Dashboard Financial Review page.
Financial Trend Analysis	-	Report on S&OP Dashboard Financial Review page.
Top % Difference - Operating Plan and Budget by Organization	-	Report on S&OP Dashboard Financial Review page.
Top % Difference - Budget and Annual Plan by Category	-	Report on S&OP Dashboard Financial Review page.
Margin % by Category	-	Report on S&OP Dashboard Financial Review page.
Top Revenue by Category	-	Report on S&OP Dashboard Financial Review page.
Top Revenue by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Revenue by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Revenue by Customer Zone	-	Report on S&OP Dashboard Financial Review page.
Bottom Margin by Customer	-	Report on S&OP Dashboard Financial Review page.
Bottom Margin by Category	-	Report on S&OP Dashboard Financial Review page.
Bottom Margin by Organization	-	Report on S&OP Dashboard Financial Review page.
Bottom Margin by Customer Zone	-	Report on S&OP Dashboard Financial Review page.
Top Margin by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Margin by Category	-	Report on S&OP Dashboard Financial Review page.
Top Margin by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Margin by Customer Zone	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Operating Plan and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Operating Plan and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Operating Plan and Financial Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Operating Plan and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Operating Plan and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Operating Plan and Financial Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Financial Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Consensus and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Consensus and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Consensus and Financial Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Budget and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Budget and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Budget and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Budget and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Annual Plan and Budget by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Annual Plan and Budget by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Annual Plan and Budget by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Annual Plan and Budget by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Final Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Final Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Final Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Consensus and Final Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff (Currency) - Consensus and Final Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Consensus and Final Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Consensus and Final Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Consensus and Final Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff - Consensus and Final Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff - Consensus and Final Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Consensus and Sales Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Sales Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Consensus and Marketing Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff (Currency) - Consensus and Marketing Forecast by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Attained % by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Attained % by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Attained % by Item	-	Report on S&OP Dashboard Financial Review page.
Bottom Attained % by Customer	-	Report on S&OP Dashboard Financial Review page.
Bottom Attained % by Organization	-	Report on S&OP Dashboard Financial Review page.
Bottom Attained % by Item	-	Report on S&OP Dashboard Financial Review page.
Inventory Plan Trend	-	Report on S&OP Dashboard Financial Review page.
Top Demand by Category	-	Report on S&OP Dashboard Financial Review page.
Top Demand by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Demand by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Actual On-Hand by Category	-	Report on S&OP Dashboard Financial Review page.
Top Actual On-Hand by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Category Summary	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Organization Summary	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Customer Summary	-	Report on S&OP Dashboard Financial Review page.
Shipment History Trend	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Category Detail	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Organization Detail	-	Report on S&OP Dashboard Financial Review page.
Top Abs Diff - Shipments versus Year Ago by Customer Detail	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff - Consensus and Shipments by Category Summary	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff - Consensus and Shipments by Organization Summary	-	Report on S&OP Dashboard Financial Review page.
Top Abs % Diff - Consensus and Shipments by Customer Summary	-	Report on S&OP Dashboard Financial Review page.
WIP Start Quantity Trend	-	Report on S&OP Dashboard Financial Review page.
Top WIP Start Quantity by Category	-	Report on S&OP Dashboard Financial Review page.
Top Actual On-Hand by Organization	-	Report on S&OP Dashboard Financial Review page.
Margin Scenario Comparison Trend	-	Report on S&OP Dashboard Financial Review page.
Revenue Scenario Comparison Trend	-	Report on S&OP Dashboard Financial Review page.
Top Difference - Annual Plan and Budget by Category	-	Report on S&OP Dashboard Financial Review page.
Top Difference - Annual Plan and Budget by Organization	-	Report on S&OP Dashboard Financial Review page.
Excess Value by Category	-	Report on S&OP Dashboard Financial Review page.
Excess Value by Organization	-	Report on S&OP Dashboard Financial Review page.
Obsolescence Value by Category	-	Report on S&OP Dashboard Financial Review page.
Obsolescence Value by Organization	-	Report on S&OP Dashboard Financial Review page.
Top Shipment History by Category	-	Report on S&OP Dashboard Financial Review page.
Top Shipment History by Customer	-	Report on S&OP Dashboard Financial Review page.
Top Shipment History by Organization	-	Report on S&OP Dashboard Financial Review page.
Quarter Comparison - Operating Plan and Financial Forecast by Category	-	Report on S&OP Dashboard Financial Review page.
Quarter Comparison - Operating Plan and Financial Forecast by Organization	-	Report on S&OP Dashboard Financial Review page.
Year-over-Year Financials by Organization	-	Report on S&OP Dashboard Financial Review page.
Year-over-Year Financials by Category	-	Report on S&OP Dashboard Financial Review page.

Changed Reports

This table lists the changed reports.

Changed Report Name	Technical Name	Description
Executive Summary	-	Executive Summary part of S&OP Executive Review page.
Consensus Forecast Difference by Customer	-	Report on S&OP Dashboard Executive Review page.
Profitability KPI	-	Report on S&OP Dashboard Executive Review page.
Profit and Loss Statement	-	Report on S&OP Dashboard Executive Review page.
Constrained Forecast Comparison	-	Report on S&OP Dashboard Executive Review page.
Budget Analysis	-	Report on S&OP Dashboard Executive Review page.
Demand Summary	-	Report on S&OP Dashboard Demand Review page.
Forecast - Scenario Comparison	-	Report on S&OP Dashboard Demand Review page.
Forecast Comparison	-	Report on S&OP Dashboard Demand Review page
Consensus Tracking by Category	-	Report on S&OP Dashboard Demand Review page
Supply summary	-	Report on S&OP Dashboard Supply Review page.
Bottom Demand Fill % by Customer	-	Report on S&OP Dashboard Supply Review page.
Supply Change by Category	-	Report on S&OP Dashboard Supply Review page.
Production Plan	-	Report on S&OP Dashboard Supply Review page.
Top - Supplier Item Utilization	-	Report on S&OP Dashboard Supply Review page
IO Plans	-	Report on S&OP Dashboard Supply Review page.
Profit and Loss Statement by Fiscal Period	-	Report on S&OP Dashboard Financial Review page.
Forecast Comparison Trend	-	Report on S&OP Dashboard Financial Review page.
Consolidated Analysis by Fiscal Period	-	Report on S&OP Dashboard Financial Review page.
Bottom - Consensus Fcst MAPE 8 week lag by Category/Customer/Org/Item	-	Report on S&OP Dashboard Financial Review page.
Sourcing by Category - Supplied Ratio	-	Report on S&OP Dashboard Financial Review page.
Item Supplier Capacity	-	Report on S&OP Dashboard Financial Review page.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customer generating APCC fact table files using third party tools, perform the following:

Refer to file templates is available in Load Fact Data page for file format.
Refer to APCC BI meta data repository (AdvancedPlanning.rpd) for usage of physical tables and columns.
Prepare APCC dimension data in APS operational data store by running collection.

Minimum Level Requirements

The following are required for this feature to function properly:

XML Development Kit

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCC concurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.4 Supply Chain Risk Management Dashboard

Description

The Supply Chain Risk Management (SCRM) dashboard is a new dashboard and enables users to review and compare key metrics in a single interface, providing true Enterprise Planning capabilities to the SCRM discipline.

It enables executives and planners to answer questions like:

What is the impact to my margins if there is a sudden drop in demand?
When do I return to profitability?
What is the cost difference between sourcing strategies in the event of the demand drop?
What impact does increased lead times have on my inventory strategy?
What is the impact of off-shoring to my Total Delivered Cost?
What is the impact of off-shoring to my Margins?

The following new measures are introduced as part of this feature:

Facility Startup/Shutdown Costs
Fixed Costs
Count of Sources
Carrying Cost without Postponement
Safety Stock without Postponement
Inventory Budget
Product Miles

The dashboard contains four different tabs: Executive Review, Inventory Analysis, Supply Chain Sourcing and Glossary.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists windows and pages that are new.

New Window or Page Name	Technical Name	Description
Supply Chain Risk Management Dashboard	MSC_SCRM_DASHBOARD	Supply Chain Risk Management Dashboard

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

This table lists the new tables.

Table Name	Description
MSC_BIS_ORG_DETAIL	New PDS table, stores SNO facility costs.
MSC_COSTS_F	New fact table at organization-item-supplier-customer-ship_method-source_org-date granularity, to support SNO costs KPI measures.
MSC_ST_COSTS_F	New interface table of MSC_COSTS_F.

Changed Tables

This table lists the changed tables.

Table Name	Description
MSC_BIS_INV_DETAIL	Added customer references.
MSC_ITEM_INVENTORY_F	Removed costs KPI measures, they are moved to MSC_COSTS_F for more dimension support.
MSC_ST_ITEM_INVENTORY_F	Interface table updated accordingly, based on MSC_ITEM_INVENTORY_F changes.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

This table lists the new SQL Loader Files.

SQL Loader File Name	Description
MSC_ST_COSTS_F.ctl	CTL for new interface table MSC_ST_COSTS_F.

Changed SQL Loader Files

This table lists the changed SQL Loader Files.

SQL Loader File Name	Description
MSC_ST_ITEM_INVENTORY_F.ctl	CTL for new interface table MSC_ST_ITEM_INVENTORY_F.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

This table lists the new profile options.

Profile Option Name	Feature Area	Description
MSC: APCC SNO Item Simulation Set	ETL	Item simulation set for SNO plans. APCC calculates SNO Excess and Obsolescence data based on E&O horizons defined in this item simulation set.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

Setup OBIEE, RPD and webcat, same as 12.1.

Set up translated messages, follow the steps in the readme of translation Patch 8629912 for R12.MSC.B to get all RPD strings loaded into DB.

Upgrade Considerations

Apply RDBMS Patch 7330434 to avoid ORA-600 errors while refreshing materialized views.

Sizing

Table Space Considerations

MSC_COSTS_F - rough estimates for each plan archival, number of number_of_rows = org-item-day * 0.41, avg_row_length = 189.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customer generating APCC fact table files using third party tools, perform the following:

Refer to file templates is available in Load Fact Data page for file format.
Refer to APCC BI meta data repository (AdvancedPlanning.rpd) for usage of physical tables and columns.
Prepare APCC dimension data in APS operational data store by running collection.

Minimum Level Requirements

The following are required in order for the feature to function correctly:

XML Development Kit

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCC concurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.5 Revenue Gap Analysis

Description

This feature enables Supply Chain Analysts and Sales and Operations Planners to do additional reporting and analysis to close gaps between the current shipment rate and the revenue targets established as part of the sales and operations plan. This is most critical as the end of a period or quarter approaches and gaps remain.

The Supply Chain Analyst (SCA) dashboard has been enhanced to add the following reports in the Scenario analysis tab:

Backlog Analysis - Units & Value
Bookings Performance - Units & Value
Current Shipment Plan
Demand and Supply Summary
Demand Utilization - Units & Value
Demand Utilization Split - Baseline Plan
Left to Book - By Quarter
Sales Order Analysis - Units & Value
Shipment Performance - Units & Value
Supply Utilization - Units & Value

The Sales and Operations Planning (S&OP) dashboard has also been enhanced to add/modify the following reports:

Current Shipment Plan
Supply Summary

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists windows and pages that are new.

New Window or Page Name	Technical Name	Description
Backlog Analysis - Units	-	Backlog Analysis - Units, this is a hidden dashboard page.
Backlog Analysis - Value	-	Backlog Analysis - Value, this is a hidden dashboard page.
Sales Order Analysis - Units	-	Sales Order Analysis - Units - This is a hidden dashboard page.
Sales Order Analysis - Value	-	Sales Order Analysis - Value - This is a hidden dashboard page.
Booking Performance - Units	-	This is a hidden dashboard page.
Booking Performance - Value	-	This is a hidden dashboard page.
Shipment Performance - Units	-	This is a hidden dashboard page.
Shipment Performance - Value	-	This is a hidden dashboard page.
Current Shipment Plan	-	This is a hidden dashboard page.
Supply Utilization Units by Scenario	-	This is a hidden dashboard page.
Supply Utilization Value by Scenario	-	This is a hidden dashboard page.
Supply Utilization Units by Plan	-	This is a hidden dashboard page.
Supply Utilization Value by Plan	-	This is a hidden dashboard page.
Demand Utilization Units by Scenario	-	This is a hidden dashboard page.
Demand Utilization Value by Scenario	-	This is a hidden dashboard page.
Demand Utilization Units by Plan	-	This is a hidden dashboard page.
Demand Utilization Value by Plan	-	This is a hidden dashboard page.

Changed Windows or Pages

This table lists the windows and pages that are changed.

Changed Window or Page Name	Technical Name	Description
Supply Chain Analyst Dashboard	MSC_SCA_DASHBOARD	Supply Chain Analyst Dashboard

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

This table lists the new reports.

New Report Name	Technical Name	Description
Scenario Summary	-	Scenario Summary on Supply Chain Analyst dashboard
Left to Book by Quarter	-	Left to Book by Quarter - Baseline Scenario on Supply Chain Analyst dashboard
Demand Utilization - Baseline Plan	-	Demand Pegging Split - Baseline Scenario on Supply Chain Analyst dashboard
Plans	-	Plans on Supply Chain Analyst dashboard
Backlog Analysis - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Backlog Analysis - Value	-	Drilldown reports from Supply Chain Analyst dashboard
Sales Order Analysis - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Sales Order Analysis - Value	-	Drilldown reports from Supply Chain Analyst dashboard
Booking Performance - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Booking Performance - Value	-	Drilldown reports from Supply Chain Analyst dashboard
Shipment Performance - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Shipment Performance - Value	-	Drilldown reports from Supply Chain Analyst dashboard
Current Shipment Plan	-	Drilldown reports from Supply Chain Analyst dashboard
Supply Utilization - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Supply Utilization - Value	-	Drilldown reports from Supply Chain Analyst dashboard
Demand Utilization - Units	-	Drilldown reports from Supply Chain Analyst dashboard
Demand Utilization - Value	-	Drilldown reports from Supply Chain Analyst dashboard

Changed Reports

This table lists the changed reports.

Changed Report Name	Technical Name	Description
Demand and Supply Summary	-	Demand and Supply Summary on Supply Chain Analyst dashboard
Supply Summary	-	Supply Summary on Sales and Operations Planning dashboard

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

This table lists the changed programs.

Program Name	Feature Area
MSCHBDEB.pls	MSC

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

This table lists the changed tables.

Table Name	Description
MSC_DEMANDS_F	Added new Sales Order columns.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

Perform the following

Setup OBIEE, RPD and webcat.
Setup translated messages to get all RPD strings loaded into DB.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

The following are required for this feature to function properly:

XML Development Kit.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCC concurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.6 Collaboration Workspaces for Unstructured Collaboration

Description

This feature lets users to quickly band into ad-hoc, virtual groups for specific planning tasks and allows those groups to share structured and unstructured content. Each group has access to a single, flexible portal-like user interface that brings together components of various planning applications and a variety of collaboration tools.

These collaborative group spaces support customized Worklists, Group Calendars, Documents, Discussions, Tags, Issues and Notes. In addition, the group space home page has navigation links to applications such as Rapid Planning and Sales and Operations Planning, and to APCC dashboards.

Each group space is linked to a Scenario created in Advanced Planning Command Center and users can choose to auto-create a group space when a scenario is created.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists windows and pages that are new.

New Window or Page Name	Technical Name	Description
WebCenter	WebCenter	When user navigates to collaboration home, WebCenter ui appears to user

Changed Windows or Pages

This table lists the windows and pages that are changed.

Changed Window or Page Name	Technical Name	Description
Scenarios Page	Scenarios Page	Setup window for defining scenarios and associating/defining a WebCenter group space to the scenario.

Obsolete Windows or Pages

This table lists the windows and pages that are obsolete.

Changed Window or Page Name	Technical Name	Description
Activities Page	Activities Page	Activities Page is obsolete and users need to use 11g bpm worklist application ui to see the tasks/activities.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

This table lists the changed workflows.

Changed Workflow Name	Technical Name	Description
All Workflows	-	Added To Do task webservice to create a task in 11g bpm worklist application.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

This table lists the changed tables.

Table Name	Description
MSC_SCENARIOS	Added WC_FLAG, GS_NAME, GS_NAME_ORIG columns to tag WebCenter group space info to scenarios.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

This table lists the new profile options.

Profile Option Name	Feature Area	Description
MSC: APCC Webcenter Enabled	WebCenter	Set this to Yes/No to enable/disable WebCenter feature.
MSC: APCC Webcenter Spaces Member Role	WebCenter	Set to Viewer or Participant Members added to WebCenter group space can be Viewer or Participant.
MSC: APCC Webcenter Group Space Template	WebCenter	Set to WebCenter Group Space Template Name.
MSC: APCC Webcenter Spaces Recipient Key Alias	WebCenter	Set to Recipient Key Alias. For example, Producer.
MSC: APCC Webcenter Spaces Saml Issuer Name	WebCenter	Set it to Saml Issuer Name of webcenter. For example, www.oracle.com.
MSC: APCC Webcenter Spaces Port	WebCenter	Set it to the WebCenter Spaces Managed Server Port. For example, 8877.
MSC: APCC Webcenter URL	WebCenter	Set it the the WebCenter URL. For example, http://rws60018rems.us.oracle.com/webcenter /wcAuthentication/?login=true&success_url=/spaces. Just replace with your host and keep the other things same, so that WebCenter welcome/login screen will be skipped when navigating from EBS to WebCenter.
MSC: APCC WebLogic Console Username	WebCenter	Set it to WebLogic admin user. For example, weblogic. This user should be the admin user for WebLogic.
MSC: APCC WebLogic Console Password	WebCenter	Set it to WebLogic admin password.

Changed Profile Options

This table lists the changed profile options.

Profile Option Name	Feature Area	Description
MSC: BPEL End Point URI	SOA Server	Set it to WebLogic SOA server url. For example, http://rws60212resm.us.oracle.com:8880 where 8880 is the soa_server1 port number.
MSC: BPEL Domain Name	SOA Server	Set it to SOA domain. For example, soa-infra.
MSC: APCC WebLogic Username	SOA Server	Set it to Oracle BPM worklist admin user. For example, weblogic_admin. This user should be admin for OID and WebCenter.
MSC: APCC WebLogic Password	SOA Server	Set it to Oracle BPM worklist admin password.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

Please follow My Oracle Support notes Document 1074345.1 and Document 1070257.1 for installing/configuring of WebCenter/BPEL flows/web services.

Upgrade Considerations

All the BPEL flows and webservices have been migrated from Oracle 10 BPEL to Oracle 11g SOA.

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Users can customize the apcc group space template to the way they like in WebCenter and use it as template for the group spaces created.

Minimum Level Requirements

Please follow My Oracle Support notes Document 1074345.1 and Document 1070257.1 for requirements.

Technology Stack Incompatibilities

Please follow My Oracle Support notes Document 1074345.1and Document 1070257.1 for technology stack incompatibility.

Technical Architecture Considerations

Please follow My Oracle Support notes Document 1074345.1 and Document 1070257.1 for technical architecture considerations.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.7 Enhanced Exceptions Analysis

Description

The Supply Chain Analyst Dashboard has been enhanced to include additional measures and reports in support of improved exception analysis. Two new reports have been added as part of this feature:

Item Exceptions Summary
Resource Exceptions Summary

In addition to the above, the following reports have been enhanced with additional page/report filters:

Demand Exceptions Summary
Inventory Exceptions Summary
Alternate Exceptions Summary
Resource Exceptions Summary
Reschedules Exceptions Summary
Exception Summary by Category
Exception Summary by Organization

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

This table lists the windows and pages that are changed.

Changed Window or Page Name	Technical Name	Description
Supply Chain Analyst Dashboard	MSC_SC_DASHBOARD	OBIEE answers updated to include the two new Exceptions reports.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

This table lists the new reports.

New Report Name	Technical Name	Description
Item Exceptions Summary	-	The report was added to SCA Dashboard Exceptions tab.
Resource Exceptions Summary	-	The report was added to SCA Dashboard Exceptions tab.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

There are no new flexfields that are associated with this feature.

Changed Flexfields

There are no changed flexfields that are associated with this feature.

Obsolete Flexfields

There are no obsolete flexfields that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

The following are requirement for this feature to function properly:

XML Development Kit.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

If user can't see data in APCC Dashboards, verify OBIEE is set up correctly.
If user encounters APCC concurrent programs failures, check concurrent program logs for details.
If user encounters errors when importing csv files into APCC, check csv files formatting.

3.8 Integration with Rapid Planning

Description	Oracle Advanced Planning Command Center now offers pre-built integration with Rapid Planning. Rapid Planning plans can be archived and published to Advanced Planning Command Center. These archived versions can then be viewed in all related reports and dashboards. The Advanced Planning Command Center's Supply Chain Analyst dashboard supports drill-down directly into the Rapid Planning application. All Rapid Planning simulation plans can be used in the Process Automation functionality to build process flows in Advanced Planning Command Center.
New, Changed, Obsolete Components	This section lists the components that were added, changed, or made obsolete for this feature in Oracle Advanced Planning Command Center in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs. For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support. New Windows or Pages There are no new windows or pages that are associated with this feature. Changed Windows or Pages There are no changed windows or pages that are associated with this feature. Obsolete Windows or Pages There are no obsolete windows or pages that are associated with this feature. New Reports There are no new reports that are associated with this feature. Changed Reports There are no changed reports that are associated with this feature. Obsolete Reports There are no obsolete reports that are associated with this feature. New Workflows There are no new workflows that are associated with this feature. Changed Workflows There are no changed workflows that are associated with this feature. Obsolete Workflows There are no obsolete workflows that are associated with this feature. New Alerts There are no new alerts that are associated with this feature. Changed Alerts There are no changed alerts that are associated with this feature. Obsolete Alerts There are no obsolete alerts that are associated with this feature. New Public APIs There are no new public APIs that are associated with this feature. Changed Public APIs There are no changed public APIs that are associated with this feature. Obsolete Public APIs There are no obsolete public APIs that are associated with this feature. New Programs There are no new programs that are associated with this feature. Changed Programs There are no changed programs that are associated with this feature. Obsolete Programs There are no obsolete programs that are associated with this feature. New Tables There are no new tables that are associated with this feature. Changed Tables There are no changed tables that are associated with this feature. Obsolete Tables There are no obsolete tables that are associated with this feature. New Views There are no new views that are associated with this feature. Changed Views There are no changed views that are associated with this feature. Obsolete Views There are no obsolete views that are associated with this feature. New Business Intelligence Publisher Components There are no new Business Intelligence Publisher Components that are associated with this feature. Changed Business Intelligence Publisher Components There are no changed Business Intelligence Publisher Components that are associated with this feature. Obsolete Business Intelligence Publisher Components There are no obsolete Business Intelligence Publisher Components that are associated with this feature. New SQL Loader Files There are no new SQL loader files that are associated with this feature. Changed SQL Loader Files There are no changed SQL loader files that are associated with this feature. Obsolete SQL Loader Files There are no obsolete SQL loader files that are associated with this feature. New Flexfields There are no new flexfields that are associated with this feature. Changed Flexfields There are no changed flexfields that are associated with this feature. Obsolete Flexfields There are no obsolete flexfields that are associated with this feature. New Profile Options There are no new profile options that are associated with this feature. Changed Profile Options There are no changed profile options that are associated with this feature. Obsolete Profile Options There are no obsolete profile options that are associated with this feature.
Implementation Considerations	New and Changed Setup Steps There are no new or changed setup steps for this feature. Upgrade Considerations There are no upgrade considerations for this feature. Sizing There are no sizing considerations for this feature. Table Space Considerations There are no table space considerations for this feature. Performance Considerations There are no performance considerations for this feature. XMLDB Usage There are no XMLDB usages for this feature. Load Balancing There is no load balancing information for this feature. New Bulk Interfaces There are no new bulk interfaces for this feature.
Customizations and Extensions	Customizations and extensions are not possible for this feature.
Minimum Level Requirements	The following are required for this feature to function properly: Rapid Planning 12.1.2 or higher.
Technology Stack Incompatibilities	There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations	There are no technology architecture considerations for this feature.
Troubleshooting Tips	There are no troubleshooting tips for this feature.

3.9 Material Plan User Interface

Description

In release 12.1.3.8, a new Material Plan user interface is available to perform mass updates on supply and demand records. The supply and demand records appear in a bucketed horizontal format, similar to the Horizontal Plan. Values in the Material Plan user interface can be edited and the aggregate values are updated as changes are made. Changes to the buckets values are allocated back to the planned orders and the firm status of the planned order is set.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name	Technical Name	Description
Material Plan	-	This user interface is used to perform updates to supply and demand records.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name

Technical Name

Description

Demand and Supply Totals by Category Query

The query has been enhanced to include a material plan link to access the new material plan. The plan, organization, and category values are passed in as context into the material plan.

Aggregate Horizontal Plan Query

The query has been enhanced to include a material plan link to access the new material plan. The plan, organization, and category values are passed in as context into the material plan.

The following Supply Chain dashboard pages have been updated to provide a Material Plan link:

Plan Health Summary
Demand and Supply

The Material Plan link from the dashboard pages is used to access the Material Plan for the selected plan.

New Profile Options

This table lists the new profile options.

Profile Option Name	Feature Area	Description
MSC: New Material and Resource Plan Fetch Size	-	Determines the number of rows that are loaded.

Implementation Considerations

New and Changed Setup Steps

Set profile MSC: New Material and Resource Plan Fetch Size.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

There are no minimum level requirements for this feature.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.10 Resource Plan User Interface

Description

In release 12.1.3.8, a new Resource Plan user interface is available to view and update available resource hours by day, by week, or by period, including the option to display a set of total rows. The new editable resource plan displays resources in a bucketed fashion including a set of total rows. The Resource Plan allows direct editing of bucketed values. The changes to the bucketed values are allocated back to the resource's daily availability.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name

Technical Name

Description

Resource Plan

This user interface is used to update available resources by day, by week, or by period.

Once changes are made, click Recalculate to refresh data to account for the changes.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name

Technical Name

Description

Supply Chain Analyst Resource Dashboard Page - Most Utilized Resources Table View

Right-clicking on chart displays Resource Plan option. Selecting Resource Plan opens the Resource Plan user interface.

The Most Utilized Resource table contains a new column, Resource Plan. The column includes a material plan link to access the new material plan. The plan, organization and category values are passed in as context into the material plan

The following Supply Chain Analyst dashboard pages have been updated to provide a Resource Plan link:

Plan Health Summary
Demand and Supply

The Resource Plan link from the dashboard pages is used to access the Resource Plan for the selected plan.

New Profile Options

This table lists the new profile options.

Profile Option Name	Feature Area	Description
MSC: New Material and Resource Plan Fetch Size	-	Determines the number of rows that are loaded.

Implementation Considerations

New and Changed Setup Steps

Set profile MSC: New Material and Resource Plan Fetch Size.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

There are no minimum level requirements for this feature.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.11 Orders User Interface

Description

In release 12.1.3.8, a new Orders user interface is available to easily release orders from APCC. The Orders user interface is used to identify the orders for release based on a variety of search criteria as well as edit select columns. In addition, the planner can choose to release orders from within the Orders user interface.

To update release status, select the desired orders and choose Mark for Release from the Action menu. To release the plan, select Release Plan from Action menu. This applies to all orders that are set to Mark for Release within the plan.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name	Technical Name	Description
Orders	-	This user interface is used to release orders from APCC.
Material Plan	-	This user interface can be used to access the Orders user interface. Right-click cell to display orders option. Multiple selection is supported for this feature.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name

Technical Name

Description

The following Supply Chain Analyst dashboard pages have been updated to provide a Resource Plan link:

Plan Health Summary
Demand and Supply

The Orders link from the dashboard pages is used to access the Orders for the selected plan.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

There are no minimum level requirements for this feature.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.12 Launch Plan from APCC

Description

In release 12.1.3.8, APCC can launch a plan via ASCP Plan Actions.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name

Technical Name

Description

Launch Plan Dialog

This dialog appears when the Launch Plan link is selected from the Supply Chain Analyst dashboards.

The dialog provides a Net Change Simulation option that allows the system to perform a batch replan which will factor in any edits made. If the Net Change Simulation options is not selected, the Launch dialog functions the same as the ASCP Launch dialog plan.

Note: Since the Launch Snapshot parameter works like the current ASCP Launch Plan Snapshot parameter, it is important to point out that any edits to material plan, resource plan, or orders are overlaid with the new snapshot that is taken. The edits to the item simulation set remain and are reapplied after the new snapshot is taken.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name

Technical Name

Description

The following Supply Chain Analyst dashboard pages have been updated to provide a Launch Plan link:

Plan Health Summary
Demand and Supply

The Launch Plan link from the dashboard pages is used to access the Launch Plan dialog for the selected plan.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

There are no minimum level requirements for this feature.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.13 Edit Item Simulation Set User Interface

Description

In release 12.1.3.8, APCC a new Item Simulation Set user interface is available to add or remove items from the simulation set, as well as override item attributes from APCC.

New, Changed, Obsolete Components

For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name	Technical Name	Description
Edit Item Simulation Set	-	This user interface allows the user to add or remove items from the simulation set, as well as override item attributes from APCC.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name

Technical Name

Description

The following Supply Chain Analyst dashboard pages have been updated to provide an Item Simulation Set link:

Plan Health Summary
Demand and Supply

The Item Simulation Set link from the dashboard pages is used to access the Item Simulation Set user interface for the selected plan.

Implementation Considerations

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements

There are no minimum level requirements for this feature.

Technology Stack Incompatibilities

There are no technology stack incompatibilities for this feature.

Technical Architecture Considerations

There are no technology architecture considerations for this feature.

Troubleshooting Tips

There are no troubleshooting tips for this feature.

3.14 OBIEE 11g Upgrade

Description	In release 12.1.3.8, APCC has been upgraded to work with OBIEE 11g. Note: OBIEE 11.1.1.6.0 is a prerequisite for APCC 12.1.3.8.
New, Changed, Obsolete Components	This section lists the components that were added, changed, or made obsolete for this feature in Oracle Advanced Planning Command Center in Release 12.1.3.8. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs. For additional information, refer to the Oracle Electronic Technical Reference Manuals (eTRM) located on My Oracle Support.
Implementation Considerations	New and Changed Setup Steps Value Chain Planning (VCP) 12.1.3.8 requires OBIEE 11.1.1.6.0. Refer to the Oracle Value Chain Planning Installation Guide Supplement for release 12.1.3.8 for additional information. Upgrade Considerations Value Chain Planning (VCP) 12.1.3.8 requires OBIEE 11.1.1.6.0. Refer to the Oracle Value Chain Planning Installation Guide Supplement for release 12.1.3.8 for additional information. Sizing There are no sizing considerations for this feature. Table Space Considerations There are no table space considerations for this feature. Performance Considerations There are no performance considerations for this feature. XMLDB Usage There are no XMLDB usages for this feature. Load Balancing There is no load balancing information for this feature. New Bulk Interfaces There are no new bulk interfaces for this feature.
Customizations and Extensions	Customizations and extensions are not possible for this feature.
Minimum Level Requirements	There are no minimum level requirements for this feature.
Technology Stack Incompatibilities	Value Chain Planning (VCP) 12.1.3.8 requires OBIEE 11.1.1.6.0. Refer to the Oracle Value Chain Planning Installation Guide Supplement for release 12.1.3.8 for additional information.
Technical Architecture Considerations	There are no technology architecture considerations for this feature.
Troubleshooting Tips	There are no troubleshooting tips for this feature.

Return to Diagnostics and Logging

4. Diagnostics and Logging

Oracle Advanced Planning Command Center utilizes Oracle E-Business Suite Diagnostics, a tool to help standardize data gathering and troubleshooting. This tool is delivered within the maintenance pack (product code IZU) and consists of two components:

The Oracle E-Business Suite Diagnostics framework (ODF)

Provides a place for product-specific tests to be processed and reported
Is accessible using the 'Application Diagnostics' responsibility which is assigned through diagnostic roles within the RBAC security model.

Note: If no role is assigned using RBAC, and the "Application Diagnostics" responsibility is directly assigned to users (for example, via the System Administrator Users form), then all Diagnostics tabs open for those users. However, in the Diagnose tab, tests do not appear under any application except HTML platform, and users can neither run tests nor configure inputs for any other application.

Complete RBAC setup details for diagnostics are available through My Oracle Support Document 167000.1.

Product content (referred to as 'tests')

Primarily organized by functional groups
Provides data in a structured format
May include detailed error identification followed by actions to be taken when 'bad' data is detected

It is highly recommended that following the successful installation of the Release 12.1.3 maintenance pack for Oracle Advanced Planning Command Center, the following actions are taken:

Verify that the latest Oracle E-Business Suite Diagnostics patch is applied (see Document 167000.1 for latest patch information) as this will ensure that the latest tools are available.
Run the related product family pre-production test set(s) to verify existing product setups have not been compromised and all new, required setups are flagged for action.

After installation, review Document 783319.1, the diagnostic catalog, to identify other helpful tests that you can use for maintaining a healthy environment.

For questions about Oracle E-Business Suite Diagnostics or any issues using this tool, consult My Oracle Support Document 235307.1, which provides a FAQ with the latest answers and discussion.

E-Business Suite Diagnostics Quick Reference

My Oracle Support Document	Title	Purpose
Document 167000.1	E-Business Suite Diagnostics Installation Guide	Use this note to download the latest Diagnostics patch. Follow the installation instructions to eliminate common installation and usage problems. A link to how to set up Role Based Access Control security for Oracle E-Business Suite Diagnostics is included.
Document 235307.1	FAQ	Do you have a problem installing Diagnostics? Do you have a question about how Diagnostics works and what it can do for you? This document provides key information for successfully installing Diagnostics.
Document 342459.1	Overview	The Overview document highlights how the Oracle Diagnostics tool can support your Oracle E-Business Suite installation.
Document 421245.1	Oracle E-Business Suite Release 12 Diagnostic Catalogs	This Note lists all tests that are available for Oracle E-Business Suite Release 12.
Document 368109.1	Pre-production test sets	Tests that are grouped together (known as test sets) by a product family, designed to aid in verifying that all included applications are set up correctly. Designed to detect missing or incorrect setup, and prevent corruption before implementation or usage of applications.
Document 232116.1	Training	Viewlets and presentations that explain the various aspects of Oracle E-Business Suite Diagnostics.
My Oracle Support Diagnosibility Community	Diagnosibility link	This open forum is available for discussion of Oracle E-Business Suite Diagnostics, and is monitored by the Diagnostics development team.

Oracle Advanced Planning Command Center uses the common diagnostics features in Oracle E-Business Suite. This enables users and system administrators to use a centralized set of options to control logging level, as well as output destination. To run diagnostics, use the following profile options:

FND: Debug Log Enabled
FND: Debug Log Module
FND: Debug Log Level

Setting the log level to Statement produces detail logging of code execution. To reduce the size of the output and make it more manageable, you can use <product short code>% as a module to restrict messages to those coming from Oracle Advanced Planning Command Center code.

The preceding profile options can be turned on at the user, function, responsibility, or site level. It is preferable, however, to set profiles at the user level to restrict the overhead they add to the system. If issues are experienced, logging profiles should be set at the user level experiencing the issue. For authorization servlet-related issues, you must set the diagnostics profile at the user level to ANONYMOUS.

To diagnose user interface issues, you can use the filter iby%,fnd.framework%,jbo% and set the diagnostics go-to screen by clicking the Diagnostics Global button. To enable this functionality, you must set the following profile option:

FND: Diagnostics

The FND: Diagnostics profile option controls whether the Diagnostics button is rendered. It also controls the display of the About this Page link.

For system issues, such as exceptions, timeouts, or unexpected behavior, you can turn on logging, based on where you are experiencing the issues, as follows:

For a concurrent program, you can capture the log file for the program processed by turning on logging at the statement level.
For user interface, you can capture the logging shown on the screen by clicking the Diagnostics button, and full stack trace of any exceptions you see on the page.

You can also capture additional information about the system by printing the report from the About this Page link, as well as from the jsp: /OA_HTML/jsp/fnd/fndversion.jsp.

For more information on Logging, see the Oracle Applications System Administrator's Guide Documentation Set and the Oracle Applications Developer's Guide in the Release 12.1.3 Documentation Library.

5. Known Issues in Oracle Advanced Planning Command Center Release 12.1.3.8

There are no known issues for this product.

Return to Known Issues

6. Change Record

Date	Description of Change
October 2012	Updated to reference installation guide and installation guide supplements.
September 2012	Published document.