Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BIP layout using space as a number grouping separator — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP layout using space as a number grouping separator

Accepted answer
26
Views
1
Comments
edited Feb 11, 2015 6:29PM in General Transactional Reporting (OTBI) 1 comment

Summary

We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not Total Comp).

Content

We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not Total Comp). This is using a space as the grouping separator and no decimal points.

I know that the grouping separator is supposed to use locale at run-time. So I've tried the format of <?format-number:BASE_SALARY_NEW;'999G999G999'?>. However, when we upload this in the Comp Plan, the locale appears to default to English and we end up seeing commas as the separators. I've also tried changing the locale AND default locale in BI Publisher on the template from the report (/shared/Human Capital Management/Compensation/Workforce Compensation/Compensation Workbench Print Statements). It seems that the grouping separator for Hungary's locale should be a space (

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!