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

Last updated on APRIL 04, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

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 occured.

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.

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