R12:INV:Document Sequencing Length in AP should be More than 9 Digits,Error APP-FND-01564
Last updated on JANUARY 16, 2018
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.
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
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