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