Home › Discussions › Questions & Answers › AP Invoice Upload Error

AP Invoice Upload Error

Avatar photoCustomer Questions & Answers 1 reply

Hello, I wanted to pass along an error that we received when using the API Invoice Upload report for the first time in our Production environment.  The request log files are included with this message along with the Excel file that was actually uploaded.

The request log states the following:

Error at line 840:

aia.amount_applicable_to_discount,

ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at “SYS.DBMS_SQL”, line 1721

We are actually not trying to load anything into that amount_applicable_to_discount field, so I’m not sure where the issue lies.  I tried loading the same exact set of data into our Test environment via the same upload report, and it completed successfully without any issues.

The strange thing is the invoices did actually load into our Production environment–even though the report completed in error.  I will say we are on a slightly more recent version of Blitz in our Test environment.

Please let me know if you need any additional information in order to help diagnose the issue.

Thanks,

1 reply

  • Support Enginatics

    Hi,

    I compared the sql with our latest code version and there were significant changes meanwhile.
    I would assume that this was a bug in the older version that you have currently in prod, and we should have it resolved meanwhile.

    Would it be possible to upgrade and retest?

    And the invoices were created successfully btw., as the loading concurrent program (program name: Blitz Upload) completed successfully, and the problem happened only in the blitz report that shows the result of the load at the end.

    Regards,
    Andy

  • You must be logged in to reply to this post.