AR Diagnostic Report Errors Java.sql.SQLException: Numeric Overflow (Doc ID 2297567.1)

Last updated on AUGUST 16, 2017

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information 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

Cause

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