Hi all, we refer to the following discussion to resolve this issue by using a Before Provisioning Rule and it is working. We have the identity attribute to determine the correct sequence and thus we added the sequencing config in the BP rule.
Thanks all for the assistance.