My Oracle Support Banner

BEE Spreedshet Upload Fails with "Incorrect format for Money unit of Measure" Error When Uploading Decimal Values (Doc ID 2699518.1)

Last updated on AUGUST 10, 2020

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

When attempting to upload the batch lines with decimal values, the following error occurs.

Incorrect format for Money unit of Measure error

 PUI(Element Entry values and Batch Lines) work as expected.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Set the profiles below.
     ICX_TERRITORY: POLAND (User level)
     ICX_NUMERIC_CHARACTERS: 10 000,00 (User level)
  2.  Go to Self Service BEE
  3.  Select the batch and click Process button
  4.  Select the element and click Go button
  5.  Enter the decimal value with comma (,) in the spreadsheet and upload
     e.g.  Pay Value = 100,20
  6.  Batch line fails

 

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!


In this Document
Symptoms
Cause
Solution
References


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