My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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