MSCXPUBO - Collaboration ODS Load Errors ORA-08004 Sequence MSC_SUP_DEM_HISTORY_S.NEXTVAL Exceeds MAXVALUE ORA-06512 ORA-04088
(Doc ID 2251652.1)
Last updated on SEPTEMBER 04, 2024
Applies to:
Oracle Collaborative Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
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
-----------------------
1. Run data collections
2. The last request spawned is called MSCXPUBO module: Collaboration ODS Load
3. Log file fails with multiple errors
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 |
References |