hr_assignment_api.update_emp_asg in r12

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.

Oracle Apps Technical

Tuesday, february 16, 2016.

• hr_assignment_api.update_emp_asg in HRMS

No comments:

Post a Comment

Blog Archive

• ►  February (2)
• ►  July (1)
• hr_person_api.update_person in HRMS
• Create User and Create Responsibility Using Script
• ►  January (1)
• ►  November (2)
• ►  September (1)
• ►  April (1)
• ►  March (3)
• ►  February (4)
• ►  June (4)
• ►  June (1)
• ►  December (3)
• ►  November (1)
• ►  May (5)
• ►  February (1)
• ►  November (7)

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.

API to suspend assignment in oracle HRMS

Introduction:

In oracle HRMS there are two kind of unique identifier for employee

• Employee Number
• Employee Assignment Number

Here we’ll talk about Employee Assignment Number : The employee assignment number uniquely identifies every assignment that exists within your Business Group. An employee can have one or more than one assignment, and therefore more than one assignment number . Oracle

changes the status of an employee assignment to a “Suspended” using HR_ASSIGNMENT_API.SUSPEND_EMP_ASG API.

Forms Or Pages:

Prerequisites:

• The assignment must be an employee assignment, and must exist on the effective date

API IN/OUT Parameters :

— IN — p_validate IN NUMBER Optional Default FALSE — p_effective_date IN DATE Required — p_datetrack_update_mode IN VARCHAR2 Required — p_assignment_id IN NUMBER Required — p_change_reason IN VARCHAR2 Optional Default hr_api.g_varchar2 — p_assignment_status_type_id IN NUMBER Optional default hr_api.g_number — IN OUT — p_object_version_number IN OUT NOCOPY NUMBER — OUT x_return_status OUT VARCHAR2(1) — p_effective_start_date OUT NOCOPY DATE — p_effective_end_date OUT NOCOPY DAT

API Parameters clarifications:

• @param p_validate If true, then validation alone will be performed and the database will remain unchanged. If false and all validation checks pass, then the database will be modified.
• @param p_effective_date Determines when the DateTrack operation comes into force.
• @param p_datetrack_update_mode Indicates which DateTrack mode to use when updating the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a particular record depend on the dates of previous record changes and the effective date of this change.
• @param p_assignment_id Identifies the assignment record to be modified.
• @param p_change_reason Reason for the assignment status change. If there is no change reason the parameter can be null. Valid values are defined in the EMP_ASSIGN_REASON lookup type.
• @param p_object_version_number Pass in the current version number of the assignment to be updated. When the API completes if p_validate is false, will be set to the new version number of the updated assignment. If p_validate is true will be set to the same value which was passed in.
• @param p_assignment_status_type_id The new assignment status. The new status must have a system status of SUSP_ASSIGN. If the assignment status is already a type of SUSP_ASSIGN this API can be used to set a different suspend status. If this parameter is not explicitly passed, the API uses the default SUSP_ASSIGN status for the assignment’s business group.
• @param p_effective_start_date If p_validate is false, then set to the effective start date on the updated assignment row which now exists as of the effective date. If p_validate is true, then set to null.
• @param p_effective_end_date If p_validate is false, then set to the effective end date on the updated assignment row which now exists as of the effective date. If p_validate is true, then set to null.

API Calling example:

Final result:.

Hassan AbdElrahman

• Oracle ACE Awarded.
• Around 7+ years of experience in Oracle Applications Technical experience in Oracle E-Business Suite R12.
• I have written 75+ articles and answered 100+ questions in a related field.
• Proficient in Workflows, Data Conversions, Interfaces, Client Extensions, Reports (XML, Bi Publishers, and RDF), and Forms (10g), Alerts, OAF extension.
• hands-on experience with oracle mobile supply chain framework JAVA framework.
• Hands-on experience with Oracle integration cloud OIC
• Excellent knowledge of DATABASE Index’s. Views, Triggers, Procedures, Functions, Database security, Privileges and Optimization.
• Played various roles such as designing and development of application Documents and Direct interaction with client to gather requirements.

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

Human Capital Management - EBS (MOSC)

Discussions

Getting error ORA-20001 while trying to update the employee supervisor through API

Below are the issue details.

Oracle Apps: 12.1.3

Data Base Version: 11.2.0.2.0

We are using the API hr_assignment_api.update_emp_asg and hr_assignment_api.update_emp_asg_criteria to update the employee assignment but getting the error as "ORA-20001: Supervisor is not valid for the duration of the assignment." We found a MOS note Doc ID 1190173.1 but it is for Release R12.0 which is not supported in our version.

Could you please provide any alternate method to resolve this issue?

• EBS_HCM_HumanResources
• EBS-HCM-HCM

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