QPXPRLST Open Price List Errors: Ora-01722: Invalid Number Frm-40505: Oracle Error Unable To Perform Query. (Doc ID 1157884.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:QPXPRLST.FMB - QP_PRICE_LIST_LISTINGS_OBS
***Checked for relevance on 09-SEP-2013***

Symptoms


On : 12.1.2 version, Pricing, Discounting & Charges

When attempting to open a price list,
the following error occurs.

ERROR
-----------------------
ORA-01722: invalid number
FRM-40505: ORACLE error unable to perform query.

NOTES
-----------
Is able to add and change items on the price list.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager or Order Management Super User
2. Navigate to: Price List > Price List Setup
3. Query a price list and the error is shown.


Changes

 To know the detailed error, can you please do the following:
 a) Close the error box.
 b) Do a Shift + F1 or Shift + Ctrl + E to see the detailed error message.
 The SQL statement in error is 
 SELECT 
NAME,PRECEDENCE,DESCRIPTION,LIST_HEADER_ID,PARENT_PRICE_LIST_ID,CREATION_DATE,
 CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,PROGRAM_APPLICAT
 ION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,REQUEST_ID,COMMENTS,END_DATE_ACTIVE,LIST
_TYPE_CODE,TERMS_ID,ROUNDING_FACTOR,CURRENCY_CODE,SHIP_METHOD_CODE,FREIGHT_TER
 MS_CODE,CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBU
 TE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRI
 BUTE13,ATTRIBUTE14,ATTRIBUTE15,qualifier_id,excluder_flag,comparison_operator_
 code,qualifier_context,qualifier_attribute,qualifier_attr_value,qualifier_grou
 ping_no,ROW_ID FROM qp_secondary_price_lists_v WHERE 
 parent_price_list_id=to_char(:1) AND -1=-1 and (PARENT_PRICE_LIST_ID=:2)
 

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