My Oracle Support Banner

Price Of Return (RMA) Order Line For Catch Weight Order Does Not Match With Referenced Order Line (Doc ID 2600039.1)

Last updated on OCTOBER 20, 2019

Applies to:

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


Advanced Catch Weight: Return Order Line's Price does not match with Sales Order. Price comes correctly when creating the Reference Return. But it gets changed as per Actual Secondary Ordered Quantity as soon as user saves the Line.

Advanced Catch Weight: Return Order Line's Price should match with Sales Order Line's Price.

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


A. Create an Item with following Attributes

1. Item Name: Chicken (For Example)
2. Item Description: Fresh Chicken
3. Copy the Finished Good Template
4. On the Main Tab, Enter the following attributes

Unit of Measure:
Primary: Each
Tracking: Primary & Secondary
Pricing: Secondary
Secondary: Kg (kilogram)
Defaulting: Default
Deviation Factor + : 100%
Deviation Factor - : 100%

5. Check the Returnable Checkbox in Order Management tab.
6. Assign the item to Shipping Org

B. Create the Unit of Measure Conversion Setup

1. On the Unit of Measure Conversion form, Click on Inter-class tab
2. Enter the following data:

Item: Chicken
Base Unit: Kg (kilogram) = 0.5 Each
Base Unit: Box = 10 Each

C. Create the On-Hands by doing the Miscellaneous Receipt.

D. Create a Price List Line with UOM as Kg, Primary Checked and Price as 10

E. Create the Sales Order Line with Ordered Quantity as 1 Ea and Over shipment Tolerance as 10%

F. Book the Order.

G. Do the Pick Release with Pick Confirm Set to No and Auto Allocate Set to Yes

H. On the Move Order form, Click on View/Modify Allocations. Allocate the Secondary Quantity as 2.5 Kg

I Transact the Move Order and Do the Ship Confirm with "Ship All" option selected.

J. Find that Sales Order Line's Unit List/Selling Price is Changed to 25 from 20.

K. Create the RMA with Reference to Above Order.

L. Correct Price comes as 25. It gets changed to 20 as soon as user Saves the changes.


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.