Norway Postal Code Upload Data With Incorrect Character (Doc ID 1961003.1)

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Norway HR

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
Expect it to be the same as it is in the loading file :
1361,ØSTERÅS,0219,BÆRUM,G


STEPS
-----------------------
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....

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

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