• Post category:Core HR
  • Post comments:0 Comments
  • Post last modified:June 28, 2022
  • Reading time:3 mins read
You are currently viewing How to fetch the Address formats and Installed Legislations?
How do you fetch the Address formats and Installed Legislations?
- How to fetch the Address formats and Installed Legislations?
Total Visits: 14

In this article, we will look into the extracting the address formats for all legislations.

Manage Address Formats is the task where we configure the address formats for all legislations.

image 14 1024x550 - How to fetch the Address formats and Installed Legislations?

Once the address formats are setup, use the Features by Country or Territory to specify the address format to be used for the specific legislation.

image 16 1024x433 - How to fetch the Address formats and Installed Legislations?

SQL Query to find Installed Legislations and the extensions used:

SELECT * FROM PAY_INSTALLED_LEGISLATIONS

SQL Query to extract Address Formats:

SELECT FND.TERRITORY_SHORT_NAME,B.STYLE_FORMAT_CODE, L.TERRITORY_CODE, 
B.ATTRIBUTE_CODE, LINE_NUMBER, POSITION, MANDATORY_FLAG REQUIRED, UPPERCASE_FLAG UPPERCASE
FROM FUSION.HZ_STYLE_FMT_LAYOUTS_B B ,FUSION.HZ_STYLE_FMT_LOCALES L ,FND_TERRITORIES_TL FND
WHERE (B.STYLE_FORMAT_CODE LIKE 'POSTAL_ADDR%' OR B.STYLE_FORMAT_CODE LIKE 'SUPP%')
AND B.STYLE_FORMAT_CODE=L.STYLE_FORMAT_CODE
AND FND.TERRITORY_CODE = L.TERRITORY_CODE
AND FND.LANGUAGE='US'
--AND FND.TERRITORY_SHORT_NAME = 'United States'
ORDER BY FND.TERRITORY_SHORT_NAME,STYLE_FORMAT_CODE, LINE_NUMBER, POSITION

Sample output will look like:

image 15 1024x463 - How to fetch the Address formats and Installed Legislations?
If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.