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

Last updated on SEPTEMBER 29, 2016

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

Symptoms

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.

ERROR
 
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


STEPS
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

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