My Oracle Support Banner

ISupplier Multiple Invoices Link From View Payments Fails Because SQL Is Missing "And" (Doc ID 1950326.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to view a multiple Invoice number from a View Payments screen, the following error occurs.

An Unexpected error has occurred. Please try again later and if the problem persists, please contact the system administrator.

The issue can be reproduced at will with the following steps:
1. Open iSupplier Portal as a Supplier
2. Click on Finance Tab
3. Click on View Payments
4. Query a payment with multiple invoices
5. Click multiple invoices link
6. Get Error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.