Rescheduling Issue - User Defined Exception In Package WSH_EXCEPTIONS_S.NEXTVAL (Doc ID 2251569.1)

Last updated on DECEMBER 06, 2022

Applies to:

Symptoms

On : 11.5.10.2 version, Scheduling and Sourcing

When attempting to change the Planned Pick Date or the Schedule Ship Date,
the following error occurs.

ERROR
-----------------------
Unexpected error has occured. Oracle error message is ORA-08004: sequence WSH_EXCEPTIONS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated

Exiting OE_Delayed_Requests_Util.Update_Shipping
unexp error Process_Request_Pvt
SQL ERROR MESSAGE:User-Defined Exception

WSH_USA_CATEGORIES_PVT.CHANGE_SCHEDULED_DATE - EXCEPTION:UPDATE_NOT_ALLOWED 
  UPDATE_NOT_ALLOWED exception has occurred.

ENTER OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , COLUMN:PROMISE_DATE
VALIDATION PKG :OE_2PC1_ORDER_BOOKED2 RESULT :1
EXIT OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , RESULT:1
column name : PROMISE_DATE

VALIDATION PKG :OE_2PC1_ORDER_PSNUO RESULT :1
ADD CONSTRAINT MESSAGE
EXIT OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , RESULT:1
column name : SCHEDULE_SHIP_DATE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management responsibility
2. Navigation:Orders,Returns>Order Organizer
3. Query order and see issue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot change the Planned Pick or Schedule Ship dates.

Changes

Cause

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