Home » Applications » Oracle Fusion Apps & E-Business Suite » Problems with HR_SIT_API.UPDATE_SIT (11.5.10 Oracle HR)
Problems with HR_SIT_API.UPDATE_SIT [message #503053] Tue, 12 April 2011 10:44 Go to next message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
DECLARE
l_person_analysis_id PER_PERSON_ANALYSES.PERSON_ANALYSIS_ID%TYPE;
l_analysis_criteria_id PER_PERSON_ANALYSES.ANALYSIS_CRITERIA_ID%TYPE;
l_pea_object_version_number PER_PERSON_ANALYSES.OBJECT_VERSION_NUMBER%TYPE;
BEGIN
l_person_analysis_id := 405;
l_analysis_criteria_id := null; -- if value assigned no values will not be applied
select  max(fa.object_version_number)
into l_pea_object_version_number
from per_all_assignments_f fa, per_people_f pf
where fa.person_id=l_person_analysis_id 
and fa.person_id = pf.person_id;
hr_sit_api.update_sit(
p_person_analysis_id => l_person_analysis_id,
p_segment5 => '1',
p_segment6 => '1',
p_analysis_criteria_id => l_analysis_criteria_id,
p_pea_object_version_number => l_pea_object_version_number
);
END;


When I run this I get this error
Cause:        The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR Schema.  

Action:        Retry the action with the correct object version number.
ORA-06512: at "APPS.HR_SIT_API", line 1190
ORA-06512: at line 13

Any ideas?
I have tried with changing the version number but it does not work what ever I do.
Re: Problems with HR_SIT_API.UPDATE_SIT [message #506441 is a reply to message #503053] Mon, 09 May 2011 05:28 Go to previous messageGo to next message
chandrakanthtec
Messages: 1
Registered: May 2011
Location: Mumbai
Junior Member
Why are you fetching object version number of per_all_assignemnts_f. When you are updating SIT you need to fetch obj ver no of per_person_analyses. And what is this -"where fa.person_id=l_person_analysis_id". Person_id and person_analysis_id are different things.
Re: Problems with HR_SIT_API.UPDATE_SIT [message #506446 is a reply to message #503053] Mon, 09 May 2011 05:50 Go to previous message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
Thanks I will try that.
Previous Topic: Deleteing Data from TCA tables
Next Topic: OID and OC4J process time out
Goto Forum:
  


Current Time: Sun Sep 19 02:01:57 CDT 2021