My Oracle Support Banner

Data Type Size Of Field 'VPN' In ReIM Table Less Than In RMS Table (Doc ID 2316886.1)

Last updated on MAY 22, 2018

Applies to:

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


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).




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.