AWS Transfer family Route 53 record

Hi, I'm trying to automatically create a R53 record for my Org's transfer family resource using the transfer family tag resource using a custom hostname and specifying a zone ID as documented here: https://docs.aws.amazon.com/transfer/latest/userguide/requirements-dns.html and https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/transfer_tag

While the custom hostname does get generated, a record for the transfer family is not generated

Looking for insights/solutions

Thanks