Find Payments By Remit To Account Is Not Showing The Payments, LOV Fails With Error FRM-40502: ORACLE error: Unable to read list of values.
(Doc ID 2288180.1)
Last updated on JULY 30, 2019
Applies to:Oracle Payables - Version 12.1.0 and later
Information in this document applies to any platform.
Finding payments by Remit-To-Account in the Payments Workbench fails with the following error:
FRM-40502: ORACLE error: Unable to read list of values.
When the Remit-To-Account list of values (LOV) is executed, the error raises.
The LOV query SELECT executed in the production environment, via SQL*Plus, returns 5+ millions rows.
The following SELECT returns 5+ millions rows
Even if the a supplier number is entered in the find window trying to restrict the search for only one supplier, the Remit-To-Account LOV fails with the above error.
In the test environment and in Oracle Support Internal instances, which contains a smaller set of data, the LOV works.
Steps To Reproduce:
- Log into the application using Payablers responsibility.
- Navigate to the Payments Workbench: (N) Payments > Entry
- Click on the "Find" icon to Find Payments
- In the Find window click on the LOV "Remit To Account" (to find a payment by the account).
- The error occurs.
Applied patch for bug 24434617 - BUG IN APXPAWKB, IN RECORD GROUP IBY-PAYEE_BANKACCOUNT_QF
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
IMPORTANT: If the modification described above resolves the issue, please link the customer SR to Bug 26485049