Different Data Type Constraints Between Database and Form for 'Receipt No.' Field

(Doc ID 2107943.1)

Last updated on APRIL 05, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.


The 'Receipt No.' field on RMS form (RMS Start > Inventory > Appointments) is declared as NUMBER(9), but the column in the database allows VARCHAR2(17).  If character values are entered in the Receipt No. field, an 'Unable to perform query' error appears.

Steps to Recreate:

1. Open an appointment with 'receipt no.' containing character values.
2. 'Unable to perform query' error occurs.

The requirement is that the receipt number be longer as compared to the WMS field, and that it can accept character values, as well.


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