Import Shipping Locations Error: ORA-08004: sequence WSH_LOCATION_OWNERS_S.NEXTVAL exceeds MAXVALUE
(Doc ID 2769485.1)
Last updated on JANUARY 07, 2022
Applies to:Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, WMS, Shipping & Transportation
When attempting to run Import Shipping Locations the following error occurs.
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)
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
The issue has the following business impact:
Due to this issue it causes Incorrect lane days calculation.
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