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 MAY 02, 2017

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

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