Last updated on MARCH 12, 2017
Applies to:
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
Goal
Can Document Sequencing Length be greater than 9 digits as your requirement is to have till 14 digits?
Customer has requirement to use 14 digit document sequencing and while entering the invoice with such a lengthy document sequencing, it errors as:
APP-FND-01564 ORACLE error 1455 in fdsgsv
Cause: fdsgsv failed due to ORA-01455: 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
Solution
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