My Oracle Support Banner

Discount Reason Codes Show 'SQL Error' Upon Adding a New Code (Doc ID 2098027.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Retail Point-of-Service - Version 14.0.2 and later
Information in this document applies to any platform.


In Oracle Retail Point of Service (ORPOS) 14.0.2, while adding a reason code from the POS UI for Item / Transaction Amount and percentage (any discount reason code), the application shows 'Structured Query Language' (SQL) error on the screen.

Steps to Reproduce:

  1. Go to F4 Admin -> Security -> Reason Codes
  2. Go to "Transaction Discount by Percentage" reason code
  3. Add a new reason code
  4. Hit 'Done'
  5. The following error appears:

Database Communication Notice
The following error occurred when accessing the database: A Structured Query Language error occurred during database access. Please inform your supervisor, then press Enter to continue.



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.