R12.1: JBO-27022: Failed To Load Value Error When Trying To Search Payments in Payments Manager

(Doc ID 2011022.1)

Last updated on OCTOBER 19, 2015

Applies to:

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

Symptoms

Receive the following error when trying to load/query a Payment Process Request, or search for payment / payment batch in Payments Manager:

oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException:
JBO-27022: Failed to load value at index xx with java object of type java.lang.String due to java.sql.SQLException

The issue can be reproduced at will with the following steps:
1. Payables Manager Responsibility
2. Home (ab select any of the request from Need Action
3. Payments tab
4. Fill search with anything
5. Click on Go button to search

Changes

Application of any of the following patch:
  16234039:R12.AP.B: NOT ABLE TO TERMINATE PPR
  19155343 - R12.1: E-BUSINESS TAX RECOMMENDED PATCH COLLECTION (ZX RPC), AUG 2014
  18999775 - R12.1: PAYMENTS RECOMMENDED PATCH COLLECTION (IBY) , AUG 2014
  19034020 - R12.1.X: Subledger Accounting (SLA) Recommended Patch Collection - August 2014

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