My Oracle Support Banner

Province Codes For Newfoundland And Nunavut (Doc ID 2528158.1)

Last updated on APRIL 08, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

ACTUAL BEHAVIOR

Province codes for Newfoundland and Nunavut

Multiple province codes exist in the Campus Solutions (CS) application (9.2 PUM 5) for Newfoundland (NF and NL) and Nunavut (NN and NU) in the PS_STATE_TBL where COUNTRY = 'CAN'. The province codes of NF and NN do not exist in HCM. When an address is updated in CS where the province is NF or NN, and the address change does not include a change to the province code, this causes an Integration Broker error in HCM since neither is a valid value.

What is the recommended approach for managing this scenario? Why are the two applications not synchronized when it comes to the PS_STATE_TBL since this is a core installation table?

We also notice that both NF and NN are value in the PS_STATE_TBL in the FIN application.

 

EXPECTED BEHAVIOR

EXPECT Multiple province codes exist in the Campus Solutions (CS) application (9.2 PUM 5) for Newfoundland (NF and NL) and Nunavut (NN and NU) in the PS_STATE_TBL where COUNTRY = 'CAN'.

STEPS

The issue can be reproduced at will with the following steps:
1.connect to HCM 9.2.29 database using SQL


SQL>
  1 select state, country from ps_state_tbl
  2 where country = 'CAN'
  3* ORDER BY STATE
SQL> /

STATE COU
------ ---
AB CAN
BC CAN
MB CAN
NB CAN
NL CAN
NS CAN
NT CAN
NU CAN
ON CAN
PE CAN
QC CAN
SK CAN
YT CAN
ZZ CAN

14 rows selected.


BUSINESS IMPACT


The province codes of NF and NN do not exist in HCM. When an address is updated in CS where the province is NF or NN, and the address change does not include a change to the province code, this causes an Integration Broker error in HCM since neither is a valid value.

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.