Page 1 of 1

I need help with this error (APP-FND-01564: ORACLE

Posted: Sat May 29, 2010 3:43 am
by lahham101
Hi

when I try create new journal in Oracle GL application
I get this error message :

<b>APP-FND-01564: ORACLE error 1455 in fdsgsv</b>Cause : fdsgsv failed due to ORA-01455:converting column overflows integer datatype.

Please help

regards

Posted: Tue Jun 22, 2010 7:46 am
by jacope
Symptoms
FAPOST errors with the following:

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_77_S.NEXTVAL
FROM SYS.DUAL and was executed from the file &ERRFILE.
APP-OFA-48157: Failed to fetch next sequence value
Error: function fagdns returned failure (called from fapbgl)
ERROR occurred in fapbhl routine ---- DEPRECIATION
Cause
The issue seems to be happening because the sequence is too large for the
value to fit in the INTEGER field in the table.
Sequence number defined was very huge.
Fix
The largest number you can use is approx 4 billion, range of integer is
approximately -4 to +4 billion
You should start at sequence at -0- rather than a value exceeding 4 billion