Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Traci Kawaguchi
    Process Electronic Bank Statement Import Error
    Topic posted January 16, 2019 by Traci KawaguchiGreen Ribbon: 100+ Points, last edited February 6, 2019, tagged Cash Management, Public Sector 
    939 Views, 14 Comments
    Title:
    Process Electronic Bank Statement Import Error
    Summary:
    Process Electronic Bank Statement import error when using scheduled process
    Content:

    When I import a BAI2 bank statement using the Process Electronic Bank Statement process, the file successfully imports and reconciles if i submit the process, but if it processes through a schedule process, i get an import error that the bank account cannot be found.

    Does any one know why it works one way, but not the other and how i can fix it?

    Thanks!

     

    Image:
    Document:

    Comment

     

    • Felix Beaudoin

      Hey Traci!
      This seems quite strange. Are you saying that the file is pushed to your server and then whenever you import from the CM area it works but when you try from the ESS process it does not?
      Is it a manual bank statement upload (.zip) being pushed to the interface and then processed?
      Let me know, thanks!
      Regards,
      Felix

      • Traci Kawaguchi

        Hi Felix,

        I apologize for the poor description. We just went live in October and I'm still not quite up on the proper terminology.

        We always import from Tools>Scheduled Processes>Process Electronic Bank Statement.

        If I submit the process to run right away, it will succeed

        But if I schedule the process to run in the future, it will error.

        The file does get imported from the bank, because it shows in the Cash Management>Bank Statements and Reconciliation>Processing Warnings and Errors and if i click the retry arrow, then it works. For some reason it's just the initial import of the file that doesn't work.

        Our implementation consultant remembered yesterday that he needed to change the file name in the transmission configuration, and after he ran the process and it worked. But again this morning, using the same parameters, the scheduled job errored out.

        Please let me know if you need any more clarity or any screenshots or logs.

        Thanks!

        • Felix Beaudoin

          That is interesting indeed Traci! For starters, you need to make sure that your Transmission Configuration reflects exactly the file name pushed by the bank into the server. You also need to make sure that the bank always pushes a constant name because if it changes, it will always fail.
          What I find strange is that your process doesn't work day after day for imports but if you then refresh manually it does? Seems like a system glitch because what i've experience so far with bank statements is SUCCESS or FAIL. No in-between or one way works and the other doesn't.

          Make sure to raise an SR with Oracle around this.
          Regards,
          Felix

          • Jon Kelly

            Starting with R13, static file names is no longer a requirement for bank file imports, and wild card processing works. We opened an SR last year related to this issue because our bank statements stopped importing for all accounts but one. Oracle's solution was that we needed to set up wild card processing. The wild card prevents files with identical names from being imported again, and it turns out our single account that was working only processed because it hit an error due to starting balance which allowed the identical name to be processed again. Once we switched to wild card processing, issue was resolved, although we have to clear out the folder regularly because too many files can still cause it to error. A script was written to clear the files out after a week automatically. You can find the wild card information in Doc ID 2395131.1.

            Jon

            • Logan Wacker

              If a client is connecting directly from Oracle Cloud to the client (SFTP over proxy), then the files piling up in the remote server usually isn't an issue. Most banks (not all), run the scripts on their end to remove files from the directory once they see a file was retrieved successfully.

              Dynamic file name was one of the best features added last year.

    • Amol

      As Felix said, this is quite strange.

      Can you please ensure the two files which you have processed - one success and other which failed have same bank account details ?

      Also ensure the bank account for USD currency provided in your screenshot does exist in the system ? If it does not, then whichever way you try to process BAI2 error will remain same "Bank Account for currency not found" .

    • Logan Wacker

      Can you share an example of the exact file name of a file you're attempting to load, and then also share the file name defined on the Manage Transmission Configuration task used to load this file automatically. We've seen this issue before, and it usually amounts to a bad configuration value.

      Thanks.

      Logan

    • Steve Lepine

      Hello All, 

      We are exploring the bank statement reconciliation process and looking for some documentation that gives a summary of the pre-requisite and configuration required. 

      We plan on implementing BAI2 with the Kyriba Hub statement forwarding functionality.

      Thanks in advance.

      Steve

    • Pablo Schenquerman

      Steve;

      Here is some information from Metalink:

      NOTE:1370856.1 How To Load and Import a Bank Statement

      NOTE:1605698.1 How to Load a Bank Statement File into Fusion Cash Management for a Cloud Customer

      NOTE:1334465.1 How to Set Up Banks,Branches and Accounts

      NOTE:1372887.1 What Seeded Formats Are Available For Bank Statements

      NOTE:1392456.1 Troubleshooting Within Fusion Cash Management

      NOTE:1392514.1 Oracle Fusion Cash Management FAQ

      How to Get Started Setting up Cash Management (Doc ID 1982984.1)

    • Logan Wacker

      Processing BAI is pretty straight forward once you've defined BAI codes, and the bank account models (especially since you're using Kyriba's hub to manage file traffic). For bank recon you need to define your rules, rule sets, tolerances, and then deal with first presentment items. There are a couple white papers that have come out over the last few years, let me find the links.

      Thanks.

      Logan

    • Traci Kawaguchi

      Hi Everyone,

      I was able to get my problem resolved in a really duh moment.

      I believe that the issue was the master user account I was using for the Scheduled Process was not on the list of approved users for the bank account. Once i added it, the process worked. I never considered this could be a problem because I assumed it would have given an error earlier in the process or not even allowed me to select a Payment System. 

      Thanks for all your help!

      • Felix Beaudoin

        Hey Traci!

        Glad to hear that solved your issue. So you're saying that in the bank account controls, you added the user and then it worked? I've never had to do this before so am wondering, does that user have the Cash Manager or Cash Specialist role assigned to it?

        Let me know, thanks!

        Regards,
        Felix

        • Traci Kawaguchi

          Hi Felix,

          It has neither.

          • Felix Beaudoin

            I see! So it is really just a user that is scheduling processes and not working directly in CM? If so, then it makes sense to add them directly to the bank account. For us, our CM users handle the scheduled processes which is why we did not need to add them to the bank account setups.