Order Line Status Stuck At "Awaiting Reprice - Pricing Error" When Using Secondary Price lists (Doc ID 2418874.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

Finds that when using line workflow "Line Flow - Generic, with Repricing at Fulfillment"
that the line is stuck in workflow line status REPRICE_PRICING_ERROR and the following line processing errors are shown.

ERROR

Line Processing Messages

LINE HEADER_ID LINE_ID MSG_SOURCE PROCESS_ACTIVITY ACTIVITY_NAM REQUEST_ID REQ MESSAGE_TEXT
2.1 193289 139969 C=Conc Process 259610 Reprice 12345 Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 12346 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 12347 Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 12348 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 12345 Hold source already exists.
2.1 193289 139969 C=Conc Process 259610 Reprice 12346 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... XXX and LBS not on <Price List>
2.1 193289 139969 C=Conc Process 259610 Reprice 12347 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... XXX and LBS not on <Price List>
2.1 193289 139969 C=Conc Process 259610 Reprice 12348 Hold source already exists.



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

1. Has Added Event "Enter Shipment" Event in the Pricing Phase "List Line Base Price"

2. Has a primary price list setup which has two secondary price lists.

The primary price list defaults on header then to lines.
Primary price list = <Primary price list>
Secondary price lists:
  <Price List2> applies to PRICING_ATTRIBUTE3 ALL, UOM=LBS, effective: 01-APR-18 thru 27-JUN-18, Precedence: 133
  <Price List3> applies to PRICING_ATTRIBUTE3 ALL, UOM=LBS, effective: 28-JUN-18 thru 30-JUN-18, Precedence: 140

3. Responsibility: Order Management Super User (or equivalent)
4. Navigate to: Orders, Returns > Sales Orders
5. Query the order
  * Tried Actions > progress sales order
  original pricing date: 27-JUN-18
  new pricing date (fulfillment date) = 28-JUN-2018
  line price list = <price list2>
  header price list = <primary price list>


Price Line Information
-------------------------------
*LINE_INDEX :=1
*LINE_ID :=162969
LINE_TYPE_CODE :=LINE
UOM_QUANTITY :=
CURRENCY_CODE :=USD
PRICED_QUANTITY :=1.0001
PRICED_UOM_CODE :=LBS
*UNIT_PRICE :=
*PRICE_LIST_ID :=XXXX
LINE_QUANTITY:=.03646
LINE_UOM_CODE:=FT
LINE_UNIT_PRICE:=
PERCENT_PRICE :=
*ADJUSTED_UNIT_PRICE :=100
PARENT_PRICE :=
PARENT_QUANTITY :=
PARENT_UOM_CODE :=
processed_code :=NMS
processed_flag :=N
Price Flag :=Y
*STATUS_CODE :=IPL
*STATUS_TEXT :=Price was not found on price list <Price List2> for this item XXXXX and uom FT.
HOLD_CODE :=
HOLD_TEXT :=
PRICE_REQUEST_CODE :=
PRICING_DATE := 28-JUN-18

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.