My Oracle Support Banner

Error Allocating Shipments - No ord_line_gid relationship exists on SShipUnitLine (Doc ID 737161.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Freight Payment, Billing, and Claims - Version 5.5 and later
Information in this document applies to any platform.


-- Problem Statement:
The following error could be generated in the Oracle Transportation Management , OTM,  Exception logs anytime the Shipment Cost Allocation process is run.

Error Exception Allocation::initializePlanningCosts - No ord_line_gid relationship exists on
SShipUnitLine - DOMAIN.SSUL_ID, ShipUnitLineNo - 1 (shipPK=DOMAIN.SHIPMENT_ID)
Shipment was not allocated - DOMAIN.SHIPMENT_ID (sShipUnitGid=DOMAIN.SSU_ID, sShipUnitLineNo=1)

-- Steps To Reproduce:
This issue is a data related issue that could occur any time the allocation process is run. Since each OTM implementation is different the steps to reproduce this error will vary depending on when shipment cost is allocated.

One way to reproduce this issue would be the following:

1. Create a Shipment in OTM
2. Send in shipment actuals to update the shipment ( Leave out some ShipUnitContent data )
3. Re-calc and re-allocate the cost of the shipment via an agent when the Shipment Actuals are received
4. Verify if a similar error is being generated in the OTM Exception logs

-- Business Impact:
The issue has the following business impact:
Due to this issue, Allocation of Shipment Costs on some Shipments can not be completed.




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.