Unexpected Error While Printing Bol -WSH_Document_PVT, Oracle Error - -20001 (Doc ID 563519.1)

Last updated on JULY 08, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.



Symptoms

11.5.10.2,
When attempting to print BOL from Shipping Transactions screen, an  encountered. an ERROR
"Unexpected Error: Error in Routine WSH_Document_PVT, Oracle Error - -20001, Failure in performing
action"

The debug file shows this as the clear indication of the BOL failure

Error in Routine WSH_Document_PVT, Oracle Error - -20001 Failure in performing action
Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/31/2008 03:16:02 PM, 0 seconds) Unexpected
error has occured. Oracle error message is ORA-20001: APP-FND-01564: ORACLE error -2289
in get_next_auto_seq Cause: get_next_auto_seq failed due to ORA-02289: sequence does not exist.
The SQL statement being executed at the time of the error was: select FND_DOC_SEQ_111_S.nextval
into :next_val from sys.dual and was executed from the file AFSQNUMB.pls.
Exiting WSH_DOCUMENT_PVT.CREATE_DOCUMENT - EXCEPTION:
OTHERS (03/31/2008 03:16:02 PM, .05 seconds) WSH_CREATE_DOCUMENT_ERROR exception has occured. Exiting WSH_BOLS_PVT.INSERT_ROW -EXCEPTION:WSH_CREATE_DOCUMENT_ERROR


This message is coming from a package called FND_SEQNUM
WSH calls this package to generate a new document sequence
number for BOL and Pack Slip. The Filename is AFSQNUMB.pls
 

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