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 22.214.171.124 and later
Information in this document applies to any platform.
The temp table 'MSC.MSC_OPERATION_COMPONENTS#' cause errors in multiple cases.
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
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