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.
***Checked for relevance on 09-SEP-2013***


On : 12.1.2 version, Pricing, Discounting & Charges

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

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

Is able to add and change items on the price list.
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.


 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 
 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)


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