APP-236113: Routine :QP_PREQ_PUB.Calculate_price ORA-22160: Element At Index[#] Does Not Exist

(Doc ID 2323411.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Quoting - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, HTML User Interface

The following error is seen when attempting a manual price adjustment

ERROR
-----------------------
APP-236113: Routine :QP_PREQ_PUB.Calculate_price ORA-22160: element at index[4] does not exist


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

1) Create new quote, or find existing quote
2) Update the UNIT SELLING PRICE field on the quote line to be a manual/different value
3) Price the Quote
4) Receive error: APP-236113: Routine :QP_PREQ_PUB.Calculate_price ORA-22160:element at index [4] does not exist

If a second quote line is added, the [4] changes to a [7], third quote line [10].

 

Cause

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