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

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
lahham101
Posts: 6
Joined: Wed Mar 18, 2009 3:21 am
Location: Saudi Arabia

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

Post 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
jacope
Posts: 2
Joined: Thu Aug 06, 2009 8:15 am
Location: Egypt

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

Who is online

Users browsing this forum: Google Adsense [Bot] and 20 guests