My Oracle Support Banner

Data Loading -> Review Status: Information About Worksheet Name Is Not Populated In Dedicated Column (Doc ID 2418041.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


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)


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

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