Oracle Apps Solutions
Thursday, august 28, 2014, update employee assignment/criteria - hrms apis, 14 comments:.
Please, I have ran series of API for assignments criteria for newly created employees, but not working what could be the problem?
Hi, I hope you are passing all the mandatory parameters, what error you are getting?
I entered all the mandatory fields for this API: hr_assignment_api.update_emp_asg_criteria only, or do i need to also run hr_assignment_api.update_emp_asg. The assignment_id, is it the person type are they referring to here or ASSIGNMENT_ID in the assignment table The procedure will completed successfully and committed but when i checked it in the front end,it has not effect. Please, Help.
If you are updating only criteria, no need to call update_emp_asg. assignment_id is the assignment_id. Is it an employee or contingent worker? are you committing it after the API call? provide me your anonymous API calling block here.
The API is more than what I can paste here, this page is complaining of 4,096 characters. if you can send me your mail
When, try to debug the script, it gives me this error: Error report - ORA-20001: The primary key specified is invalid Cause: The primary key values specified are invalid and do not exist in the schema. Action: Check the primary key values before attempting to carry out the operation again. ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 16095 ORA-06512: at line 30
Why trying to make further research i got this error: Error report - ORA-20001: The primary key specified is invalid Cause: The primary key values specified are invalid and do not exist in the schema. Action: Check the primary key values before attempting to carry out the operation again. ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 16095 ORA-06512: at line 30
You will get an email option on clicking on my profile name. In between please double check the datatype of all the parameters.
I have sent you a mail. Thank you.
Ademola - Not sure, if the issue is resolved for you. If this is not yet resolved and you're facing this issue in the database, please follow the below steps. To implement the solution, please execute the following steps: 1. Set NLS_LANG to 'US' or ‘AMERICAN’ in TOAD/SQL Developer: a. For SQL Developer: 1. Select Tools > Preferences > Database > NLS Parameters 2. Update to have Language = AMERICAN and Territory = AMERICA b. For TOAD: 1. Access NLS Parameters, from the Database menu 2. Select Administer| -> NLS Parameters 3. Set the NLS_LANGUAGE to ‘AMERICAN’ 2. Retest the issue. 3. Migrate the solution as appropriate to other environments.
Hi The issue is with the out parameter l_asg_object_version_number not being passed correctly. Its is a bug on this API. Select the object_version_number from assignment table for the assignment ID and pass it to the API. Kamlesh
Thanks for your blog!!. Keep updating JAVA Development Services HR Pay Roll Software SAP Software Services Hotel Billing Software Web Design Company Hospital Management Software
Hi, I'm getting error while calling hr_assignment_api.update_emp_asg_criteria API. Error: -ORA-20001: FLEX-DUPLICATE CCID: N, CCID Thanks, Ankush.
Hi Ankush1818, Were you able to solve the Error: -ORA-20001: FLEX-DUPLICATE CCID: N, CCID ?
Oracle Apps Technical
Thursday, 13 march 2014, oracle hrms api – update employee assignment & supervisor adding, 3 comments:.
Very much Helpful! Thanks :)
Thank you so much, very useful :-)
what if we have multiple assignment then how should we tell the api that we need supervisor on active one. becasue the active assignment flag of both assignments are Y.
Doyen System Pvt. Ltd.
Tuesday, 27 September 2016
Oracle hrms- person, assignment , job , location conversion using api, no comments:, post a comment.
PL/SQL (MOSC)
Discussions
HR_ASSIGNMENT_API
i'm trying to update an employee ASSIGNMENT using
HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA(
HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (
p_validate => FALSE
,p_effective_date => TO_DATE(v_start_date, 'dd-MON-RRRR')
,p_datetrack_update_mode =>'CORRECTION'
p_assignment_id =>new_ln_assignment_id --13243
,p_job_id =>v_JOB_ID --170
,p_location_id =>V_location_id -- 73986
,p_organization_id =>v_ORGANZATION_ID --635
,p_employment_category =>v_assignement_code -- LB02
,p_people_group_id =>v_JOBGROUP_ID --143
but i got this error:
"PLS-00306: wrong number or types of arguments in call to
'UPDATE_EMP_ASG_CRITERIA'
Howdy, Stranger!
To view full details, sign in to My Oracle Support Community.
Don't have a My Oracle Support Community account? Click here to get started.
Instructions for posting
1. Select a discussion category from the picklist.
2. Enter a title that clearly identifies the subject of your question.
3. In the body, insert detailed information, including Oracle product and version.
Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).
Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .
New to My Oracle Support Community? Visit our Welcome Center
IMAGES
VIDEO
COMMENTS
Oracle Human Resources - Version 11.5.10.2 and later: How to Create a Hardcoded API to Update an Employee Assignment Using the API hr_assignment_api.update_emp_asg_c.
/* This API updates attributes of the employee assignment that affect the * entitlement criteria for any element entry. * The assignment must be an employee assignment. The assignment must exist as * of the effective date of the change */ hr_assignment_api.update_emp_asg_criteria ( p_effective_date => trunc(sysdate)
This document gives guidance, with the help of examples, on how to use various HRMS API's with hardcoded examples. For details of API usage please refer to Note 72310.1: Understanding and Using APIs in Oracle HRMS. This code is to be run in SQLplus as the APPS user.
SELECT paf.assignment_id INTO l_assg_id FROM per_assignments_f paf WHERE paf.assignment_number = i.emp_num AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date; EXCEPTION WHEN OTHERS THEN -- l_assg_id := NULL; l_error_msg := 'Assignment not found'; l_error := 1; END;
Run API HR_ASSIGNMENT_API.create_secondary_emp_asg on the parameter "p_pgp_concat_segments" with additional values (Such as 'TEST.one.') ex: ----- declare. l_date date := to_date ('16-MAR-2018','DD-MON-YYYY'); l_assignment_number varchar2 (30); l_group_name varchar2 (100); l_concatenated_segments varchar2 (100); l_cagr_grade_def_id number;
For information on how to call APIs, see the technical essay APIs in Oracle HRMS. This topic lists APIs supported for HR Foundation. HR Foundation users can only use restricted parameters in some APIs. See: APIs to Which Restrictions Apply for HR Foundation.
This blog is used to Creating new Person, Assignment, Job creation, Location creation, and Rehiring Person. This blog includes the updating of Person, Job, and assignment with email notification option the corresponding API will create and update the information Person and Job.
Hi Team, I was able to create a Secondary Employee Assignment using the API "hr_assignment_api.create_secondary_emp_asg" and he/she was assigned an Assignment Number of "22222-2". My next Step would be to make "22222-2" the primary assignment instead of "22222".
i'm trying to update an employee ASSIGNMENT using. HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (. HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (. p_validate => FALSE. ,p_effective_date => TO_DATE (v_start_date, 'dd-MON-RRRR') ,p_datetrack_update_mode =>'CORRECTION'. p_assignment_id =>new_ln_assignment_id --13243. ,p_job_id =>v_JOB_ID --170.
APIs With User Hooks. In Release 11, Oracle HRMS has supplemented the core product API functionality by the addition of API user hooks. These are locations in the HRMS APIs where additional customer specific logic can be executed.