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

Last updated on FEBRUARY 18, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.