Pricing Attribute Of Price List, Grade Is Not Working Properly ORA-00933: SQL Command Not Properly (Doc ID 2189421.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
In Pricing attribute of Price List, sometimes Grade is not working properly.
The LOV does not return a value when operator is "=" and errors with

ERROR
----------------
ORA-00933: SQL command not properly ended


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate to: Pricing > price List > price list setup
3. Query a price list
4. Enter new price list line for an item number
5. Click on Pricing Attribute (button)
6. Select pricing attribute = QC_GRADE, operator: "= " ( equal sign )
7. Bring up the List of Values (LOV) for "value from" and see
    Decision: No search criteria has been entered for the lookup.
                  This search might take a long time. Do you want to continue?
    When click on message (OK), errors with
         ORA-00933: SQL command not properly ended

8. Update operator to "BETWEEN"
9. No LOV shown, but can manually enter value from and value to values.
10. Now one can change operator back to "="
11. Value from value remains intact and now can save record.
12. When saving shows: FRM-40400: Transaction Complete: 2 records applied and saved.


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