Oracle Advanced Planning Command Center User's Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Advanced Planning Command Center Overview

Advanced Planning Command Center Overview
Overview of Scenarios
Overview of Web Services
Overview of Dashboards
Overview of Collaborative Workspaces
      Collaboration Group
      Collaboration Group Home Page
      Navigation Rules To and From the Collaboration Home Page
Executive Summary Report as a Portlet
Work List
Data Security

Managing Scenarios

Understanding Scenario Planning
Using Scenario Planning
Working with Scenarios
      Understanding the Scenarios Page
      Understanding Scenario States
      Accessing the Scenarios Page
      Searching for Scenarios
      Creating New Scenarios
      Copying Scenarios
      Editing Scenarios
      Archiving Scenarios
      Purging Scenarios
      Purging Plan Facts
Working with Scenario Sets
      Understanding the Scenario Sets Page
      Accessing the Scenario Sets - Scenarios Page
      Accessing the Scenario Sets Activities
      Creating Scenario Sets
      Editing Scenario Sets
Working with Activities
      Understanding the Activities Page
      Accessing the Activities Page
      Editing Activities
Working with Planning Processes
      Understanding the Planning Processes Page
      Accessing the Planning Processes Page
      Entering Parameters
      Starting Planning Processes
      Scheduling Planning Processes
      Terminating Planning Processes

Understanding Service - Enablement Planning Processes

Understanding Oracle's Advanced Planning Business Processes
The Forecast, Inventory, and Supply Planning Business Process
The Sales and Operations Planning Business Process
Web Services
      Advanced Supply Chain Planning Web Services
      Advanced Planning Suite Web Services
      Collections Web Services
      Demantra Web Services
      Distribution Planning Web Services
      Inventory Optimization Web Services
      Order Promising Web Service
      Plan Management Web Services
      Scenario Management Web Services
      Service Parts Planning Web Service
      Strategic Network Optimization Web Services
Access to Embedded Demantra Worksheets

Understanding the Advanced Planning Analytical Framework

Understanding the Advanced Planning Command Center Analytical Framework
Roles
The Dimension Model
      End Items and Parent Model
      Setting Parent or Top Model Granularity
      End Item Dimension
      Parent Model Dimension
Measures and Hierarchies
      Custom Product Hierarchies
      Custom Hierarchies and Other Dimensions
      Uploading Custom Hierarchies
      Uploading the .cvs File
      Custom Measures
      Uploading Custom Measures
      New Measures
      The Inventory Analysis Functional Area
      The Overall Plan Health Functional Area
      The Supply Chain Costs and Profitability Functional Area
      The Replenishment Planning Functional Area
      The Demand Satisfaction Functional Area
      The Manufacturing Efficiency Functional Area
      The Sourcing Efficiency Functional Area
      The Forecasting Functional Area
      The Network Design Functional Area
      Oracle Rapid Planning Measures
Dashboards
Archiving Plans and Scenarios
APCC Archive Plan Summary
      Fine Tuning Your Data for Archive Plan Summary
      Defining Your Data
Setting Your Data for Archiving
      Setting Time Granularity and Measures
Accessing Item Attributes
Setting up Profile Options

Using the Supply Chain Analyst Dashboard

Understanding the Supply Chain Analyst Dashboard
Overview of APCC Plan Details
Understanding the Plan Details Tab
Understanding the Plan Detail Data Model
Launching and Archiving Plans in APCC Plan Details
Integration of Oracle Advanced Planning Command Center and Oracle Inventory Optimization
      Managing Inventory Optimization Plans from Advanced Planning Command Center
      Pushing Warehouse Capacity Facts and Dimensions to APCC
      Understanding the Seeded Reports
Integration of Oracle Advanced Planning Command Center and Oracle Rapid Planning
Using the Plan Health Summary Page
      Understanding the Plan Health Summary Page
      Page Level Filters
      Shipments and Production Trends
      APCC Plan Details
      Demand and Supply Summary
      Resource Summary
      Exception Summary Report
      Launching a Plan From Within APCC
      Releasing a Plan From Within APCC
      Understanding the Orders User Interface Features
      Using the Orders User Interface
Using the Demand and Supply Page
      Understanding the Demand and Supply Page
      Page Level Filters
      Demand and Supply Summary
      Demand Change by Customers
      Supply Change by Categories
      Demand and Supply Trend Across Plans
      Demand and Supply Trend (Baseline Plan)
      Total Demand by Customers (Baseline Plan)
      Total Supply by Categories (Baseline Plan)
Understanding the Editable Material Plan
      Using the Editable Material Plan
      Understanding the Editable Material Plan General Layout
      Understanding the Editable Material Plan Features
      Setting Up the Layout
Navigating to the Editable Material Plan
Rapid Planning Supply Demand Plan Drilldowns
Excess and Obsolescence
      Excess and Obsolescence Reports
Using the Resources Page
      Understanding the Resources Page
      Page-Level Filters
      Resource Summary
      Most Utilized Resource (Baseline Plan)
      Least Utilized Resources (Baseline Plan)
      Resources with Change in Utilization
      Resource Utilization Trend
      Rapid Planning Resource Plan Drilldowns
      Understanding the Editable Resource Plan
      Navigating the Editable Resource Plan
      Understanding Item Simulation Sets
      Navigating to the Item Simulation Set
      Accessing and Editing Item Simulation Sets
      Mass Editing in the Item Simulation Set
Using the Exceptions Page
      Understanding the Exceptions Page
      Page Level Filters
      Exceptions Summary
      Exceptions Summary by Category
      Exceptions Summary by Organization
      Rescheduled Orders by Suppliers
      Rapid Planning Exception Report Drill Downs
      Understanding Plan Details
Using the Historical Performance Page
      Understanding the Historical Performance Page
      Page-Level Filters
      Overall Supply Chain Performance Metrics
      Supply Chain Metrics Trend
      Inventory Value by Categories
      Days of Cover by Categories
      Production to Plan by Categories
      Shipments to Plan by Categories
      Resource Utilization by Resource Groups
Using the Scenario Analysis Page
      Understanding the Scenario Analysis Page
      Page-Level Filters
      Scenario Summary Report
      Demand Pegging – Baseline Plan Report
      Left to Book by Quarter Report
      Plans Report
      Demand and Supply Summary Report
      Demand and Supply Trend Across Scenarios Report
      Supply Utilization – Units Report
      Supply Utilization – Value Report
      Resource Summary Report
      Resource Utilization Trend Report
      Exception Summary
Using the Inventory Analysis Page
      Page-Level Filters
      Inventory Analysis Page Reports
      Inventory Performance Summary Report
      Inventory Measures Trend Report
      Inventory Quantity (Value) by Category Report and Inventory Quantity (Value) by Organization Report
      Service Level Short Fall by Category Report
      Inventory Budget Excess by Category Report
      Comparison of Inventory Quantity (Reporting Currency) and Safety Stock
      Safety Stock Postponement Analysis Report
      Safety Stock Postponement Analysis by Organization Report
      Build Plan Report
      Order Details Report
Supply Chain Analyst Secondary Drill-Down Reports
Using the Projects Supply Chain Page
      Project Supply Chain Content
      New Reports in the Supply Chain Analyst Dashboard

Using the Sales and Operations Planning Analyst Dashboard

Understanding the Sales and Operations Planning Dashboard
Using the Demand Review Page
      Understanding the Demand Review Page
      Forecast Comparison Report
      Forecast Accuracy - MAPE Report
      Projected Backlog Report
      Consensus Tracking by Category Report
      Forecast - Scenario Comparison Report
      Demand Summary Report
      Top Abs Diff - Consensus and Financial by Category
      Consensus Forecast Difference by Customer Report
      Consensus Forecast Difference by Category Report
Using the Supply Review Page
      Understanding the Supply Review Page
      Consolidated Analysis Report
      Demand Fill Report
      Production Plan Comparison by Organization Report
      Production Plan Report
      Top – Supplier Item Utilization Report
      Top Resource Utilization by Organization Report
      Consolidated – Scenario Comparison Report
      Supply Summary Report
      Bottom Demand Fill % by Customer Report
      Supply Change by Category Report
      Top Resource Utilization Report
      Strategic Plans Report
Using the Financial Review Page
      Understanding the Financial Review Page
      Financial Summary Report
      Operating Plan and Financial Forecast Comparison Report
      Top % Difference – Operating Plan and Budget by Category Report
      Financial Analysis Report
      Profit & Loss Monthly Report
      Margin Difference by Category Report
      Year-Over-Year Financials Report
      Financial Forecast and Budget Comparison Report
      Top % Difference – Budget and Annual Plan by Organization Report
      Top Revenue Report
      Cost by Organization
      Bottom Margin Report
      Profitability KPI and Cost Breakdown KPI Reports
Using the Executive Review Page
      Understanding the Executive Review Page
      Consolidated Analysis
      Profit and Loss Statement
      Constrained Forecast Comparison
      Budget Analysis
      Key Performance Indicators
      Executive Summary
      Top Difference - Operating Plan and Financial Forecast by Category
      Consensus Forecast Difference by Customer
      Profitability KPI
      Cost Breakdown KPI
Sales and Operations Planning Analyst Secondary Drill-Down Reports

Using the Supply Chain Risk Management Dashboard

Understanding the Supply Chain Risk Management Dashboard
Using the Executive Review Page
Understanding the Executive Review Page
Profit Comparison
Cost Analysis
Revenue by Fiscal Period
Margin by Fiscal Period
Supply Demand KPI
Inventory KPI
Utilization KPI
Strategic Plans
Inventory Optimization Plans
Using the Inventory Analysis Page
      Understanding the Inventory Analysis Page
      Cost Analysis
      Network and Inventory Summary
      Postponement Analysis
      Excess and Obsolescence
      Safety Stock Scenario Analysis
      Inventory Analysis
      Service Level Scenario Comparison
      Unmet Revenue Analysis
Using the Supply Chain Sourcing Page
      Understanding the Supply Chain Sourcing Page
      Supplier Sourcing
      Manufacturing Sourcing
      Transportation by Mode
Supply Chain Risk Management Secondary Drill-Down Reports

Using the Service Parts Planning Dashboard

Overview
Using the Plan Health Summary Page
Using the Demand & Supply Page
Using the Exceptions Page
Using the Service Level Agreement Analysis Page
Using the Historical Performance Page

Understanding the APCC Policy Planning Dashboard

Overview of APCC Policy Planning
Using the APCC Policy Planning Dashboard
      Creating a Scenario to View Policy Planning Data
Viewing Policy Planning Output
Policy Planning Analytics
      Plan Estimation Analytic
      Inventory Policy Execution Analytic
      Inventory Policy Monitoring Analytic
      Calculation of the Actual Fill Rate

Understanding the Trade Analysis Dashboard

Introduction to the Trade Analysis Dashboard
Using the Trade Analyst Dashboard
Publishing from PTP to APCC
Understanding Promotional Entities
      Understanding Dimensions, Levels, and Hierarchies
      Promotion Measures
      Detail Promotion Measures in the Trade Analyst and RT S&OP Dashboards
      Detail Promotion Measures Used in Calculations of Aggregate Measures in S&OP
      Aggregate Promotion Measures in APCC
      Understanding Promotion Analysis Reports and Graphs
Analyzing Promotion

BPEL Processes

The Forecast, Inventory, and Supply Planning Business Process
      Running the ASCP Collections Subprocess
      Running the Demantra Collections and Download Subprocess
      Accessing Embedded Demantra Worksheets
      Enabling Demantra Anywhere
      Generating the Forecast Subprocess
      Reviewing the Forecast Subprocess
      Running the Inventory Plan Subprocess
      Running the Supply Chain Plan Subprocess
      Reviewing the Supply Chain Plan Subprocess
The Sales and Operations Planning Business Process
      Running the Supply Plan Subprocess
Custom Business Processes

APCC Standalone and Backport

Overview of APCC Standalone and Backport Capabilities
Dependencies and Interactions
Backport and Standalone Configuration
Profile Options
Setups and Processes
12.1 Data Loads To and From APCC Fact Repository
      APCC Integration with Oracle Distribution Planning
      Distribution Planning Profiles
      Exporting and Importing a Plan Summary

Operation Data Store

Real-Time Planning in APCC
      Real-Time Planning Use Case
      Process Flow
      Collected Data in APCC

Index