My Oracle Support Banner

Error On Table MSC.MSC_OPERATION_COMPONENTS# ORA-14400 ORA-32423 ORA-12083 (Doc ID 2929625.1)

Last updated on APRIL 27, 2023

Applies to:

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


The temp table 'MSC.MSC_OPERATION_COMPONENTS#' cause errors in multiple cases.

Case 1:

Following error is reported while applying the latest VCP cumulative patch.

ERROR at line 1:
ORA-32423: commit SCN-based materialized view log cannot be dropped on table
"MSC"."MSC_OPERATION_COMPONENTS" when there exist direct load/PMOP log entries for the table
ORA-12083: must use DROP MATERIALIZED VIEW to drop


Case 2:

Following error reported while running: MSCPLD: Loader Worker With Direct Load Option, during the plan run.

Navigation to reproduce the issue:

1. Responsibility:  Advanced Supply Chain Planner
2. Navigation > Supply Chain Plan > Launch
3. Following child process completes with error:
MSCPLD: Loader Worker With Direct Load Option


Record 1: Rejected - Error on table MSC.MSC_OPERATION_COMPONENTS#.

ORA-14400: inserted partition key does not map to any partition




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

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