R12: AP: How Can Invoices Accept Document Sequences Of 10 or More Digits? That Will Avoid Error: APP-FND-1564 ORACLE error 1455 in fdsgsv
(Doc ID 1569232.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterOracle Cash Management - Version 12.2.8 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
Symptoms
On : 12.1.3 version,
When attempting to set up a document sequence for 11 digits or more, the following error occurs.
ERROR
APP-FND-1564 ORACLE error 1455 in fdsgsv
Cause: fdsgsv failed due to ORA-1455: converting column overflows integer
datatype.
The SQL statement being executed at the time of the error was: SELECT
FND_DOC_SEQ_24_S.NEXTVAL FROM SYS.DUAL and was executed from the file
&ERRFILE
Changes
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 |
Changes |
Cause |
Solution |
References |