HR_7155_OBJECT_INVALID When Using hr_contingent_worker_api.terminate_placement (Doc ID 780467.1)

Last updated on AUGUST 22, 2022

Applies to:

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to terminate a contingent worker using api

1 declare
2 v_effective_date date := sysdate-1 ;
3 v_person_id number := 9717;
4 v_date_start date := '26-JUN-2006';
5 v_object_version_number number := 2 ;
6 v_termination_reason varchar2 (100) := 'NR' ;
7 v_actual_termination_date date := sysdate-1 ;
8 v_final_process_date date := sysdate-1 ;
9 v_last_standard_process_date date := sysdate-1 ;
10 ---out parameters
11 v_supervisor_warning boolean ;
12 v_event_warning boolean ;
13 v_interview_warning boolean ;
14 v_review_warning boolean ;
15 v_recruiter_warning boolean ;
16 v_asg_future_changes_warning boolean ;
17 v_entries_changed_warning varchar2(500) ;
18 v_pay_proposal_warning boolean ;
19 v_dod_warning boolean ;
20 v_org_now_no_manager_warning boolean ;
21 v_addl_rights_warning boolean ;
22 begin
23 hr_contingent_worker_api.terminate_placement
24 (p_effective_date => v_effective_date ,
25 p_person_id => v_person_id ,
26 p_date_start => v_date_start ,
27 p_object_version_number => v_object_version_number ,
28 p_termination_reason => v_termination_reason ,
29 p_actual_termination_date => v_actual_termination_date ,
30 p_final_process_date => v_final_process_date ,
31 p_last_standard_process_date => v_last_standard_process_date ,
32 -- out parameters
33 p_supervisor_warning => v_supervisor_warning ,
34 p_event_warning => v_event_warning ,
35 p_interview_warning => v_interview_warning ,
36 p_review_warning => v_review_warning ,
37 p_recruiter_warning => v_recruiter_warning ,
38 p_asg_future_changes_warning => v_asg_future_changes_warning ,
39 p_entries_changed_warning => v_entries_changed_warning ,
40 p_pay_proposal_warning => v_pay_proposal_warning ,
41 p_dod_warning => v_dod_warning ,
42 p_org_now_no_manager_warning => v_org_now_no_manager_warning ,
43 p_addl_rights_warning => v_addl_rights_warning
44 );
45* end;



the following error occurs:

ERROR
declare
*
ERROR at line 1:
ORA-20001: HR_7155_OBJECT_INVALID:
ORA-06512: at "APPS.HR_CONTINGENT_WORKER_API", line 3219
ORA-06512: at line 23

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Call the api hr_contingent_worker_api.terminate_placement to terminate a contingent worker.
2. Get error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.