My Oracle Support Banner

HTS_SETUP_DATA Upload Fails with S9T_MISSING_SHEET Error When Wksht_name Exceeds 31 Characters (Doc ID 2295535.1)

Last updated on JULY 23, 2020

Applies to:

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


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.


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


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.