hr_assignment_api.update_emp_asg_criteria

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Confirm Password *

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Username or email *

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Sorry, you do not have permission to ask a question, You must login to ask a question.

Sorry, you do not have permission to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oracle HRMS API to update people group in oracle

Introduction:

The  People Group flexfields lets you add your own key information to the

Employee Assignment. You use each segment to define the different groups of employees which exist within your own enterprise.

update people group using “hr_assignment_api.update_emp_asg_criteria” API

Forms Or Pages:

API IN/OUT Parameters :

— IN p_effective_date IN DATE Required — IN p_datetrack_update_mode IN VARCHAR2 Required — IN p_assignment_id IN NUMBER Required — IN p_validate IN BOOLEAN Required — IN p_called_from_mass_update IN BOOLEAN Required — IN p_organization_id IN NUMBER Required — IN Out p_people_group_id NUMBER — IN Out p_object_version_number NUMBER — IN Out p_special_ceiling_step_id NUMBER — Out p_group_name VARCHAR2 — Out p_effective_start_date DATE — Out p_effective_end_date DATE — Out p_org_now_no_manager_warning BOOLEAN — Out p_other_manager_warning BOOLEAN — Out p_spp_delete_warning BOOLEAN — Out p_entries_changed_warning VARCHAR2 — Out p_tax_district_changed_warning BOOLEAN — Out p_concatenated_segments BOOLEAN

API Parameters clarifications:

• @param p_effective_date Can be either the current date or a date in the future.
• @param p_datetrack_update_mode control parameter enables you to define the type of DateTrack change to be made.
• @param p_assignment_id System-generated primary key column Primary Key for “PER_ASSIGNMENTS_F”.
• @param p_validate control parameter (the default value is FALSE) to executes all validation for that business function.
• @param p_called_from_mass_update Set to TRUE if the API is called from the Mass Update Processes.
• @param p_organization_id Foreign Key for“HR_ALL_ORGANIZATION_UNITS”.
• @param p_people_group_id Foreign Key for “PAY_PEOPLE_GROUPS”.
• @param p_object_version_number Object Version Number (OVN) is a column in a database table. It is used to track multiple changes to a record. When a new row is inserted, the OVN is set to 1.
• @param p_special_ceiling_step_id API sets this attribute to null on the database and the latest value is passed out of the API. If you do not want to alter this attribute, set the calling logic variable to hr_api.g_number.???
• @param p_group_name Identifies the name of an existing group in the workspace.
• @param p_effective_start_date and @param p_effective_end_date are all maintained by DateTrack. The START_DATE is the date when the first record for this person was created. The earliest EFFECTIVE_START_DATE for a person is equal to the START_DATE, so that If p_validate is false, then set to the effective end date for the created assignment. If p_validate is true, then set to null.
• @param p_org_now_no_manager_warning Set to true if this assignment is a manager, the organization is updated and there is now no manager in the previous organization. Set to false if another manager exists in the previous organization.
• @param p_other_manager_warning If set to true, then a manager existed in the organization prior to calling this API and the manager flag has been set to ‘Y’ for yes.
• @param p_spp_delete_warning Set to true when grade step and point placements are date effectively ended or purged by the update of the assignment. Both types of change occur when the Grade is changed and spinal point placements exist over the updated date range. Set to false when no grade step and point placements are affected.
• @param p_entries_changed_warning This is set to ‘Y’, if at least one element entry was altered due to the assignment change. It is set to ‘S’, if at least one salary element entry was affected (This is a more specific case than ‘Y’).
• @param p_tax_district_changed_warning Always set to False, since contingent worker assignments are not eligible to have a Payroll, therefore cannot be included in the United Kingdom processing which determines the value of this parameter.
• @param p_concatenated_segments If p_validate is false, set to Soft Coded Key Flexfield concatenated segments, if p_validate is true, set to null.

API Calling example:

Final result:.

Hope this helpful. If you found it simple and easy to understand, we would love to provide you and your friends a simple solution for your problems. Thanks.

Ahmed_Shmes

Related posts.

API to Create User-Defined Table UDT in Oracle APPS R12

API to Update Extra Information Types EIT in Oracle APPS ...

API to Create Organization Manager in Oracle APPS R12

API to create a new absence type in oracle apps ...

Leave a comment cancel reply.

You must login to add a new comment.

Insert/edit link

Enter the destination URL

Or link to existing content

• Install App

SQL & PL/SQL

For appeals, questions and feedback, please email [email protected]

ORA-06512: at "APPS.HR_ASSIGNMENT_API" - error on loading in API..

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.

ERPstuff - Oracle EBS Community

You love we care since 2006 by Malik Sikandar Hayat.

Skip to content

• Home Forums Oracle Applications (EBS) R12 & 11i HCM (Human Capital Management)

Hr_Assignment_Api.update_emp_asg_criteria ERROR

Post by m_muzamil_khan » Sun Aug 08, 2010 7:16 am

Post by ERP_GURU » Mon Aug 09, 2010 11:44 pm

Post by m_muzamil_khan » Tue Aug 10, 2010 1:06 am

Post by ERP_GURU » Tue Aug 10, 2010 12:05 pm

Post by eng_ahmad_2007 » Mon Sep 06, 2010 6:23 pm

Return to “HCM (Human Capital Management)”

• Home Forums
• All times are UTC

Powered by phpBB ® Forum Software © phpBB Limited

Privacy | Terms

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 ?

Doyen System Pvt. Ltd.

Tuesday 27 September 2016

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