"java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL" Error When Running Shipment Group Action: Pickup -> Send Pickup Notification
Last updated on MARCH 01, 2017
Applies to:Oracle Transportation Management - Version 5.5.05 to 5.5.05.05 [Release 5.5]
Information in this document applies to any platform.
***Checked for relevance on 17-Sep-2013***
-- Problem Statement:
When running the action "Pickup -> Send Pickup Notification" from a Shipment Group, no notification is being sent. This is true regardless of a LOGISTICS party being assigned to the Shipment Group. In reviewing the logs, the following Exception is presented:
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
-- Steps To Reproduce:
1. Navigate to Shipment Group Management -> Shipment Group.
2. Search for Shipment Group.
3. Actions -> Pickup -> Send Pickup Notification.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms