Oracle Value Chain Planning VCP ASCP Cloud Big Data Predictive Analytics Integrated Business suite Fusion
-
Install / Upgrade,
Technical
April 9, 2020
VCP Concurrent Request - Single Submission Diagnostic Bundle Perl Program for VCP Data Collections Single Submission NEW RELEASE!
Hello! There will be a new release, version 5, this April-May 2020. Until that time there is a new release that has several enhancements.
There are numerous updates in v200.4:
- Numerous performance updates
- Adjusted some SQL to provide cleaner results
- Upgraded VCP Advanced Supply Chain Planning VCP Partitions Analyzer to 200.10
This program will zip the output files into one file called VCP+concurrent request ID.zip. The result will be a file named VCP+concurrent request ID.zip, created in the user entered output directory.
Version 5 will include (actively working now):
- LOV for Instance_Code
- The ability to choose individual VCP diagnostic programs
For SQL Submission
Value Chain Planning (VCP) SQL*Plus Single Submission Diagnostic Bundle Perl Program for VCP Data Collections Single Submission - Multiple Output - Analyzers, APScheck, APScheck Parser, Collection Log Parser (Doc ID 2268495.1)
This version delivers parameter inputs, VCP Collections Log Parser and the ability to choose individual diagnostics to submit.
- APSCHECK.sql
- APSCHECK Parser
- ASCP_COLLECTIONS_ANALYZER.sql
- VCP Partitions Analyzer.sql
- VCP Collections Log Parser
This bundle will require the following input:
- Apps user ID and password
- APSCHECK.sql, This is defaulted to B
- Enter the Instance Code: (select instance_id, instance_code from msc_apps_instances)
- Enter the Maximum rows to display:
- The parent_id of the collections concurrent request for log parsing.
This program will zip the output files into one file called VCP+random number.zip. The result will be a file named VCP+random number.zip, created in the user entered output directory.