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 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
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
Symptoms |
Cause |
Solution |
References |