Norway Postal Code Upload Data With Incorrect Character

(Doc ID 1961003.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle HRMS (Norway) - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Norway HR

Find that when we uploaded Norway postal code using the standard upload process as explained in Norway Supplement PDF.

Navigate to Norway HRMS Manager->Application Utilities lookup->Query NO_POSTAL_CODE
Value uploaded character is showing different from the loading file.
1361,ØSTERÅS,0219,BÆRUM,G is showing as 1361 ,�TER�,0219,B�UM,G

Expect it to be the same as it is in the loading file :

The issue can be reproduced at will with the following steps:
1. Upload post code for NO using the standard upload process
2. Review codes in Norway HRMS Manager->Application Utilities lookup->Query NO_POSTAL_CODE
3. The post code is showing a different value.
Code : 1352
Meaning : 1352.KOLS=,0219.B....

The issue has the following business impact:
Due to this issue, users cannot correctly upload post codes. This is impacting UAT and Go-Live


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