My Oracle Support Banner

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 17, 2019

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: xxxx, List Line ID: XXXXX, Pricing Phase:1234

List Header ID: xxxx, List Line ID: XXXXX, Pricing Phase: 1234

Pricing Phase 1234 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 XXXXXX1
    subtotal: 618.60
      Line 1.1, item ABCD, USP 76.56, ULP 85.20
      Line 2.1, item EFGH, USP 330.72, ULP 330.72
      Line 3.1, item IJKL, USP 330.72, ULP 330.72
      Line 4.1, item MNOP, USP 62.04, ULP 80.11
4. Copy order w/pricing option = At Original Selling Price
    Return order created XXXXXX2

    subtotal: -826.75

      *Line 1.1, item ABCD, USP -85.20, ULP 85.20 (USP on return order differs from original order USP by 8.64)
       Line 2.1, item EFGH, USP -330.72, ULP 330.72
       Line 3.1, item IJKL, USP -330.72, ULP 330.72
      *Line 4.1, item MNOP, USP -80.11, ULP 80.11 (USP on return order differs from original order USP by 18.07)


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.