account entry not in aft-request-metadata DynamoDB table and no AWSAFTExecution role is created. Any Idea ?

While, Import existing AWS Control Tower accounts to Account Factory for Terraform, i am following these steps:

1. Created aft account request terraform file and pushed the code.
2. Expectation is to see the entry in Code Pipeline of AFT Management account
3. However since the entry was not there, started debugging and realised that in dynamo db, entry is there in aft-request and aft-request-audit table but not in aft-request-metadata table.
4. Also AWSAFTExecution IAM role was not created for the account.

Anyone has any idea on this ??