GLOGOWNER.FK_SSSSC_SECONDARY_CHARGE_SHIP Error when Trying to Delete Secondary Charge Created by 'Add 3rd Party Service Provider' Shipment Action. (Doc ID 874184.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.0 to 6.0.3
This problem can occur on any platform.

Symptoms

-- Problem Statement:
When trying to delete a secondary charge which was created by using the Action 'Add Third Party Service Provider', the following error is received:

Error delete sc shipments

delete from shipment where shipment_gid = ?; [SH.01057]

Cannot delete the SHIPMENT record. A SHIP_SPEC_SVC_SEC_CHARGE_JOIN record references it in its[SECONDARY_CHARGE_SHIPMENT_GID] column. java.sql.SQLException: ORA-02292: integrity constraint (GLOGOWNER.FK_SSSSC_SECONDARY_CHARGE_SHIP) violated - child record found

-- Steps To Reproduce:
1. Log onto OTM.
2. Go to Shipment Management --> Shipment Management --> Buy Shipment.
3. Look up a shipment ID with a secondary charge.
4. Select the shipment and go to Actions --> Shipment Management --> Manage Groups and Charges --> Delete Secondary Charge.
5. Select Secondary Charge.
6. Click OK.
7. Note the 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