My Oracle Support Banner

Planning ODS Load Program and Planning ODS Load Workers Failed With Error: ORA-08004: sequence MSC_SUPPLIER_CAPACITIES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated (Doc ID 2973642.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 and later
Information in this document applies to any platform.

Symptoms

 Planning ODS Load and Planning ODS Load Worker failed.

Error Message from the Worker log:

***********************************************************

Bad sqls for this session
------------------------------------------------------------
************************************************************
08-SEP 04:48:33 : ========================================
08-SEP 04:48:33 : Error in PROCEDURE=LOAD_SUPPLIER_CAPACITY, TABLE=MSC_SUPPLIER_CAPACITIES
08-SEP 04:48:33 : COLUMN=ITEM_NAME, VALUE=xxxxxx
08-SEP 04:48:33 : COLUMN=ORGANIZATION_CODE, VALUE=PRD:xxx
08-SEP 04:48:33 : COLUMN=SUPPLIER_ID, VALUE=33
08-SEP 04:48:33 : COLUMN=SUPPLIER_SITE_ID, VALUE=89
08-SEP 04:48:33 : COLUMN=FROM_DATE, VALUE=15-MAY-11
08-SEP 04:48:33 : ORA-08004: sequence MSC_SUPPLIER_CAPACITIES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
08-SEP 04:48:33 : ========================================

-- error repeats for several iterations

 

NAV: Advanced Supply Chain Planning / Data Collections / Oracle Systems / Standard Data Collections - - set parameters and launch the request set

 

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


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