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 MARCH 12, 2018

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.


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