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
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
Million Knowledge Articles and hundreds of Community platforms