My Oracle Support Banner

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

Last updated on MARCH 29, 2019

Applies to:

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


On : 12.2.5 version, Pricing, Discounting & Charges

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

ORA-00933: SQL command not properly ended

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.




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.