Shipping Outbound Errors - java.sql.SQLException: Numeric Overflow (Doc ID 2897469.1)

Last updated on OCTOBER 21, 2022

Applies to:

Symptoms

When attempting to run Shipping-Transportation Outbound Interface to send the data to OTM,
the following error occurs.

ERROR
Release Query : select distinct wnd.delivery_id, wnd.name, wnd.organization_id, wnd.gross_weight, wnd.weight_uom_code, wnd.planned_flag, wnd.initial_pickup_location_id from wsh_new_deliveries wnd where ((wnd.tms_interface_flag in ( 'CR','UR','CP','UP') and nvl(wnd.ignore_for_planning,'N') = 'N' and wnd.status_code = 'OP' ) OR (wnd.tms_interface_flag in ('DP', 'DR' ))) and wnd.organization_id = :1 order by wnd.delivery_id
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4514)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:144)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:2040)
at oracle.apps.wsh.outbound.cp.request.OutboundInterface.runProgram(OutboundInterface.java:479)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
CP main completed runProgram for oracle.apps.wsh.outbound.cp.request.OutboundInterface
  - Java Concurrent Request Id: 687931873
  - Apps Context Session Id: 0x67e73007
  - JDBC Connection String: oracle.jdbc.driver.T4CConnection@6557a533
  - Database Session AUDSID: 985890785
  - FND_GLOBAL Concurrent Request Id: 687931873


STEPS TO REPRODUCE
1. Run request Shipping-Transportation Outbound Interface to send the data to OTM
2. Error message is displayed
 

Changes

Customers DBA's had to do an alter sequence for Deliveries as the pick release jobs globally were failing.

The alter sequence done by the DBA's is as follows:

ALTER SEQUENCE WSH.WSH_NEW_DELIVERIES_S MAXVALUE 9999999999

As per: <Document 2253727.1> - WSH_NEW_DELIVERIES_S Sequence Max Value Will Soon Be Reached. Is It Okay to Make New Max Value?

Cause

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