Pakistan Localization: Location and Person address, Postal Code Validation For Pakistan is not working as expected

(Doc ID 2410722.1)

Last updated on JUNE 13, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
When enter Postal Code for Pakistan location no validation is applied after entering/ navigating from Postal Code field.
The actual validation is happening only after Review or Submit transaction.

EXPECTED BEHAVIOR
-----------------------
Expected behavior is to have Postal Code for Pakistan validated after entering/ navigating from Postal Code field.
The same way as Postal Code validation is happening for Netherlands, Russian Federation, Ukraine, etc.

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

When entering Contact details , under Main Address, choose Pakistan on Country field. Postal Code can be entered without validation.

Details:
1. under Navigator > Workforce Structures > Manage Locations;
2. Create new;
3. In the Contact Details section, under Main Address, user is selecting Pakistan on Country field and it is adding intentionally an incorrect postal code;
4. If the user it's switching to a different field, no validation error for the improper Postal Code is thrown.

The validation is happening only when user is clicking on either Review or Submit:
'Error - The postal code is not valid. Enter a five-digit number (HRX-1561373)'

If user is following steps 1-3 for other country (examples: Ukraine, Netherlands, Russian Federation), then the validation error pops-up immediately after switching the field:
'Error - The postal code is not valid. Enter a postal code with five numbers. (HRX-1561117)'

Observation:
Checked in Navigator->Manage Geographies (which is on CRM) and could see that the "Hierarchy Defined" section was grayed-out for Pakistan, but for Ukraine, Netherlands to;
Double checked by running in BI two queries on the CRM table - HZ_GEOGRAPHIES - for PK (Pakistan) and UA (Ukraine):

SELECT GEOGRAPHY_TYPE, COUNT (GEOGRAPHY_TYPE)
FROM hz_geographies
where COUNTRY_CODE = 'PK'
group by GEOGRAPHY_TYPE
ORDER BY COUNT(GEOGRAPHY_TYPE)

For both the output was that there is no CRM geography loaded.

From CRM side geography can be loaded in two different ways:
1. via 3rd party Nokia Data - list of available countries here -> http://docs.oracle.com/cloud/farel12/salescs_gs/FASMC/FASMC1432334.htm#FASMC1418861
2. in this user case a self developed *.csv file is used (which contains hierarchical geography data) and it is importing the same via Manage File Import Activities.

Either the case, the data from CRM side goes in HZ_GEOGRAPHIES table, which is not populated in this case for Pakistan or Ukraine/Netherlands/Russian Federation.
As the issue is happening for Pakistan (but not for Ukraine/Netherlands/Russian Federation), the data in the HCM Manage Locations screen is not coming from CRM side (at least in this scenario).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot validate in real-time Pakistan Postal Codes.

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