R12:INV:Document Sequencing Length in AP should be More than 9 Digits,Error APP-FND-01564
(Doc ID 1228794.1)
Last updated on MARCH 29, 2021
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 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
Solution
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
| Goal |
| Solution |
| References |