Oracle Value Chain Planning Collections Implementation Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Overview of Value Chain Planning Suite

Overview
Naming Conventions
Value Chain Planning Suite Applications
Value Chain Planning Integration

Overview of Value Chain Planning Collections

Overview
Collection Diagrams
Process
VCP Collections Terminology

Architecture

Overview
Centralized
Decentralized
General VCP Products Machine Implementation Options
Rapid Planning Machine Implementation Options

Initial Setup

Implementation Steps
Implementation Considerations
Tablespace Considerations
Installing Patches
Creating Links

Setting Up Partitions

Overview
Create APS Partition
ODS Tables and Instance Partitions
PDS and Plan Partitions
ODS and PDS Data
Using Drop Partition Request

Setting Up Source and Destination Instances

Overview
Setting Up the EBS Source Instance
Creating a VCP Destination Instance
Cloning an Instance
Moving From a Centralized to a Decentralized Installation
Resolving a Corrupted Instance

Configuring Profile Options

Overview
EBS Source, VCP Destination, and ATP Profile Options
Flex Field Profile Options
Legacy Profile Options
Other Profile Options

Running Collections

Overview
Running Collections for the First Time in a New Instance
Standard Collections
Continuous Collections
ATP Data Collections
Organization-Specific Collections
Category-Specific Collections
Collecting from Single Source to Multiple Destinations
Running Collections after Cleaning Up ODS Data

Collecting from Legacy Systems

Overview
Setting Up the Collection of Transaction Data into the Planning Server
Process
Setting Up Batch Uploads
Sequence of Data Uploads
Preprocessing Engine
Setting Up Legacy Instance
Running Legacy Collections Using the Form-Based Application (Collect Flat-File Data)
Running Legacy Collections Using the Self-Service Application (Collect Flat-File Data - Self Service)
Purging Legacy Data
SRP Streams - Self Service
Shipment History - Self Service

Loading Data from Flat Files

Overview
Preparing Transactional Data for Upload
Loading Data from Flat Files to a VCP Destination Instance Using the Form-Based Application
Collecting into a VCP Destination Instance Using the Self-Service Application
Customizations

Managing MLOG Tables

Overview
General Guidelines
MLOG Growth
MLOG Terminology
How Rows are Cleared from MLOG$ Tables
How MLOGs are Used During Data Collection
Managing the MLOG Growth for VCP Data Collections
Most Common Performance Problems
Loading Large Amounts of Data for Implementation

Troubleshooting

Overview
First Steps
Basic Performance Tuning for MSC Partitions
Diagnosing Data Collection Problems
Refresh Collection Snapshots or Planning Data Pull Errors
ODS Load Errors
Refresh Snapshot Process Doesn't Start Because of Concurrent Manager Unavailability
Data Collection Fails with Several Messages
Missing Data Collection Entities
Tracing
Other Troubleshooting Resources
Data Field Notes

Parameters

Overview
Planning Data Pull Parameters
Planning ODS Load Parameters
Legacy Collections

Concurrent Programs

Overview
Collection Requests
Setup Requests
Running Refresh Collection Snapshots as a Standalone Concurrent Request
Performance or Errors with the Refresh Collection Snapshots Program

Snapshots

Overview
List of Snapshots
Invalid Snapshots and Manually Refreshing the Snapshot

SQL Commands

Overview
Partition Table SQL Commands
Snapshot SQL Commands
MLOG SQL Commands
Tablespace SQL Commands

List of VCP Partitioned Tables

Summary List of Partitioned Tables
ODS and PDS Partitioned Table
Partitioned Staging Tables for Data Collections
MV Partitioned Tables
Partitioned Tables for APCC

Detailed Integration Flows

Forecast to ASCP Data Flow
MDS to VCP Data Flow
Purchasing Supply to ASCP Data Flow
Sales Orders to ASCP Data Flow
Sales Orders to MRP Data Flow
WIP to ASCP Data Flow

Index