HTS_SETUP_DATA Upload Fails with S9T_MISSING_SHEET for Wksht_name Values That Exceed 31 Characters (Doc ID 2295535.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Retail Trade Management - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

When worksheet names for a template (HTS_SETUP_DATA) length exceeds 31 characters, Microsoft Excel truncates the worksheet names to 31. As a result the upload process fails. The error is seen on S9T_ERRORS table.

Error
-----------------------
S9T_MISSING_SHEET

What is Working
-----------------------
Using Libre OpenOffice does not recreate the issue

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Download HTS Setup Data
1a. Template Type: Import
1b. Template: HTS Setup
2. Using Excel, open and populate downloaded spreadsheet accordingly.
3. Upload HTS Setup spreadsheet

Upload process will show error "Missing sheet in the input file" for "OTHER_GOVERNMENT_AGENCIES_TRANS" worksheet


Changes

 

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