'Drop Changed Snapshots' Completes with Error Status (Doc ID 2310549.1)

Last updated on JANUARY 03, 2023

Applies to:

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

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

	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

Symptoms

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