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.
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.
Table of Contents
SQL Query to find Installed Legislations and the extensions used:
SELECT * FROM PAY_INSTALLED_LEGISLATIONSSQL 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, POSITIONSample output will look like:
