'JBO-2:7122 SQL error' When Opening The Notification From Workflow Administrator Monitor Status Page (Doc ID 1959639.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Workflow - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.1.3,
when attempting to open the notification in workflow administration web application new responsibility
the error page is displayed:

Error Page 
Exception Details. 
oracle.apps.fnd.framework.OAException: 
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement 
preparation.  Statement: SELECT NtfAttribsEO.TEXT_VALUE,        
NtfAttribsEO.NOTIFICATION_ID,         NtfAttribsEO.NAME,        
MsgAttribsEO.TYPE,   MsgAttribsEO.MESSAGE_TYPE,        
MsgAttribsEO.MESSAGE_NAME,         MsgAttribsEO.NAME AS NAME1,        
MsgAttribsEO.DISPLAY_NAME,         MsgAttribsEO.FORMAT,        
NtfAttribsEO.NUMBER_VALUE,         NtfAttribsEO.DATE_VALUE,        
MsgAttribsEO.SUBTYPE,        MsgAttribsEO.RENDER,        
MsgAttribsEO.SEQUENCE FROM WF_NOTIFICATIONS NtfEO, 
WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO, WF_MESSAGE_ATTRIBUTES_VL 
MsgAttribsEO WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID =
NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE = 
MsgAttribsEO.MESSAGE_TYPE AND NtfEO.MESSAGE_NAME = 
MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME = NtfAttribsEO.NAME 
ORDER BY length(MsgAttribsEO.NAME) desc
       at 
oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

       at 
oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)

       at 
oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)

...

...

## Detail 0 ##
java.sql.SQLSyntaxErrorException: "MSGATTRIBSEO"."RENDER": 
invalid identifier

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

 
 
The following steps used to reproduce this:
1. Log into Applications using the Workflow Administration Web Application New responsibility.
2. Navigate: Workflow > Administrator Workflow > Status Monitor.
3. Type Internal Name.
4. Click Go to search.
5. Select one item key, click 'Activity History' and move to the next page.
6. Click the notification with 'Open' link on a activity to access the notification.
7. The error page displayed.
8. Click the link 'here' on Error page and get the message details.

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