AR Diagnostic Report Errors Java.sql.SQLException: Numeric Overflow
(Doc ID 2297567.1)
Last updated on FEBRUARY 18, 2019
Applies to:
Oracle E-Business Suite Diagnostics - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Log onto "Application Diagnostics / Oracle Diagnostics Tools" responsibility
Click "Select Applications" button
Search "Application Name" = Receivables
Navigate to Customers -> Customer Data
Press Execute
Give your Responsibility ID and Customer Number 1275542
Press “Submit” button. You get the following error for this specific customer number
EXCEPTION - Numeric Overflow caught in method 'ARCustomerInfo.isCustomerValid'
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4380)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:131)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:896)
at oracle.apps.ar.diag.ARCustomerInfo.isCustomerValid(ARCustomerInfo.java:250)
at oracle.apps.ar.diag.ARCustomerInfo.runSupportTest(ARCustomerInfo.java:125)
at oracle.apps.jtf.regress.qatool.base.DiagBase.runTest(DiagBase.java:373)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.runTest(LegacyJavaTestExecution.java:147)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.execute(LegacyJavaTestExecution.java:83)
at oracle.apps.fnd.oam.diagnostics.exec.WorkerThread.run(WorkerThread.java:49)
at java.lang.Thread.run(Thread.java:619)
ACTION - Please log an iTAR (Service Request) for product "Support Diagnostics Project" (ID=1332) to notify support about this issue
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |