Using API For inbound:
****************Points To Note*********************
Hr_assignment_api
In Parameters: p_assignment_id,p_effective_date
Required Parameters:
P_Validate: Boolean-> If remains true then data base value will not be changed,If false then assignment is updated.Default value is false.
P_Effective_Date->in Param
P_DateTrack_Update_mode->Correction or Update,In Param
P_Object_Version_Number->In,Out,Copy Param.Remains 1 for new assignment,gets increamented by one to each update.
P_Assignment_Status_type_id->in
P_Change_Reason->Explicitly set to null if no change needed.
************************************************
To change the status of a employee.the status should be active before modifying.
Change the status to suspend and run this script.
Now again status will be changed to active.
Pkg used is hr_assignment_api.activate_emp_asg
Base tables : per_assignments_f
declare
l_object_version_number number:=7;
l_effective_start_date date;
l_effective_end_date date;
begin
hr_assignment_api.activate_emp_asg
(p_validate =>false
,p_effective_date =>'1-JAN-2009'
,p_datetrack_update_mode =>'CORRECTION'
,p_assignment_id =>12854
,p_change_reason =>hr_api.g_varchar2
,p_object_version_number =>l_object_version_number
,p_assignment_status_type_id =>hr_api.g_number
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
);
dbms_output.put_line('Object Version Number ' l_object_version_number);
commit;
end;
/
To activate for contract employees
Create a contract employee first.
declare
l_object_version_number number:=5;
l_effective_start_date date;
l_effective_end_date date;
begin
hr_assignment_api.activate_cwk_asg
(p_validate =>false
,p_effective_date =>'1-JAN-2009'
,p_datetrack_update_mode =>'CORRECTION'
,p_assignment_id =>12894
,p_change_reason =>hr_api.g_varchar2
,p_object_version_number =>l_object_version_number
,p_assignment_status_type_id =>hr_api.g_number
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
);
dbms_output.put_line('Object Version Number ' l_object_version_number);
commit;
end;
/
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load
# Fix of the Day #25: Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load Part of my Oracl...
-
Absence Management in Oracle Fusion is powerful — and easy to get wrong. The accrual plan is where most of the complexity lives. Here is a...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
-
HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-pa...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.