R12:INV:Document Sequencing Length in AP should be More than 9 Digits,Error APP-FND-01564
(Doc ID 1228794.1)
Last updated on APRIL 28, 2022
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 requirement is to have till 14 digits?
Business 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
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