Home » Applications » Oracle Fusion Apps & E-Business Suite » Trying to create a site using hr_sit_api.create_sit (HRMS 11.5.10 Red hat linux )
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.
Previous Topic: Need FAQ or Interview question for Oracle Apps Financial
Next Topic: Proceeds of Sale Gain, Net Book Value Retired Gain, Cost of Removal Gain
Goto Forum:
  


Current Time: Wed Oct 01 07:45:36 CDT 2014

Total time taken to generate the page: 0.10083 seconds