My Oracle Support Banner

Freight Charges Are Not Calculated With Modifiers Setup With Net Amount Flag As Y (Doc ID 2358303.1)

Last updated on MAY 16, 2023

Applies to:

Oracle Advanced Pricing - Version 12.2.4 and later
Information in this document applies to any platform.


One has a modifier setup with net amount flag as Y (matching all attributes) which is used to calculate the freight charges.
One had issues with the charges calculation based on this modifier setup and <Patch 25888061:R12.QP.C> was suggested to address this issue.

There are  multiple order taking applications(other than Oracle EBS) which use the pricing APIs to calculate price and charges. These applications are not calculating freight correctly for the modifiers when one uses the net amount flag.

This was working in R11 environment.

The issue can be reproduced at will with the following steps:

1. Using Responsibility Oracle Pricing Manager setup the surcharge (SURTAX Tax Amount)
list price = xxx
uses formula = FORMULASURTAX SURTAX and application method NEW PRICE.

formula= 1/2
  step 1: list Price
  step 2. factor list (FORMULASURTAX SURTAX V3)

  Base pricing Attributes:
  multiple lines for Sales order, customer ship to State
  Associated pricing attributes:
  sales order,  harmonized code = yyyy

2. Define Freight Charge:

Freight Factor * (Total Selling price + SURTAX charges).

SURTAX charges is based on the ship-from state and ship-to state and this is setup as a pricing formula in Oracle.
Freight factor is setup as a price break.

3. Using customized GOC (global order capture) which is a customized telesales screen, enter the order,  Price_request API is called to determine the applicable freight charges (enter customer id and line items then click on price order - the charges and other details get calculated through a call to the price_request API)

4. After the order was created  then order is imported using process order API.

*Note: When the first line item is entered, the freight charges look fine. Issue starts after the second line item is entered.




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.