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
Last updated on MAY 23, 2018
Applies to:Oracle Shipping Execution - Version 126.96.36.199 and later
Information in this document applies to any platform.
FORM:WSHFXCSM.FMB - Freight Carriers
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:
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
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.
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.
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