My Oracle Support Banner

Invalid Column Index Error When Adding Contract Terms Template to a Negotiation Template (Doc ID 2160031.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Fusion Sourcing Cloud Service - Version and later
Oracle Fusion Sourcing - Version and later
Information in this document applies to any platform.


Invalid Column Index error when adding Contract Terms Template to a Negotiation Template


Invalid Column index

Stack trace shows the following:

Caused by: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value
at index 10 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.jbo.server.ViewObjectImpl.executeQuery(
at oracle.apps.contracts.termsAuthoring.authoring.publicModel.view.ContractTermsTemplateVOImpl.executeQuery(
Caused by: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getString(


Steps to reproduce:

1. Login to application as Buyer.
2. Go to Negotiations.
3. From the Task bar choose Manage Negotiation Templates.
4. In Manage Negotiation Templates click on Create Negotiation Template.
5. Fill out (in order) - Cover Page, Overview, Requirements, Lines.
6. On Contract Terms, do a search in the Contract Terms Template. When the Search and Select window pops up, do a blind search.
Get the error

Expect to see the available templates, but instead get the error.





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

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