My Oracle Support Banner

Numeric Or Value Error Is Raised When Templates Are Loaded (Doc ID 2442743.1)

Last updated on SEPTEMBER 10, 2018

Applies to:

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

Symptoms

When Creating Cost Changes through file induction, an error appears on Cost Change Origin Column.
This column has fields set up already in the template by default, when it is downloaded.

COST CHANGE ORIGIN field is being inserted as is in the new template meaning "By Item" or "By Supplier" but in the SQL table it only accepts SKU or SUP.
 
Error:


Steps to reproduce:
The issue can be reproduced at will with the following steps:

  1. Login to RMS
  2. Navigate to Costs > Upload from file
  3. Select the file to upload then the destination (RMS Tables) and click on "Upload".
  4. File has been processed with Errors: Error appears on Cost Change Origin Column "Numeric or value error. Please check field length and data type"

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.