Error In Update Assignment API

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
Post Reply
dammur
Posts: 3
Joined: Wed Jul 11, 2007 12:18 am
Location: India

Error In Update Assignment API

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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests