Database Administration (MOSC)

MOSC Banner

oracle.apps.fnd.oam.bobj.activity.DatabaseSessionException: ORA-01427: .. subquery return more than

edited Apr 5, 2010 2:21AM in Database Administration (MOSC) 4 commentsAnswered
 Hello

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center