MSCXPUBO - Collaboration ODS Load Errors ORA-08004: Sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL Exceeds MAXVALUE (Doc ID 2253946.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Collaborative Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9 version, Collections/Collab ODS Load in PROD:

Users are on 12.1.3 and have applied VCP 12.1.3.9.1 Patch 17350769. At the end of data collections is spawned a concurrent request to load data for Collaborative Planning called MSCXPUBO module: Collaboration ODS Load. However it errors with the following:

ERROR
-----------------------
ERROR while inserting from unallocOnhand to msc_sup_dem_entries
ORA-08004: sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.MSC_TRG_AUDIT", line 6
ORA-04088: error during execution of trigger 'APPS.MSC_TRG_AUDIT'
Total records fetched for Allocated Onhand:2363
Total records for insertion for Allocated Onhand:2363
ERROR while inserting from allocOnhand to msc_sup_dem_entries
ORA-08004: sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.MSC_TRG_AUDIT", line 6
ORA-04088: error during execution of trigger 'APPS.MSC_TRG_AUDIT'
Total records fetched for Sales Orders :153427
Total records for insertion for Sales Orders:153427
ERROR while inserting from Sales orders to msc_sup_dem_entries
ORA-08004: sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.MSC_TRG_AUDIT", line 6
ORA-04088: error during execution of trigger 'APPS.MSC_TRG_AUDIT'
updating pegging info for int reqs 1
Collection mode for Supplier Responses in Collaboration ODS Load : C
The language Code :US
l_end_order_type_desc :Purchase order
No. of Records for PO ACK :0
Writing the lv_sql_stmt
Total records fetched for ASN Deliveries--j1-- :0
Total records fetched for ASN Deliveries--j2-- :0
Total records fetched for ASN Deliveries--j3-- :0
Total records fetched for ASN Deliveries--j4-- :0
Total records fetched for ASN Deliveries :0
Total records for insertion for ASN Deliveries :0
updating pegging info for int reqs using ASN.
Total Records for update of Reqs from ASN : 0
Error in updating last_refresh_number of non OEM transactions.
ORA-08004: sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.MSC_TRG_AUDIT", line 345
ORA-04088: error during execution of trigger 'APPS.MSC_TRG_AUDIT'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run data collections
2. The last request spawned is called MSCXPUBO module: Collaboration ODS Load
3. Log file fails with multiple errors

Cause

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