hr_assignment_api.update_emp_asg_criteria

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 ?

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 HR Foundation

Oracle HR Foundation provides a restricted set of responsibilities and database objects to carry out selected HR tasks. Users of non-HRMS applications, for example, Oracle Projects, often use the Oracle HR Foundation responsibility to gain access to HR functionality.

For information on the database objects and menus available in HR Foundation, see:

APIs Available for Foundation Users

Menus Available for Foundation Users

Requirements

What is hr foundation.

HR Foundation is a responsibility available for bundling with specified Oracle Applications. In order to further applications integration, Oracle HR has delivered a responsibility which groups together a set of Forms which can be used by other Oracle Applications. This functionality delivers more processes than the current Shared HR facility, and so makes more shared processes available for use. Examples include competency management.

Working with HR Foundation

Apis available for hr foundation users.

Application Programmatic Interfaces (APIs) are a logical grouping of all external process routines. The Oracle HRMS API strategy delivers a set of PL/SQL packages procedures and functions that provide an open interface to the database.

Oracle® Integration Repository, an integral part of Oracle E-Business Suite, is a compilation of information about the numerous interface endpoints exposed by Oracle applications. The full list of public APIs and the purpose of each API is available in the integration repository. See: Oracle Integration Repository Overview, Oracle Integration Repository User Guide . For information on how to access and use Oracle Integration Repository, see: Accessing Oracle Integration Repository, Oracle Integration Repository User Guide

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

List of APIs Supported for HR Foundation

The following table shows the APIs delivered with Oracle HR Foundation.

Important: Legislation WW = All Legislations

APIs to Which Restrictions Apply for HR Foundation

The following table includes APIs with a list of restricted parameters that you can use for each API. For APIs that are not part of this restricted list, you use all parameters.

Menus Available for HR Foundation Users

The Employee Self-Service Foundation responsibility offers the following menu items in the Oracle Applications Framework interface:

The Manager Self-Service Foundation responsibility offers the following menu items in the Oracle Applications Framework interface:

The HR Foundation responsibility offers the following menu items in the Professional User (forms) Interface:

Windows for HR Foundation Users

Enter person.

Use the Enter Person window to enter, maintain, and view basic personal information and addresses for employees and external contacts. For your employees, you can also enter work assignment information, which includes organization, job, position, work location, and supervisor's name.

Note: In Oracle Learning Management this window is called the Enter Person window.

The following Oracle applications use this form:

Engineering

Project Accounting

Training: You can use this form to enter training resources.

Work in Process: You must enter an employee if you want to define and charge an employee rate to a job or repetitive schedule.

Entering a New Employee

Recording employment termination and rehiring ex-employees.

Resource Creation, Oracle Learning Management User Guide

Viewing Person Information

Use the Enter Person window to enter and maintain basic personal information, addresses, and work assignment details for your employees.

The system warns you if you enter two people with the same name and birth date.

Note: You cannot use this form if Oracle Human Resources is installed at your site. You must use the HR People window, which maintains a datetracked history of any changes you make to employee records.

Prerequisites

Select your employee number generation method in the Financial Options window.

To enter a new employee

Enter the employee's name. Only the last name is required.

If your enterprise uses manual employee number entry, enter an employee number and national identifying number (such as Social Security Number in the US).

If your enterprise uses automatic number generation, enter a national identifying number only. The employee number automatically displays when you save your entries in this window.

Enter the employee's hire date in the first of the Employment Dates fields. This must be on or before today's date.

In the Email field, you can enter an email user ID.

In the Mail field, select Home or Office to indicate the employee's preferred mail address. For example, Oracle Payables mails employee expense checks to this address.

Save your work and choose More... to enter additional information.

Choose Address to enter address information.

Choose Assignment to enter work assignment and supervisor information.

Entering Addresses

You can enter as many addresses as necessary for each employee in the Address region of the Person Information window.

Set up any address types you want to use (such as home or office) as Lookups for the Lookup Type ADDRESS_TYPE.

To enter an address

Select a national address style.

A window opens with the address format for the country you select.

Enter your address information in this window and choose OK.

This returns you to the Address window.

Select an address type, such as home, or weekend, or office.

You can check Primary for the address you are creating, to identify the employee's main address. By default, the first address you enter is the Primary address.

Only one address at any time can be a person's Primary address.

Additional Information: Default address styles are predefined for many countries. You can create address styles for other countries

Note: See: Oracle HRMS Technical Reference Manual

Entering Employee Work Assignments

You enter information about an employee's work assignments in the Assignment tabbed region.

If you want to assign the employee to an organization, job, or position, you must define these work structures first.

See: Creating an Organization, Oracle HRMS Enterprise and Workforce Management Guide

See: Defining Jobs, Oracle HRMS Enterprise and Workforce Management Guide

See: Defining Positions, Oracle HRMS Enterprise and Workforce Management Guide

Enter the work address of the assignment in the Location window.

See: Setting Up Locations, Oracle HRMS Enterprise and Workforce Management Guide

Set up your Accounting key flexfield.

To enter a new assignment

Select the organization to which you want to assign the employee. The default organization is the Business Group.

If a location is defined for this organization, it also appears as a default.

Select the job, position, and supervisor for the employee's assignment.

The employee's supervisor is the default next approver for all purchasing documents if the Use Approval Hierarchies check box in the Financial Options window is checked.

The Ledger field displays the ledger for your installation. The Default Expense Account field displays the concatenated description of the Account.

In some applications, you can select another flexfield structure that the employee's expenses should debit. Oracle Payables uses this information to generate expense reports for your employees.

Enter a location for the assignment.

Updating Employee Assignments Over Time

Project Accounting users can select the Assignment History region to view and update employee assignments over time.

The date fields in this region display the start and end dates of the assignment.

In the New Assignment region, you can insert a change to the assignment, as from a particular start date. The Assignment History region shows one row for every change to the organization, job, location, manager, or billing title of the assignment. Each row is valid between the dates shown at the bottom of the Assignment History region.

To insert a change to an assignment

Query the assignment you want to change in the Assignment History alternative region of the Person Information window.

In the New Assignment region, enter the start date of the change.

The other fields in this region display the values that are valid at this date.

Update any of the values in the New Assignment region, and save your changes.

To record employment termination

Query the employee in the Enter Person window.

Enter a termination date in the second of the Employment Dates fields, and save.

To cancel a termination

Clear the termination date in the second of the Employment Dates fields, and save.

To rehire an ex-employee

Query the ex-employee in the Enter Person window.

Change the value of the first date within the Employment Dates fields to the new hire date.

Click tab. This action must clear the termination date in the second of the Employment Dates fields.

Save the changes.

You can use the Enter Person window to view information about a person or about groups of employees or other people.

To find selected people

If the Find People window does not open automatically, choose Find from the Query menu.

You can enter any combination of the following criteria:

a person's name or employee number

a national identifying number (such as social security number)

work location

Choose the Find button to run the query.

Choose Next Record from the Go menu to see each person retrieved by the query.

Defining a Position (non-HRMS users)

You use the Position window to define positions within your organizations and to add them to position hierarchies. You can also enter the skills that position holders require and the grades to which they can be assigned. You can enter position evaluation scores, if you have set up a position evaluation system.

To define a position

Enter a start date early enough to handle any historical information you want to enter. You can also enter an end date, but ensure it is before the end date of all the valid grades for the position.

Tip: Consider using a fixed date as a default for your initial setup, for example, 01-JAN-1901. This will simplify your data-entry.

Enter a unique name for the position.

If there is more than one segment in the Position Name flexfield, a window opens when you enter the Name field. You must enter a unique combination of segments in this window.

Select the organization and job for this position. They must have a start date on or before the start date of this position.

Note: You cannot change the organization or job once you have saved the definition.

You can set up several positions that have the same job in the same organization. Each position name must be unique.

Optionally, select a status for the position. If the status is Valid or blank, employees can be assigned to the position. If the status is Invalid or any other status defined at your site, employees cannot be assigned to the position.

Location and Standard Conditions default from the organization, but you can override the defaults.

If there is a probation period for this position, you can enter its length in the Probation Period tabbed region.

In the Absence tabbed region, select Yes in the Replacement Required field if you want users to be warned that they should enter the name of a replacement when they enter an absence for a holder of this position. You can do this for positions where it is essential that a person is in charge at all times.

You can select the position that should be held by the person to cover as relief in case of absence.

In the Planned Successor tabbed region, you can select the position from which a successor will move to fill this position.

Save your position.

If you want to add the position to one or more position hierarchies, choose the Reporting To button. Select a hierarchy and the name of the position to which this position reports.

Choose the Evaluation button to enter evaluation information and an overall evaluation score for the position.

See: Entering Evaluation Information, Oracle HRMS Enterprise and Workforce Management Guide .

Choose the Requirements button to enter position requirements, such as required qualifications or valid experience, to help you match people to roles.

See: Entering Job and Position Requirements, Oracle HRMS Enterprise and Workforce Management Guide

Note: You use the Competence Requirements window to enter competencies if you are following the competence approach.

Choose the Valid Grades button to enter the grades to which position holders can be assigned.

See: Entering Valid Grades for Jobs or Positions, Oracle HRMS Enterprise and Workforce Management Guide

Choose the Occupancy button to view all those people who have held a selected position or who are applying for it, and the dates of their occupancy. This information could be relevant for selecting people with the necessary skills for similar positions.

See: Viewing Position Occupancy, Oracle HRMS Enterprise and Workforce Management Guide

Choose the Work Choices button to enter work choices that can affect an employee's, applicant's, contractor's, or ex-employee's capacity to be deployed within your enterprise (or a customer's).

See: Entering Work Choices for a Job or Position, Oracle HRMS Enterprise and Workforce Management Guide

Choose the Survey Mapping button to link salary survey lines to your position.

See: Mapping Salary Survey Lines, Oracle HRMS Compensation and Benefits Management Guide

Choose the Extra Information button to enter any additional information required by your enterprise.

See: Entering Extra Information, Oracle HRMS Configuring, Reporting, and System Administration Guide .

Entering and Maintaining Contingent Worker Information (HR Foundation)

Note: This information is for HR Foundation users only.

This template has no DateTrack support. If you enter a contingent worker with a future start date, the record disappears when you save it. You can retrieve the record in the Find window if you set the effective date to the relevant contingent worker's start date.

Use the Enter and Maintain Contingent Workers template.

To enter or maintain contingent worker information

To create a new contingent worker, click the New icon. To update an existing contingent worker, select the contingent worker in the People Management Data Organizer and click Show Details.

On the Personal tab, enter or update the contingent worker's name information.

Click the Communication tab to enter or update home or work contact details.

Click the Assignment tab to enter or update information about the contingent worker's supplier, assignment, or work structures.

Note: If you use Oracle Services Procurement to provide purchase order information, you cannot alter assignment or supplier information obtained from the purchase order or purchase order line. However, you can select a different purchase order or purchase order line.

Save your work.

Scripting on this page enhances content navigation, but does not change the content in any way.

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

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)

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.

Rafiuddin - Oracle EBS Techo-Functional

HCM, Finance, SCM, BI (OBIEE & Discoverer), Workflow, D2K, OAF, ADF, XML, AME, SSHR, FSG, API, DBA

Saturday, September 6, 2014

Update employee assignment criteria (hr_assignment_api.update_emp_asg_criteria).

Doyen System Pvt. Ltd.

Tuesday 27 September 2016

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

SQL Developer (MOSC)

Discussions

When Updating Employee Assignment using hr_assignment_api.update_emp_asg_criteria below error appear

ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, 81, N, SEGMENT, Employer, N, VALUESET, HR_AE_LEGAL_EMPLOYER

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