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 19, 2017

Applies to:

Oracle Payables - Version 12.1.0 and later
Information in this document applies to any platform.

Symptoms

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:

  1. Log into the application using Payablers responsibility.
  2. Navigate to the Payments Workbench:  (N) Payments > Entry
  3. Click on the "Find" icon to Find Payments
  4. In the Find window click on the LOV "Remit To Account" (to find a payment by the account).
  5. The error occurs.

Changes

Applied patch for bug 24434617 - BUG IN APXPAWKB, IN RECORD GROUP IBY-PAYEE_BANKACCOUNT_QF

Cause

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