Multiple Approval Of Notifications Randomly Errors With Java.sql.SQLException: Invalid Column Index

(Doc ID 2408434.1)

Last updated on JUNE 07, 2018

Applies to:

Oracle Workflow - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Workflow Mailer

Multiple Approval of Notifications randomly errors with

java.sql.SQLException: Invalid column Index


As a workaround will be to go back to the list of notifications and start selecting again to approve / reject.

ERROR
-----------------------

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NtfAttribsEO.NAME, MsgAttribsEO.TYPE, MsgAttribsEO.FORMAT, MsgAttribsEO.DISPLAY_NAME, NtfAttribsEO.TEXT_VALUE, NtfAttribsEO.NOTIFICATION_ID, MsgAttribsEO.MESSAGE_TYPE, MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1, NtfAttribsEO.NOTIFICATION_ID AS NOTIFICATION_ID1, NtfEO.NOTIFICATION_ID AS NOTIFICATION_ID2 FROM WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO, WF_NOTIFICATIONS NtfEO, WF_MESSAGE_ATTRIBUTES_VL MsgAttribsEO WHERE (NtfAttribsEO.NOTIFICATION_ID = NtfEO.NOTIFICATION_ID)AND ((NtfEO.MESSAGE_TYPE = MsgAttribsEO.MESSAGE_TYPE)AND (NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME)) AND (NtfAttribsEO.NOTIFICATION_ID = 4139401 and MsgAttribsEO.NAME = NtfAttribsEO.NAME and MsgAttribsEO.TYPE IN ('DOCUMENT', 'URL') and NtfAttribsEO.TEXT_VALUE IS NOT NULL and MsgAttribsEO.SUBTYPE = 'SEND' and MsgAttribsEO.NAME='#ATTACHMENTS')
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:6363)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:10692)


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