Luis, Thanks for the info. But that info is not sufficient . I am not able to get the root cause of the problem from this table. Can u pls help me with some more info.. How to troble shoot this problem & find out the root cause & come out of it. Thanks a ton for ur help in advance. Young. On Fri, Nov 28, 2008 at 11:02 AM, Luis Freitas <lfreitas34@xxxxxxxxx> wrote: > Young, > > You may be able to identify why there are two roles by investigating the > values on columns ORIG_SYSTEM and ORIG_SYSTEM_ID on table WF_ROLES, for both > roles. > > Regards, > Luis > > --- On *Fri, 11/28/08, dba.young young <dba.young@xxxxxxxxx>* wrote: > > From: dba.young young <dba.young@xxxxxxxxx> > Subject: Portal supplier user not able to see open notifications > To: ora-apps-dba@xxxxxxxxxxxxx > Date: Friday, November 28, 2008, 1:46 PM > > > HI ALL, > > > Portal supplier user cannot see open notifications prior to 23 NOV. Only > notifications after 23 nov are visible, > > Also when I checked the recipient_role, until 21-Nov the recipient_role > is ADHOC2454598569311319186PO. > ON 23 Nov the recipient_role changes to ADHOCR2454794166241466141PO. > > SO there is a change in the recipient_role also. > > Can someone advice what could be the problem behind the same. > > > > Some valuable advice from anyone would be helpful. > > > > Thanks, > Young. > > >