If you see the following error in your population script log:
"Error: ORA-12899: value too large for column "FW"."DM_HSC_DEMOGRAPHICS"."POSTCODE" (actual: 9, maximum: 8)"
It happens because the POSTCODE column only stores up to 8 characters. You can run the query below to find any records where the postcode is longer than 8 characters.
For Oracle
SELECT person_id, post_code
FROM dm_addresses
WHERE LENGTH(post_code) > 8;
For SQL
SELECT person_id, post_code
FROM dm_addresses
WHERE LEN(post_code) > 8;
The size of the DM_HSC_DEMOGRAPHICS.POSTCODE column will be increased in the upcoming 25.3 Reports Repository release.
