Unexpected Error While Exporting Quote Information In R12.1.3 (Doc ID 1294176.1)

Last updated on JUNE 07, 2017

Applies to:

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

Symptoms

When attempting to Export Quote information from the quotes page,
the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Excerpt from the Exception Details shows:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
.

FROM
ASO_QUOTE_HEADERS AQHA
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)

.

## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From HTML Quoting - Quotes
2. Click on the Export button (to the right of the create quote button).

Changes

 

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