My Oracle Support Banner

Get 'Missing Sheet In The Input File.' Errors When Uploading Files Saved Using Microsoft Excel App (Doc ID 2434986.1)

Last updated on AUGUST 17, 2018

Applies to:

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

Symptoms

Many sheet names in files downloaded using RMS Download Data screen (Tasks > Foundation Data > Data Loading > Download) contains '.' character for other languages than English.

This character is replaced by Excel application with '_', when file is being saved (however, it can be noticed only after reopening a file).

When this file is being uploaded to RMS using Upload Data screen (Tasks > Foundation Data > Data Loading > Upload), the following error may be found at Foundation Data Issues screen (Notifications > See All > [Description] > View Issues): 'Missing sheet in the input file.' and data upload is not successful.

Error:


Steps to reproduce:
The issue can be reproduced at will with the following steps for Polish language:
1. Log in to RMS application.
2. Set language to Polish (issue should be reproduced at other language than English).
3. Download a file with sheet name containing '.' (Zadania > Dane podstawowe > Ładowanie danych > Pobieranie > Typ szablonu: 'Zabezpieczenie' > Szablon: 'Zabezpieczenia - użytkownicy').
4. Open a file using Microsoft Excel, Save and Close.
5. Reopen the same file and note that '.' (period) character in sheet names has been replaced with '_' (underscore) character.
6. Try to upload saved file (Zadania > Dane podstawowe > Ładowanie danych > Przesyłanie > Typ szablonu: 'Zabezpieczenie' > Szablon: 'Zabezpieczenia - użytkownicy' > Choose File > Przesyłanie).
7. Check notifications (Powiadomienia > Zlecenie przesyłania dany... > Wyświetlanie problemów).
8. Note that 'Brak arkusza w pliku wejściowym.' error has appeared for each listed sheet containing '.' character - in our case there is one such sheet 'Zabezpieczenia_-_role_użytk.'


Changes

 

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!


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