oracle.apps.fnd.oam.bobj.activity.DatabaseSessionException: ORA-01427: .. subquery return more than
I am using EBS 11.5.10.2 with a 9.2.0.8 oracle database . We canceled a concurrent program in EBS and from that time, if I look at the database sessions with Toad, I have two sessions blocked but does not see any blocking session. The two sessions blocked have the same audsid. I tried to killed the sessions with Toad but it's not working. I try to kill the sessions by going to the Site Map manager - Database session and get the following message :
oracle.apps.fnd.oam.bobj.activity.DatabaseSessionException: ORA-01427: .. subquery return more than one row
I am new in managing database and don't know what to do with it.