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 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