Credit Only Return Order Has Incorrect Freight Charge When Original Order is Copied At Original Selling Price (Doc ID 2201506.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR  
---------------
Find that copying a sales order at original price results in a credit only return order
that has a different unrounded quantity for line charge (Qty: 13.185 with Charge:  -74.9147967)
than what is shown for the original order's line charge (Qty: 13.2     with Charge: 75.00)

EXPECTED BEHAVIOR
-----------------------
Expects that the charge quantity and charge (amount) will be the same for both orders since copied with
pricing option 'At Original Selling Price'


NOTES
-------------------------
These debug statements "BEGIN GET_ORDERQTY_VALUES: line_qty"
are within PACKAGE BODY QP_PREQ_PUB AS QPXPPREB.pls

Customer has version 120.27.12010000.31
Hence fix is already present on Customer's instance from <Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY

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

1) Set profile options:
     OM:Unit Price Precision Type EXTENDED Site  
     QP: Unit Price Precision Type EXTENDED Site
     QP: Selling Price Rounding Options Individual: Selling Price = round(listprice) + round(adjustments): Rounds the selling price and adjustments  Site
     QP: Price Rounding FACTOR Site  

2) Custom Pricing Attribute,  Pallet Charge Attribute, Setup
-------------------------------------------------------------
     SEGMENT_CODE = XX_PALLET_CHARGE
     SEGMENT_MAPPING_COLUMN = PRICING_ATTRIBUTE22
     USER_VALUE_STRING = xxson_qp_pricing_pkg.get_number_of_pallets(OE_ORDER_PUB.G_LINE.LINE_ID)
Above package is to calculate the number of Pallet (LPN)
After ship confirmed Number of LPN shipped will get count and the charges apply based on the formula.


3) Setup Formula:
    Formula Setup:
    Name: PALLET CHARGE
    Formula: 1*2
    Step 1: Pricing Attribute, Pallet Charge Attribute
    Step 2: Modifier Value (in this case = 7.5)

4) Freight Charge Modifier Setup
     List_line_id = 2197443
     Automatic line level LUMPSUM 7.5 with formula from step #3 above.

5) UOM conversion THO to Ea

    unit: Thousand
    Class: number
    Conversion: 1000
    Base Unit: Each
    1000 THO = 1 Ea


6) Price List
    Shows multi currency conversion list = Generated Currency For EUR 60...
    Base Round To = -5
    Price list line is setup with UOM = THO


7) Currency Precision & Extended Precision.
    currency code = EUR
    Precision = 2
    Extended Precision = 5

7) Enter original order
a. Responsibility: Order Management Super User (or equivalent)
b. Navigate to: Orders, Returns > Sales Orders
NOTE: the item is entered with UOM = Ea...therefore pricing quantity will NOT equal ordered quantity since price list line is in UOM THO (1000 THO = 1 Ea).

8)  Actions > Copy with pricing option = At Original Selling Price to a return order


Cause

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