Introduction: This query will fetch you the responsibility details which is missing for a user. The input parameter passed is ‘user name’ which will get processed and provide you with…
Read MoreIntroduction:This query will fetch you the user responsibility details such as responsibility name, application name, description, security group, start date and end date. The input parameter passed is ‘user name’…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the HR Contingent Worker details per country for EBS to Cloud data migration. SQL Query : SELECT …
Read MoreHRMS API :Create Position Hierarchy by Using APIs (hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele) Hierarchy Name Checking query =========================== select * from per_position_structures where name=’Sample Hierarchy’ Parent Position Name Checking Query =================================== select *…
Read MoreUser Hooks There were many times we need to put some extra logic before or after happening of some business event. In Such cases, we use user hook API. It…
Read MoreThis blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide hr_employee_api.create_employee…
Read MoreProblems while creating the New Locations in Oracle R12 ERROR DETAIL: Not able to Create the new Locations as well as Update the existing Locations in Oracle. ERROR MESSAGE: “FRM-40735:ON-UPDATE…
Read More