Data Loading -> Review Status: Information About Worksheet Name Is Not Populated In Dedicated Column

(Doc ID 2418041.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms


Information about Worksheet name is not populated in dedicated column from Data Loading -> Review Status
When loading data via Data Loading and file have errors, information about worksheet (data loading -> review status -> view issues -> column "worksheet") are empty for some cases.

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

  1. Log to RMS
  2. Download HTS Setup Template
  3. A. Go to Foundation Data -> Data Loading -> Download
  4. Template Type = Import
  5.  Template = HTS Setup
  6.  Click download button
  7.  Add entry on "Country_Tariff_Treatments" sheet for example: "Create PL AGA_ELA 31-DEC-18 01-JAN-18"
    • Notice that to get our error "effective from date" column have to contain date greater than "effective to date" column
  8.  Save file
  9. Upload file (Example ods file in attachment - with added record mentioned at step 3)
  1. B. Go to Foundation Data -> Data Loading -> Upload
    • Template Type = Import
    • Template = HTS Setup
    • attach file
    • click upload button
  2. Navigate to review status
  3. Click view issues button
  4. We have entry in data issues without worksheet name (screenshot in attachment)



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