Danish Desktop :Unable To Load BEE Spreadsheet Data "Incorrect Format For Money Un (Doc ID 1939563.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.1.3 in both test and production, in the Danish responsibility :


When attempting to load data using the BEE Spreadsheet Interface with computers in Denmark. Process Failing with the following Error

-- Error
"Incorrect format for Money unit of measure."


The same Data is loading when using a Laptop in US and UK.
The data is also Loading with the Data is Just typed into the spreadsheet.

 -- Steps
The issue can be reproduced at will with the following steps.
1. Using either DK Responsibility with the following settings :

  Profile option name = ICX:Territory Site = United States Responsibility = Denmark
  Profile option name = ICX: Numeric Characters Site = 10,000.00

And having run "Generate Upgrade Mechanism" for this Legislation

Steps tried :

1 - Spreadsheet received from user
2 - Columns (assignment number and amount) copy and pasted (to remove any formatting issues) to a new spreadsheet
3 - From the US desktop this was uploaded to BEE successfully.
4 - Remotely connected to your DK user
5 - Copy and pasted the same values to a new spreadsheet in the same way and got error
  "Incorrect format for Money unit of measure."
6 - Typing in freehand the exact same value works without an issue.
7 - Entering a number with nothing after the decimal point works also (eg. 10,000 works, if it were 10,000.22 it would fail).
8 - The Values that are being pasted into the BEE Spreadsheet were formatted in various ways before being pasted, i.e. General, Date, Text and it still does not work.

The only difference is that when the amount is entered freehand a small green indication is given on the left of the cell and it is left justified within the column.

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot use the upload from spreadsheet functionality to upload data.

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