My Oracle Support Banner

Import Shipping Locations Error: ORA-08004: sequence WSH_LOCATION_OWNERS_S.NEXTVAL exceeds MAXVALUE (Doc ID 2769485.1)

Last updated on APRIL 21, 2021

Applies to:

Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, WMS, Shipping & Transportation

When attempting to run Import Shipping Locations the following error occurs.

ERROR
  Exiting WSH_LOCATIONS_PKG.GET_LOCATION_OWNER (04/08/2021 03:01:45 PM, 0 seconds)
  Inserting owner table count 10
  UNEXPECTED ERROR WHILE CREATING LOCATION OWNER FOR LOCATION 170245
  ERROR MESSAGE ORA-08004: sequence WSH_LOCATION_OWNERS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
  Exiting WSH_LOCATIONS_PKG.UPDATE_LOCATIONS (04/08/2021 03:01:45 PM, .16 seconds)
  Error in Update_Locations
  Exiting WSH_LOCATIONS_PKG.PROCESS_LOCATIONS (04/08/2021 03:01:45 PM, .37 seconds)
  Return Status from WSH_LOCATIONS_PKG.Process_Locations : U
Failed in Procedure Process_Locations
ERRBUF ==> Map_Locations_Child_Program is completed with error
RETCODE ==> 2
Exiting WSH_MAP_LOCATION_REGION_PKG.MAP_LOCATIONS_CHILD_PROGRAM (04/08/2021 03:01:45 PM, .4 seconds)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a) Order Management Super User Responsibility
b) Navigate: Shipping--Interfaces--Run
c) Query for Import Shipping Locations


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue it causes Incorrect lane days calculation.

Changes

 

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
Changes
Cause
Solution
References


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