My Oracle Support Banner

How to run Value Chain Planning (VCP) Analyzer Tools as a Concurrent Request (Doc ID 1599275.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.


This Document will guide the user through the steps to register and configure the Oracle Value Chain Planning Analyzer Tool to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (APPS) password. The creation of this Concurrent Request needs to be performed by a System Administrator; however, this will be a one time task. Once installed, end users with the proper Responsibility will have the ability to execute the Analyzer Tool as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.



Many times customers face issues where certain entities are not collected into the APS/Planning destination instance or not present in the source.  Sometimes objects are invalid or there may be permission issues.

The Planning Data Collection collects data from the EBS source instance tables to the APS/Planning destination instance tables (MSC_ tables).  When the Planning Data Collection process is run, the first program that is launched is the Planning Data Pull.  This program in turn spawns the Refresh Collection Snapshots program.  This program looks at the changes that have taken place in the EBS source instance and updates the associated snapshots.  Once all the snapshots are updated, control is returned to the Planning Data Pull and data is pulled into the staging tables (MSC_ST_ tables) on the APS/Planning destination instance through the related planning views (MRP_AP_ views) on the EBS source instance.  The planning views are based on the snapshots that were just refreshed.  After the Planning Data Pull completes, the Planning ODS Load program runs and moves the data from the staging tables to the planning tables.

Verify Your Source VCP Data Collections Objects Prior to Running Any VCP Analyzers.

See MyOracleSupport Note:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Follow these steps to register and run the Value Chain Planning (VCP) Analyzer script as a concurrent program.
 1.) Copy the latest version of ascp_collections_analyzer.sql from Note 1596457.1 into the source ($MSC_TOP/sql) directory.
 3.) Define a new Concurrent Program (ASCP Data Collections Analyzer Tool)
 4.) Add the new ASCP Data Collections Analyzer Program to the Responsibility's Request Group.
 5.) Submit a new 'ASCP Data Collections Analyzer Tool' Concurrent Request and Verify the output.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.