Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Brian Burns
    Positive Pay File Automatically Transmit to Bank SFTP Site -...
    Topic posted April 25, 2019 by Brian BurnsBlack Diamond: 60,000+ Points, tagged Accounting Hub Cloud Service, Cash Management, Configuration, Setup / Administration, Tip 
    226 Views, 9 Comments
    Title:
    Positive Pay File Automatically Transmit to Bank SFTP Site - Issues with Port
    Summary:
    I am trying to set up the positive pay file so that it will automatically drop to our banks SFTP Site but had issues with the Port and Connection
    Content:

    I am trying to set up the positive pay file so that it will automatically drop to our banks SFTP Site but had issues with the Port and Connection.

    1. I have been able to test out sending the Positive Pay File to an internal FTP site and that works successfully.

    2. when I change the directory to the Bank SFTP site the connection does not work.

    3. In an SR I had with Oracle, the tech said I can only use Port 22 as the "FTP Server Port Number". The Bank said they don't support 22 but requires 9422.

    4. I'm not sure I trust Oracle 100% in the SR b/c there must be a way to send this to a Banks SFTP site as I'm sure other customers have been able to complete this set-up.

    Has anyone had issues with this and been able to get it to work?

     

    Thank you,

    Brian Burns

    Comment

     

    • Sudheer Rakasi

      Hello Brian,

       you should be able to connect to a non standard port of your bank ( in your case 9422)
      this has to be explicitly mentioned in your port on the manage transmission configuration.

      what is the error in the log file , if its saying connection time out , it might be because of a whitelisting to be done
      on the bank server based on data center where your enviroment is loacated.

      Reference for whitelisting :IP Whitelist for Web Service Calls Initiated by Oracle Cloud Applications (Doc ID 1903739.1)

      Thanks,
      Sudheer

      • Brian Burns

        Hi Sudheer,

         

        The error is that I get a "The Test attempt failed" when I'm testing the connection in the Edit Transmission Configuration Page.

        To your point, so if I put 9422 in the Port number then that should work? I've testing using that port number and then using it blank and then with Port 22.

        Thank you for the Whitelisting guide. I'm double checking with the bank to verify. Initially they told me they had no IP restrictions but I'll see what they say now. So far nothing has worked when pushing it to their server (Test connection always fails) but I know it works b/c when I change the location to our internal FTP site it works.

        Thanks,

        Brian

        • Sudheer Rakasi

          Hello Brian,

          Please use the port 9422 in your manage transmission configuration. and instead of using TEST button on the manage transmission configuration. Please Test it by running the PPR , by attaching the Manage transmission configuration , to actually see if the file gets transmitted. in this way you will also have logs to check if the transmission fails.

          thanks,

          Sudheer

          • Brian Burns

            Hi Sudheer,

            I used 9422 and set it up to fall into a Test folder in the Banks SFTP site. The transmission showed Succeeded but no file ever dropped into the folder. I'm still taking a look to see what happened.

    • Wendy Ware

      Hi Brian, in my limited experience, in prior versions, the TEST button for transmission configuration always says test attempt failed.  Perhaps others with more recent or more extensive experience can confirm or disprove this.  Wendy

    • Logan Wacker

      There is a logged bug with Oracle regarding the test buttons errors when using for SFTP transmission. Non standard ports are used with many bank rights now, support required us to complete a risk form and then they opened the port for us. You can send via SFTP, we've made it work many times.

      • Brian Burns

        Hi Logan,

        Do you have a copy of the risk form? Oracle Support told us they can't do anything regarding opening up another port other than 22. We escalated that SR ticket.

        Thank you,

        Brian

        • Leaman Crews

          Hi Brian,

          If I am reading this right, port 9422 is on the bank's end. Therefore nothing needs to be opened up on your end. Whatever port Oracle has the ssh client running on is fine for sending the file to an SFTP server running on port 9422.

          Regards,

          Leaman

        • Glen Ryen

          Hi Brian,

          The risk form used to be necessary for non-standard ports, but no longer is (due to the SFTP through proxy feature that came out in 13B).  I've got connectivity for payment and BAI2 files to/from multiple banks on ports besides 22.

          And echoing what Becky and Logan said, there are known issues with the 'Transmission Configuration' test button.  Better to run a PPR and try to send a file.  Confirm receipt with the bank if you haven't already, as some banks will pick the file up and process it right away.  So WinSCP might not see the file after you drop it.  It sounds from your other post that you're past basic connectivity/whitelisting, but let me know if that's not the case.

          Hope that helps,

          Glen