Return Order Created Using Copy Order Is Not Having the Same Original Unit Selling Price As Expected

(Doc ID 2357391.1)

Last updated on FEBRUARY 05, 2018

Applies to:

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



Find that an original order copied with pricing option = Original Selling Price
to a return order, does not copy all adjustments from the original order.
This results in an incorrect Unit Selling Price returned for two lines on the return order.

While copying the the original Order and creating a return order from it,
two order line adjustments are not getting copied :

List Header iD: 1604, List Line ID: 153679, Pricing Phase:3121

List Header ID: 1368, List Line ID: 22818, Pricing Phase: 3121

Pricing Phase 3121 has BATCH, BOOK, SHIP pricing events with freeze override enabled.

Both modifiers include the custom qualifier Order  (QUALIFIER_ATTRIBUTE33)

Expects the return order lines Unit Selling Price(USP) to be for the same USP as the original order.


Other modifiers are assigned to a different pricing phase that does not have freeze override enabled.
These modifiers are being copied to the return order without issue.


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

1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Query Original sales order 10000083
    subtotal: 618.60
      Line 1.1, item 198802, USP 76.56, ULP 85.20
      Line 2.1, item 207022, USP 330.72, ULP 330.72
      Line 3.1, item 207022, USP 330.72, ULP 330.72
      Line 4.1, item 254505, USP 62.04, ULP 80.11
4. Copy order w/pricing option = At Original Selling Price
    Return order created 21000004

    subtotal: -826.75

      *Line 1.1, item 198802, USP -85.20, ULP 85.20 (USP on return order differs from original order USP by 8.64)
       Line 2.1, item 207022, USP -330.72, ULP 330.72
       Line 3.1, item 207022, USP -330.72, ULP 330.72
      *Line 4.1, item 254505, USP -80.11, ULP 80.11 (USP on return order differs from original order USP by 18.07)


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