Is the supplier automatically registered in Oracle Fusion once they complete registration with the bank for Supply Chain Finance?

No. Enabling supplier participation in Oracle Fusion is a manual activity completed only after you receive the email notification from the bank confirming that the supplier has completed registration.