server ip: 192.168.141.96 : 21     credentials:  user: tss password: T@l30P@ss     path: /home/ttt/

Host: sftp://sftpabc.learn.com
User name: abc
Password: jQrE7wvg
Port: 22
import dir: upload/source

DECLARE
  l_conn  UTL_TCP.connection;
begin
  l_conn := ftp.login('192.168.141.96', '21', 'tss', 'T@l30P@ss');
  ftp.ascii(p_conn => l_conn);
  FTP.GET(P_CONN      => L_CONN,
          P_FROM_FILE => 'filename_test.csv',
          p_to_dir    => 'DIR_INBOUND',
          p_to_file   => 'test_get.txt');
  ftp.logout(l_conn);
END;