Allocate Cost Is Allocating To Only Some Orders On The Shipment And Not All Orders

(Doc ID 1382095.1)

Last updated on DECEMBER 22, 2017

Applies to:

Oracle Transportation Management - Version 6.2.3 and later
Information in this document applies to any platform.
***Checked for relevance on 31-Oct-2013***


On OTM version 6.2.3 the Shipment cost is not being equally split between the orders on the Shipment when Allocation is carried out.

Each stop incurs a different cost, after Allocation this cost is being allocated to the Order that incured that cost.  The total Shipment cost is not divided by the number of Orders.

The issue can be reproduced at will with the following steps:
1 - Log on to an OTM 6.2.3 system.

2 - Navigate to: Shipment Management > Power Data > Geography > Regions.

3 - Create the following:

ABC_1 containing location LJS_ORACLE_READING
ABC_2 containing location LJS_ORACLE_BRISTOL
ABC_3 containing location LJS_ORACLE_BIRMINGHAM

4 - Navigate to: Configuration and Administration > Process Management > Formulate Regions.

5 - Navigate to: Contract and Rate Management > Rate Offering > Create the following:


6 - From the Rate Offering created the following Rate Record:

From: Country GBR
To: Country GBR
Added three costs each by Stop Region:
50 USD for Region 1
100 USD for Region 2
150 USD for Region 3

7 - Create 3 Orders:
ABC_1 (London to Reading)
ABC_2 (London to Bristol)
ABC_3 (London to Birmingham)

Note: Restricted each to use Rate Offering ABC.

8 - Bulk Planned the order onto Shipment ID: 01565.

9 - The financials tab contains:
Base Cost: 150 USD
Base Cost: 100 USD
Base cost: 50 USD

10 - From the Shipment click on Financials > Allocate Cost.

The cost allocated was 300, the expectation is each Order is allocated 100 USD, so 1/3rd of the total cost.

The cost was allocated as follows:

ABC_1 50.00 USD.
ABC_2 100.00 USD
ABC_3 150.00 USD


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