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.
Last updated on JULY 19, 2017
Applies to:Oracle Payables - Version 12.1.0 and later
Information in this document applies to any platform.
Finding payments in the Payments Workbench fails with the following error:
FRM-40502: ORACLE error: Unable to read list of values.
When the LOV query SELECT is executed in the production environment, via SQL*Plus, it 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms