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
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
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
| Symptoms |
| Cause |
| Solution |
| References |