Multiple Approval Of Notifications Randomly Errors With Java.sql.SQLException: Invalid Column Index
Last updated on JUNE 07, 2018
Applies to:Oracle Workflow - Version 12.2.6 and later
Information in this document applies to any platform.
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.
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')
## Detail 0 ##
java.sql.SQLException: Invalid column index
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