BI SFTP connection no longer working due to Key Exchange Algorithm Deprecation

Summary:

One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target server.

Error message: Could not establish connection. oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server

As per Oracle docs, https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/ssh-options-sftp.html

The following algorithms are available only when Publisher is running on a JVM on which the Java Cryptography Extension (JCE) unlimited strength jurisdiction policy files are installed:

• diffie-hellman-group-exchange-sha256
• diffie-hellman-group14-sha256
• diffie-hellman-group16-sha512
• diffie-hellman-group18-sha512
• rsa-sha2-256
• rsa-sha2-512
• aes192-ctr
• aes256-ctr