WSHFXCSM : Freight Carriers Form Error : APP-WSH-228390: Record with this combination already exists (Doc ID 2239228.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms


When attempting to create a Service for a Freight Carrier,
the following error occurs.

ERROR

APP-WSH-228390: Record with this combination already exists.

But ideally the record is not existing and is not visible or available through the Form.
When checked from backend , find the record exists in the base table WSH_CARRIER_SERVICES but is not shown in the
view WSH_CARRIER_SERVICES_V.

This issue is reported for couple of Freight Carriers

STEPS

The issue can be reproduced at will with the following steps:
1. Order Management responsibility
2. Shipping > Setup > Freight Carriers
3. Query the Carrier for which the Services is to be added
4. Enter the Service Level , Mode and see the above error


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