I am using standard "iRecruitment Employee" responsibility and applying for a job in iRecruitment. I am then getting the below error.
---
ORA-01427: single-row subquery returns more than one row in Package irc_party_swi Procedure registered_user_application

----

Any idea? anybody faced this before?

Well I've had a look at the R11.5 equivalent and I can't see anything in there that might directly cause that message. Sorry I can't be of further help on this, apart from suggesting a quick Metalink search for that procedure name?

Hopefully someone with access to an R12.1 instance will be able to help further.

There is a note on metalink that says this comes when custom security profile is used, but I do not have any security profile so that cannot be a problem..

support is "again" of not much help..

dont know if there are any profiles missing or anything?