ORA-06502: PL/SQL: numeric or value error: character to number at the time

[sonuji_in]

hi
I am getting the following error while running adaimgr

get de following error on the worker:
java "-mx128m" "oracle.apps.ak.akload" "APPS" "APPS" "thin"
"(DESCRIPTION=(ADDRESS=(PROTO =TCP)(HOST=test)(PORT=1521))(CONNECT_DAT
=(SID=prod)))" "UPLOAD" "/applr11/pepsi11i/pepsiappl/ak/import/US/aksflow.jlt"
"update" "AMERICAN_AMERICA.AR8iso8859p6"
**********
Start of Core Modules - AK Loader file Upload Session.
TUE 04 12 2005 11:49:22
**********
FND_AS_UNEXPECTED_ERROR (PKG_NAME=AK_ON_OBJECTS_PVT) (PROCEDURE_NAME=Upload)
(E\
RROR_TEXT=ORA-06502: PL/SQL: numeric or value error: character to number
conver\
sion error)
**********
TUE 04 12 2005 11:49:23
End of Core Modules - AK Loader file Upload Session.
Error: java.lang.Exception: Error encountered while calling upload stored

procedure
java.lang.Exception: Error encountered while calling upload stored procedure
at oracle.apps.ak.akload.performUpload(akload.java:324)
at oracle.apps.ak.akload.main(akload.java:112)

any body can help me on this , Because i have deeply struck due to this problem

ABHI

[OracleDoc]

Metalink have anything to say about it?

[mikerault]

Yes:

Check the version of akload.java with the following command :
cd %AU_TOP%\java
adident Header apps.zip

One line of the above command should be :
akload.java 115.5

If the version is 115.5 or lower , then you have run into bug 1361854. The solution is to apply patch 1361854 which upgrades akload.java to version 115.6. This should fix the problem.

Mike