Data Type Size Of Field 'VPN' In ReIM Table Less Than In RMS Table
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.
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).
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