My Oracle Support Banner

EAP 9.2: PS_COUNTRY_TBL And PS_STATE_TBL Record Data Needs To Be Updated With Latest Country And State Data Compliant With ISO 3166 Alpha Code Standards (Doc ID 2372662.1)

Last updated on JULY 07, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



The system data delivered by PeopleSoft Enterprise FSCM 9.2 Application Release for the Country Table (PS_COUNTRY_TBL), and the States Record (PS_STATE_TBL), is outdated when comparing it against the International Standards Organization naming convention: ISO 3166 Alpha 3 Code.


     1.- Log into the FSCM Online Application as User ID VP1
     2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Location > Country
     3.- Check the list of 240 rows against that of ISO 3166 Alpha 3 Code standards, and confirm the differences
     4.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Location > State
     3.- Check the list of 1404 rows against that of ISO 3166 Alpha 2 Code standards for States/Provinces, and confirm the differences

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.


Customers have to perform the changes into the Country and State set up pages, and this is manually intensive.


When FSCM 9.2 Version was released in March 2013, the delivered Country and State data was compliant with ISO 3166 Alpha 3 Code standards at the time, but after almost 5 years, several changes have taken place, and should be addressed.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.