Receiving Error 'ORA-12899: Value Too Large for Column' When Creating Vendor Funded Clearance for a Partner With a Long Name

(Doc ID 1915824.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Price Management - Version 13.2.4 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

The data length for SUP_NAME and PARTNER_NAME is varchar2(240) in the Retail Merchandising System (RMS) database, but it is only varchar2(50) in the related Retail Price Management (RPM) table RPM_PC_REC_GTT for column 'PARTNER_NAME'.

This results in the following error while creating a Vendor Funded clearance in RPM for a partner with a name that is more than 50 characters long:


Steps to Reproduce

  1. Create a Vendor Funded Markdown (VFM) deal in RMS for a partner that has a name with more than 50 characters.
  2. Create a VFM clearance in RPM for this same partner and note the error encountered.

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