hr_assignment_api update_emp_asg to update supervisor

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.

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 Applications Knowledge Repository

Friday, november 22, 2013, api to update assignment supervisor, 2 comments:.

Very nice..

Doyen System Pvt. Ltd.

Tuesday 27 September 2016

Oracle hrms- person, assignment , job , location conversion using api, no comments:, post a comment.

Oracle Apps Technical

Tuesday, february 16, 2016, hr_assignment_api.update_emp_asg in hrms, no comments:.

Post a Comment

• Install App

E-Business Suite

For appeals, questions and feedback about Oracle Forums, please email [email protected] . Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to disable validations in hr_assignment_api.update_emp_asg_criteria?

We are using Oracle API -  hr_assignment_api.update_emp_asg_criteria to update location/organization.

We receive errors for certain person such as  “ ERROR**Update of EMPLOYEE ASSIGN UPDATE = DateTrack Mode ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, 1054980, N, SEGMENT, HR_GENERALIST, N, VALUESET, HBI_HR_GENERALIST “  after we moved HR/Payroll to other system.

Since we only need to update location/organization for suppliers and does not care about full HR/Payroll,  my question is if  hr_assignment_api.update_emp_asg_criteria can be disabled for the validations in below codes?

Thank you in advance for any inputs.

hr_assignment_api.update_emp_asg_criteria

              (p_validate                         => g_validate

              ,p_effective_date                   => TRUNC(sysdate)

              ,p_datetrack_update_mode            => l_datetrack_mode

               ,p_assignment_id                     => l_assgn_id

              ,p_called_from_mass_update          => FALSE

              ,p_location_id                      => l_wd_assgn_loc_id  --- update needs

              ,p_organization_id                  => l_wd_assgn_org_id --- update needs

              ,p_payroll_id                       => null

              --- IN/OUT ---

              ,p_object_version_number            => l_obj_vers_assg

              ,p_special_ceiling_step_id          => l_special_ceiling_step_id

               ,p_people_group_id                   => l_people_group_id

              ,p_soft_coding_keyflex_id           => l_soft_coding_keyflex_id

              --- OUT ---

              ,p_group_name                       => l_group_name

              ,p_effective_start_date              => l_assg_eff_start_dt

              ,p_effective_end_date               => l_assg_eff_end_dt

              ,p_org_now_no_manager_warning       => l_org_now_no_mgr_warn

              ,p_other_manager_warning            => l_other_mgr_warn

              ,p_spp_delete_warning               => l_spp_delete_warn

              ,p_entries_changed_warning          => l_entries_changed_warn

              ,p_tax_district_changed_warning     => l_tax_dis_cha_warn

              ,p_concatenated_segments            => l_concat_segments

              ,p_gsp_post_process_warning         => l_gsp_post_proc_warn );