MPS/MRP Plans Not Completing. - Getting ORA-00001 and/or ORA-8004 and/or ORA-01455
Last updated on FEBRUARY 14, 2018
Applies to:Oracle Materials Requirement Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
EXECUTABLE:MRCNEW - Memory-based Planner
EXECUTABLE:MRCNSP - Memory-based Snapshot
EXECUTABLE:MRCSLD - Loader Worker
***Checked for relevancy 16-May-2013***
EXAMPLE #1 - ORA-00001
After resetting the sequence number for MRP_GROSS_REQUIREMENTS_S back to 1, the MRCSLD module:
Loader Worker fails with:
Record 10652: Rejected - Error on table MRP.MRP_GROSS_REQUIREMENTS.
ORA-00001: unique constraint (MRP.MRP_GROSS_REQUIREMENTS_U1) violated
EXAMPLE #2 - Copy Plan Fails on MRP_GROSS_REQUIREMENTS_S sequence
Copy MRP program fails with 'ORA-08004: sequence MRP_GROSS_REQUIREMENTS_S.NEXTVAL exceeds
MAXVALUE and cannot be instantiated' error.
The value of MAXVALUE of the sequence is altered (doubled) and then relaunched the process.
The Process has failed again with
ORA-01455: converting column overflows integer datatype' error.
EXAMPLE #3 - MRP Plan fails on MRP_SCHEDULE_DATES_S sequence
Memory Based Snapshot Worker - MRCNSW errors with:
APP-01564: ORACLE error 1455 in mrsmps_snp_mps_orders
Cause: mrsmps_snp_mps_orders failed due to ORA-01455: converting column overflows integer datatype
The SQL statement being executed at the time of the error was: SELECT NVL(dates.mps_transaction_id, -1),
items.inventory_item_ and was executed from the file mrlsfo.pc.
APP-22075: An internal error has occurred (mrsnp_firm_orders, 1, , )
APP-22075: An internal error has occurred (mrnspxt, 23, 10010, )
APP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10010, )
APP-22075: An internal error has occurred (main, 13, , )
Statement with the error:
SELECT NVL(dates.mps_transaction_id, -1),
EXAMPLE #4 - MRP Plan fails on MRP_GROSS_REQUIREMENTS_S sequence
APP-01564: ORACLE error 8004 in mrsngs_snp_gross_rqmts
Cause: mrsngs_snp_gross_rqmts failed due to ORA-08004: sequence MRP_GROSS_REQUIREMENTS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
The SQL statement being executed at the time of the error was: SELECT
dates.inventory_item_i and was executed from the file 1880439/mrp/src/mrlsdi.pc.
APP-22075: An internal error has occurred (mrsndi_snp_demand_info, 2, , )
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