MRCNSW Memory Based Snapshot Worker Errors Ora-08004 mrsngs_snp_gross_rqmts - Also MSCPUSH - Push Plan Errors ORA-02055 ORA-08004 ORA-2063 (Doc ID 577658.1)

Symptoms

User is running MRP and MRCNSW - Memory Based Snapshot Worker errors with the following:

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, , )
APP-22075: An internal error has occurred (mrnspxt, 20, 10008, )
APP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10008, )
APP-22075: An internal error has occurred (main, 13, , )
Contact your customer supportrepresentative.

Statement with the error:
SELECT mrp_gross_requirements_s.nextval,
dates.inventory_item_i
1880439/mrp/src/mrlsdi.pc

New update 15-APR-2015 - Problem also occurs in ASCP with MSCPUSH - Push Plan with the following errors:

ORACLE error 2055 in FDPSTP

Cause: FDPSTP failed due to ORA-02055: distributed update operation failed; rollback required
ORA-08004: sequence MRP_GROSS_REQUIREMENTS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-02063: preceding line from


STEPS
The issue can be reproduced at will with the following steps:
1. Run MRP Plan
2. Log file shows failure

or

1.  Run MSCPUSH from ASCP to populate MRP tables
2.  Log files shows failure

Cause

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