| Trying to create a site using hr_sit_api.create_sit [message #503948] |
Wed, 20 April 2011 10:28 |
davholla
Messages: 116
Registered: August 2009
Location: London
|
Senior Member |
|
|
Using this code
DECLARE
l_person_analysis_id PER_PERSON_ANALYSES.PERSON_ANALYSIS_ID%TYPE;
l_person_id PER_PERSON_ANALYSES.PERSON_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;
l_bus_group_id PER_PERSON_ANALYSES.BUSINESS_GROUP_ID%TYPE;
l_flex_num fnd_id_flex_structures_tl.id_flex_num%TYPE;
BEGIN
l_person_id := 405;
l_analysis_criteria_id := null; -- if value assigned no values will not be applied
select person_analysis_id, object_version_number
into l_person_analysis_id, l_pea_object_version_number
from(
select inn.*, rownum
from (
select person_analysis_id,object_version_number, last_update_date
from PER_PERSON_ANALYSES
--per_person_analyses
--per_special_info_types
where person_id = '405'
order by last_update_date desc) inn
group by person_analysis_id, object_version_number, last_update_date, rownum
having rownum=1);
l_person_analysis_id:=820285;--758291;--821285;
l_pea_object_version_number:=2;--6;--1;
l_bus_group_id :='';
l_flex_num:=50324;
hr_sit_api.create_sit(p_person_id => l_person_id
,p_business_group_id => l_bus_group_id
,p_id_flex_num => l_flex_num
,p_effective_date => SYSDATE
,p_date_from => SYSDATE
,p_date_to => NULL
,p_segment5 => '1',
p_segment6 => '1',
p_analysis_criteria_id =>l_analysis_criteria_id,
p_person_analysis_id => l_person_analysis_id
,p_pea_object_version_number => l_pea_object_version_number
);
END;
I get ORA-20001: The business group specified is invalid
I have tried values of 0, null and 101 (the only values we have). Any ideas how to fix this?
Thank you in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
