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

Last updated on MARCH 08, 2017

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

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