My Oracle Support Banner

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 MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.0 to 6.0.3 [Release 6]
Information in this document applies to any platform.
This problem can occur on any platform.


-- 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 = ?; [<VALUE>]

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.


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

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