ReSA 12.x: Mismatch Between the Field Lengths from RMS DB and Transaction Maintenance Form (satrdetl.fmb)

(Doc ID 2154764.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Retail Sales Audit - Version 12.0.5 and later
Information in this document applies to any platform.


The field length of the columns VENDOR_INVC_NO and PROOF_OF_DELIVERY_NO in the table SA_TRAN_HEAD is set as 30.  In the corresponding form (satrdetl.fmb), under the "Paid out" tab, the lengths of vendor invoice number and proof of delivery number is set to 16.

Hence, values exceeding 16 characters are not displayed and a 'PL/SQL numeric value' error is displayed.

Steps to Reproduce:

  1. Log in to Oracle Retail Merchandising System (ORMS)
  2. Navigate to Sales Audit > Additional Operations > Transaction Maintenance > Edit/View.
  3. Open a transaction containing values for vendor invoice number (SA_TRAN_HEAD. VENDOR_INVC_NO) and proof of delivery (SA_TRAN_HEAD.PROOF_OF_DELIVERY_NO), and exceeding the text limit of 16 characters.



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