Freight Charges Are Not Calculated With Modifiers Setup With Net Amount Flag As Y
Last updated on APRIL 06, 2018
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 name = FORMULASURTAX SURTAX
step 1: list Price
step 2. factor list (FORMULASURTAX SURTAX V3)
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.
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