MPS/MRP Plans Not Completing. - Getting ORA-00001 and/or ORA-8004 and/or ORA-01455 (Doc ID 431482.1)

Symptoms

EXAMPLE #1  - ORA-00001

After resetting the sequence number for MRP_GROSS_REQUIREMENTS_S back to 1, the MRCSLD module:
Loader Worker fails with:

ERROR
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

ERROR
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),
items.inventory_item_
mrlsfo.pc

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
mrp_gross_requirements_s.nextval,
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, , )

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.