My Oracle Support Banner

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

Last updated on JULY 05, 2018

Applies to:

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

Symptoms

Finds that 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 8679489 Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 8682402 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 8682402 Unit List Price is required on a booked order line.
2.1 193289 139969 C=Conc Process 259610 Reprice 8679489 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 8682402 Hold source already exists.
2.1 193289 139969 C=Conc Process 259610 Reprice 8679489 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... 10018061 and LBS not on Q2 - Std Pricing
2.1 193289 139969 C=Conc Process 259610 Reprice 8682402 Exceptions occurred while pricing, query your order in message processing window to see the exceptions... 10018061 and LBS not on Q2 - Std Pricing
2.1 193289 139969 C=Conc Process 259610 Reprice 8679489 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 = STD PRICE LIST
Secondary price lists:
  Q2 - Std Pricing, applies to PRICING_ATTRIBUTE3 ALL, UOM=LBS, effective: 01-APR-18 thru 27-JUN-18, Precedence: 133
  Q3 - Std Pricing, 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 = Q2 - Std Pricing
  header price list = STD 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 :=75031
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 Q2 - Std Pricing for this item 10018 and uom FT.
HOLD_CODE :=
HOLD_TEXT :=
PRICE_REQUEST_CODE :=
PRICING_DATE := 28-JUN-18




Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.