Validation for Host2Host payment based on supplier country
We need to pay suppliers across the globe through Host to Host. Suppliers Bank details will not have mandatory fields and therefore payment fails from bank. How do you setup country wise validation before payment so that supplier Master is updated properly in oracle.
Few examples
HSBC payment to India requires IFSC code and Swift Code
Payment to America requires ABA/Routing and Swift
Also there is validation to Swift code character limit as 8,9,11 to certain countries.
In short we need to build a validation matrix in oracle. How this can be achieved.