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

Last updated on APRIL 25, 2017

Applies to:

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

Symptoms

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

ERROR

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(ViewObjectImpl.java:8268)
at oracle.apps.contracts.termsAuthoring.authoring.publicModel.view.ContractTermsTemplateVOImpl.executeQuery(ContractTermsTemplateVOImpl.java:30)
...
Caused by: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:2854)

 

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.

 

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