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!