Unexpected Error While Printing Bol -WSH_Document_PVT, Oracle Error - -20001
Last updated on JULY 08, 2017
Applies to:Oracle Shipping Execution - Version 18.104.22.168 to 22.214.171.124 [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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms