QP_PREQ_PUB.PRICE_REQUEST Is Not Working after Applying 12.1.3 Consolidated Patches Error "Routine:QP_PREQ_GRP.INSERT_LINE_ATTRS2 ORA-22160: element at index [1] does not exist" (Doc ID 2038032.1)

Last updated on AUGUST 05, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Formula Screen and API

When attempting to run the qp_preq_pub.price_request in the patched instance
the following error occurs.

ERROR
-----------------------
IN ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH
Asked For List Header ID:1966437Line : 1
List line id selected from asked for prom l_other_list_cur : 1720773
Java Engine not Installed ----------
Routine:QP_PREQ_GRP.INSERT_LINE_ATTRS2 ORA-22160: element at index [1] does not exist
ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH User-Defined Exception
ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH User-Defined Exception
Exception Price Request GRP: ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH User-Defined Exception
Exception Price Request: User-Defined Exception

 

Steps to Reproduce

--------------------------

1. Run the qp_preq_pub.price_request to get price and order.

2.  If you send promotions at the line level, it errors:

Exception Price Request GRP: ROUTINE:QP_PREQ_GRP.LIST_HEADER_SEARCH User-Defined Exception

 

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