JBO-27122 Error In iProcurement Homepage After Cloning (Doc ID 332518.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle iProcurement - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After cloning, the target Instance shows an error when accessing the iProcurement Homepage - other
applications appear to be working as expected :

ERROR :

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: select wf_notification.Getsubject(notification_id) as subject,
notification_id from( select * from ( select wn.notification_id from
WF_NOTIFICATIONS WN where WN.more_info_ROLE in ((select :1 from dual) union all
(select role_name from wf_user_roles where user_name = :2 and user_orig_system
= :3 and user_orig_system_id = :4 )) and wn.status = :5 and exists( select 1
from WF_NOTIFICATION_ATTRIBUTES NA, WF_MESSAGE_ATTRIBUTES_VL MA where
NA.NOTIFICATION_ID = WN.NOTIFICATION_ID and MA.MESSAGE_NAME = WN.MESSAGE_NAME
and MA.MESSAGE_TYPE = WN.MESSAGE_TYPE and MA.NAME = NA.NAME and MA.SUBTYPE = :6
and MA.TYPE <> :7) and sysdate - wn.begin_date <=60 union all select
wn.notification_id from WF_NOTIFICATIONS WN where WN.recipient_ROLE in ((select
:8 from dual) union all (select role_name from wf_user_roles where user_name =
:9 and user_orig_system = :10 and user_orig_system_id = :11 )) and wn.status =
:12 and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL MA where NA.NOTIFICATION_ID = WN.NOTIFICATION_ID and
MA.MESSAGE_NAME = WN.MESSAGE_NAME and MA.MESSAGE_TYPE = WN.MESSAGE_TYPE and
MA.NAME = NA.NAME and MA.SUBTYPE = :13 and MA.TYPE <> :14) and sysdate -
wn.begin_date <=60 and more_info_role is null ) order by notification_id desc)
where rownum<=:15

 

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