Data Type Size Of Field 'VPN' In ReIM Table Less Than In RMS Table

(Doc ID 2316886.1)

Last updated on OCTOBER 19, 2017

Applies to:

Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Data type size of field 'VPN' in ReIM table less than in RMS table.

When creating a Merchandise Invoice and click on Default From Receipts in the Details screen the below errors pops up on the screen:

Steps To Recreate:

   1. Create PO with Items, the Item is having VPN field size more than 25 chars.
   2. Ship & Receive against the PO.
   3. Create a Merchandise Invoice.
   4. On Item tab click 'Default from Receipts' - Application error occurs. 

       Noticed that in log error is: value too large for column "RMS16DEV"."IM_INJECT_DOC_DETAIL"."VPN" (actual: 26, maximum: 25)@2REIM_DOCUMENT_SQL.DEFAULT_DETL_FROM_RCPT).

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