My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Shipping Execution - Version to [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.

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

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


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

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