ORACLE Error 12801 In Mrllwc_load_wip_components While Running Plan
(Doc ID 2195451.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.5 and laterInformation 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 |