Attempting to Assign Ship Method to Org For Existing Freight Carrier Errors With APP-WSH-231106-Unexpected Error Pos 20 Updating WSH_ORG_CARRIER_SERVICES (Doc ID 730693.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
FORM:WSHFXCSM.FMB - Freight Carriers



Symptoms

When trying to assign an existing freight carrier to an org, by clicking on a ship method and opening the Org Assignments window, then selecting the org (ie Michigan) and clicking save, the following error is raised:

ERROR
---------

APP-WSH-231106-Unexpected errors encountered at position 20 when updating
WSH_ORG_CARRIER_SERVICES

Details: Exception Message, EXCEPTION: No Data Found, Error User-Defined Exception, Code 1

 
The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Shipping
3. Setup
4. Freight Carriers, Cost Types
5. Freight Carriers
6. Open an existing freight carrier
7. Click on a ship method
8. Click Org Assignments window
9. Choose Michigan in the organization assignments window and save. Get the error.



Changes

Upgraded to release 11.5.10 from a lower release of 11i.  Patch 4317851 has been applied to stop future occurrences of this issue suggested in Note 334422.1: APP-WSH-231106: Error When Attempting To Enable Org To Carrier Service where issue is fixed in file WSHFXCSM.fmb and version number 115.117.11510.9 or higher. 

In addition, error only occurs when trying to SAVE the record and only when assigning a freight carrier to a particular inventory organization (org_name = Michigan). Issue does not happen when trying to assign the same freight carrier to other inventory organizations.

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