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

Last updated on FEBRUARY 01, 2022

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

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

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.