Payables & Cash Management

Get Involved. Join the Conversation.


    Amber Lomeli
    ADFDI AP Spreadsheet Load over 100 lines
    Topic posted February 26, 2019 by Amber LomeliBronze Medal: 1,250+ Points, tagged Payables 
    193 Views, 10 Comments
    ADFDI AP Spreadsheet Load over 100 lines
    AP Invoice Spreadsheet not loading over 100 lines

    This functionality used to work. I am having issues now with loading over 100 lines in the ADFDI Spreadsheet load for AP invoices.




    • Alan Rowland

      What's the error message?

      I don't remember if my users had to download a new version of ADFDI after 18C; they did after the R13 upgrade.

      I ask my users to try the ADFDI Health Check Tool (How to use ADF Desktop Integration Client Health Check Tool(Doc ID 2010222.1)) whenever they have a problem with ADFDI.  The next step is to re-install it.



      • Amber Lomeli

        The weird thing is there is no error message. It downloads and says rows successful. But when you look at the invoice when it is imported the lines are missing. Only 100 are imported and the other 230 lines are missing. I have reinstalled the ADFDI version as well for 18C.

    • Alan Rowland

      I recall something like that happening with our AP users.  I'll take a look through our internal ticketing system to see what I can find.

    • Suresh Kumarasamy

      You have to insert the row within 100 rows, spreadsheet will not work if you insert the rows from 101 and above.

      please try insert more rows from 1 to 100.

      You can also try the FBDI template which will support huge volume of records.

      • Amber Lomeli

        Hi Suresh, I have completed this before it looks like it is still having that issue with over 100 lines. We are currently using the FBDI for the workaround.

    • Giovanni Chamtyoo

      Hi Amber, have you verified the Import Payables Invoices Report ?