How to Change Subtotal Calculation In Freight Costs Form With Forms Personalization (Doc ID 1919819.1)

Last updated on FEBRUARY 17, 2015

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How can the subtotal calculation in the Freight Costs form with a forms personalization to achieve the following:

-Want to take the Amount column and the FlexField column which is used for absorbed costs and sum the value of those into the Subtotal field.
-With the current functionality, the Subtotal field only sums the Amount column. The Subtotal field is in the freight_costs_control block in the field subtotal_freight_cost.
-The following query shows the desired output.

SELECT SUM (UNIT_AMOUNT) + SUM (ATTRIBUTE1) "Subtotal"
FROM WSH_FREIGHT_COSTS_V
WHERE TRIP_ID = XXXXXX;
 

Solution

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