MSCDROPS: Error In Dropping Snapshots Process - During Data Collections (Doc ID 2056254.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

EBS Source version 12.2.4
VCP 12.2.4.1

Errors when running Data Collections program:


MSCDROPS: Error in Dropping Snapshots Process : ORA-20001: Error while executing:-DROP MATERIALIZED VIEW AHL.AHL_VISITS_SN(1): ORA-00933: SQL command not properly ended


MSRFWOR: Refresh Collection Snapshots
+---------------------------------------------------------------------------+

Current system time is 04-SEP-2015 07:15:37

+---------------------------------------------------------------------------+

**Starts**04-SEP-2015 07:15:37
**Ends**04-SEP-2015 07:16:37
User-Defined Exception
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
04-SEP 07:15:37 : The beginning of Refresh Snapshot
04-SEP 07:15:37 : Standalone RCS - no instance details
04-SEP 07:15:37 : ref mode - 2
04-SEP 07:15:37 : snp name - ALL SNAPSHOTS
04-SEP 07:15:37 : The degree of parallelism for Refreshing snapshots is set to: 0
04-SEP 07:15:37 : Request : 70575842 :Checks for Snapshots which have changed and Drops them
04-SEP 07:16:37 : Source Setup Objects Creation Requests did not complete Successfully
04-SEP 07:16:37 : Please check the Log files for the appropriate message:
04-SEP 07:16:37 : 70575842
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 : Error Setting Up Source Objects

Changes

 Applied VCP 12.2.4.1 patch to VCP instance only

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms