'Drop Changed Snapshots' Completes with Error Status

(Doc ID 2310549.1)

Last updated on FEBRUARY 28, 2018

Applies to:

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

Symptoms

After upgrading to VCP 12.2.6.1, the 'Drop Changed Snapshots' concurrent request completes with error status.

 

Log File
----------
MSCDROPS: Drop Changed Snapshots

Note the following error text shown in the request log file:

Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 361201.

Review your concurrent request log and/or report output file for more detailed information.

Note the following output:

DECLARE
*
ERROR at line 1:
ORA-20001: MSCDROPS: Error in Dropping Snapshots Process : ORA-20001:
ORA-06512: at line 2099

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