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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms