My Oracle Support Banner

ORACLE Error 12801 In Mrllwc_load_wip_components While Running Plan (Doc ID 2195451.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

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

Symptoms

12.2.5 in Production and Test


PROBLEM
-------------
MSCNSPWA64 module: Memory Based Snapshot 64 bit AIX fails with:

APP-FND-01564: ORACLE error 12801 in mrllwc_load_wip_components

Cause: mrllwc_load_wip_components failed due to ORA-12801: error signaled in parallel query server P007
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1
.

The SQL statement being executed at the time of the error was: select mscd.inventory_item_id ,mscd.organization_id ,mscd.sr_instance_ and was executed from the file /data1/EBS64_TOOL/APS64_R122_WORKER/msc/src/mslnex.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 15, 10007, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10007, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 13, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
Error string=
Statement with the error:
select mscd.inventory_item_id ,mscd.organization_id ,mscd.sr_instance_
/data1/EBS64_TOOL/APS64_R122_WORKER/msc/src/mslnex.pc

STEPS
--------
Launch unconstrained plan.

BUSINESS IMPACT
----------------------
Unable to run plan without error.

Cause

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.