Oracle Human Resource (Core HR), Payroll, Time & Labor, Self Service HR, Advance Benefit, Talent Management (Performance Management, Competency Management, Performance Appraisal, Goal Management), iRecruitment, Compensation Workbench
-
dammur
- Posts: 3
- Joined: Wed Jul 11, 2007 12:18 am
- Location: India
Post
by dammur »
I am using the assignment API to update the position and other information for an employee but it is giving me the error as
"ORA-01427: single-row subquery returns more than one row".
any help is greatle appreciated.its very urgent
Thanks.
-
rahuldwivedi
- Posts: 2
- Joined: Mon Dec 05, 2011 3:10 am
- Location: India
Post
by rahuldwivedi »
Dear,
Are you using any kind of sub query in your code. If yes then check that, as it may be returning multiple rows for which it is failing.
-
eng_ahmad_2007
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
-
Contact:
Post
by eng_ahmad_2007 »
As Rahul said,
Your Subquery is returning too many rows... check it and make it return a single row
Users browsing this forum: No registered users and 7 guests