My Oracle Support Banner

Imaging AXF Account Distribution Form Displays Error "Unable to execute account segment lookup query java.sql.SQLException: Invalid column index" (Doc ID 1593224.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Oracle WebCenter Content: Imaging - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

The Account Distribution page coding form has an error stating "Failed to get account list". The E-Business Suite data source is setup correctly, but the error continues to occur.  

The Imaging diagnostic log file shows the following error: 

Unable to execute account segment lookup query java.sql.SQLException: Invalid column index.

 A related stack trace shows that the error is coming from a lookup of the Account segments.

oracle.imaging.axf.resources.AxfException: java.sql.SQLException: Invalid column index
at oracle.imaging.axf.servicemodules.apps.ebs11.service.InvoiceLookupServiceBean.lookupGLAccountSegmentList(InvoiceLookupServiceBean.java:315)

Cause

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
Symptoms
Cause
Solution

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