Preface

Intended Audience

Welcome to Release 12.2 of the Oracle Value Chain Planning Collections Implementation Guide.

Implementers of Oracle Value Chain Planning

See Related Information Sources for more Oracle Applications product information.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Structure

1  Overview of Value Chain Planning Suite
2  Overview of Value Chain Planning Collections
3  Architecture
4  Initial Setup
5  Setting Up Partitions
6  Setting Up Source and Destination Instances
7  Configuring Profile Options
8  Running Collections
9  Collecting from Legacy Systems
10  Loading Data from Flat Files
11  Managing MLOG Tables
12  Troubleshooting
A  Parameters
B  Concurrent Programs
C  Snapshots
D  SQL Commands
E  List of VCP Partitioned Tables
F  Detailed Integration Flows

Related Information Sources

Oracle Advanced Planning Command Center User's Guide

Oracle Advanced Supply Chain Planning Implementation and User's Guide

Oracle Collaborative Planning Implementation and User's Guide

Oracle Demand Planning Implementation and User's Guide

Oracle Demand Signal Repository Users Guide

Oracle Demantra Analytical Engine Guide

Oracle Demantra Implementation Guide

Oracle Demantra Integration Guide

Oracle Demantra User's Guide

Oracle Demantra Deductions and Settlement Management User's Guide

Oracle Demantra Demand Management User's Guide

Oracle Demantra Predictive Trade Planning User's Guide

Oracle Demantra Real-Time Sales and Operations Planning User Guide

Oracle Demantra Security Guide

Oracle Global Order Promising Implementation and User's Guide

Oracle Inventory Optimization User's Guide

Oracle Order Management Implementation Manual

Oracle Order Management User's Guide

Oracle Production Scheduling Implementation Guide

Oracle Rapid Planning Implementation and User's Guide

Oracle Service Parts Planning Implementation and User's Guide

Oracle Strategic Network Optimization Implementation Guide

Integration Repository

The Oracle Integration Repository is a compilation of information about the service endpoints exposed 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 Oracle 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.

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.