My Oracle Support Banner

QPXPRLST ORA-00933: SQL command not properly ended Select LOV for Pricing Attribute (Doc ID 377681.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
FORM:QPXPRMLS.FMB - Modifier Details

FORM:QPXPRDPL.FMB - Define Price Lists


When attempting to select the value from of a custom pricing or product attribute which is attached to a custom value set in the price list form or modifier form the following error occurs.

FRM-40502: ORACLE error: unable to read list of values


Details shows:

FRM-40502: ORACLE error: unable to read list of values

ORA-00933: SQL command not properly ended

If the same pricing context is accessed in the Sales Order Form -> Line Items -> Pricing ->
Pricing Context the LOV works without an error

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

1. Via Oracle Pricing Manager responsibility
2. Navigation = Price Lists -> Price List Setup
Search for Name = Test_Price_List
Go to Pricing Attributes
Pricing Context = XX_INS
Pricing Attribute = 1-REGION
Operator is '='
Try to open the Value From Lov in the Value From field

Get the error message


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.