If this is the case inhouse development team would like to access the HRMS/Payroll via API's so that they can have there own presentation layer.
Bespoke Application & Utilizing HR/Payroll APIs
Long time back I heard this term while working with a UK based client, in a telecon its sound like "They need a bespoke application with Oracle to cater Billing with Front end” ..What? The only time I had heard the words ‘spoke’ and ‘application’ in the same sentence was when someone told me about an application built on top of a hub and spoke architecture .
Well after that , I realized that ‘bespoke application’ means the same ‘custom built application’ or simply ‘custom application’ that we normally used to called as. I really donot know why UK English don't use word custom here. Its sound Interesting localization tidbit.
Bespoke (pronounced bee-SPOHK)
Therefore , "Bespoke" was most commonly used for suits made specifically for a customer without the use of a pattern. In effect, the length of fabric was "spoken for".
The Need
IT, Health care based industry are Manpower intensive, therefore Human Capital management system is really is need to cater today growing need. Though Integrated system like Oracle or people soft or SAP there is capability of maintaining each function, but still companies prefer to have a front end application for maintaining some of the key information for employee management system.Therefore Custom web based application possibility can not be ruled out.
1. Is this possible ? Then How?
2. Where do I find the API documentation?
So answer of these questions are
1. Yes, it possible. You need to identify the tables and API's
2. There are enough documentation available for this.
Just Follow these post, you will get answer of most of your query.
Its all about Table and API
Such kind of Bespoke/custom application requires these Oracle tables access which are divided into three major tracks.
- Reference tables : The details for driving basic Information.
- Employee tables : The details for driving employee vital details
- Payroll tables : Payroll details for employee or any other elements.
- Business groups, payrolls related information : In this set you requires company and payroll reference information , which is required to validate employee information for your company
- You can map with these payroll table
- hr_organization_units
- hr_locations
- pay_payrolls
- fnd_common_lookups
- You can map with these payroll table
- Counties, cities, states, zips : Contains the address info for employee address and tax validation. Tax validation is required if there is seperate rule for taxation or may have multiorg installation.
- You can map with these payroll table
- pay_us_states
- pay_us_counties
- pay_us_city_names
- pay_us_zip_codes
- You can map with these payroll table
- Deductions and levies : These are all the deductions and levies whatever configured in Oracle Apps.
- You can map with these payroll table
- pay_element_types_f
- pay_element_links_f
- pay_element_values
- You can map with these payroll table
- Persons and address tables :These are employee personal and employment information
- You can map with these payroll table
- per_people_f
- pay_people_groups
- per_assignments_f
- per_addresses
- You can map with these payroll table
- Deductions and levies
-
- You can map with these payroll table
- pay_element_entries_f
- pay_element_entry_values_f
- You can map with these payroll table
- Direct Deposits
- You can map with these payroll table
- pay_external_accounts
- pay_org_payment_methods_f
- pay_personal_payment_methods_f
- You can map with these payroll table
- Payroll summary :Contains all the payroll details such as earnings, deductions, bonuses, and hours in a few tables
- You can map with these payroll table
- pay_payroll_actions
- pay_assignment_actions
- pay_run_results
- pay_run_result_values
- pay_element_classifications
- pay_element_types_f
- pay_input_values_f
- You can map with these payroll table
- Payment summary :Contains check and direct deposit details such as amount and account numbers
- You can map with these payroll table
- pay_payroll_actions
- pay_assignment_actions
- pay_pre_payments
- pay_org_payment_methods_f
- pay_personal_payment_methods_f
- You can map with these payroll table
So here are few Business events required for your bespoken application and there underline API's details
Add a New Employee
Update Employee Information
- Insert person :hr_entry_api.insert_element_entry
- Update people group :hr_assignment_api.update_emp_asg_criteria
- Update assignment :hr_assignment_api.update_us_emp_asg
- Insert base salary :insert into per_pay_proposals
- Insert check as the payment method :hr_entry_api. insert_element_entry
Add terminating employees
- Update personal information if it changed: per_per_upd.upd
- Update assignment and people group information if it exists, set mode to correct or update :hr_assignment_api.update_emp_asg_criteria
In Oracle On Terminate screen, select Actual Process Date and/or Final Process Date and click on Terminate button. Optionally, enter 'Leaving Reason,' 'Notified,' 'Projected,' 'Last Standard Proces' values.
These are API's are available for termination
Hr_ex_employee_api (File name: peexeapi.pkb) This file contains three (3) procedures..... hr_ex_employee_api.actual_termination_emp hr_ex_employee_api.update_term_details_emp hr_ex_employee_api.final_process_emp Note: The API's have to be called in that order.
Address
Phones
- Insert or Update Addresses :hr_person_address_api.create_person_address
- Update existing address records :hr_person_address_api.update_person_address
Schools and Colleges
- Insert or create a phone :hr_phone_api.create_phone
- update existing phone records :hr_person_address_api.update_person_address
Insert or Update Deductions
- Insert or create a schol and college information :per_esa_ins.ins
- update existing records :per_esa_upd.upd
Qualifications
- If deduction is ended, use the delete API to set end date :hr_entry_api.delete_element_entry
- Update deduction if exists, else insert it :hr_entry_api.insert_element_entry
End Date /delete Element Enties
- Insert or create a qualifications information :per_qualifications_api.create_qualification
- update qualifications records :per_qualifications_api.update_qualification
There are 4 date track delete modes available (variable p_datetrack_delete_mode)
End Date /delete Element Enties :py_element_entry_api.delete_element_entry
Insert or Update Direct Deposits
- DELETE end date element entry
- DELETE_NEXT_CHANGE delete next changes
- FUTURE_CHANGE delete future changes
- ZAP completely remove element entry from the database
- If direct deposit is ended, use the delete API to set end date :hr_personal_pay_method_api.delete_personal_pay_method
- Insert bank account if it does not exist :insert into pay_external_accounts
- Update direct deposit if exists, else insert it :hr_personal_pay_method_api.create_personal_pay_method
Inform Manager of Inactive Employee Credit card process
Jobs
Use this if required inactivate employee credit card process : hr_ex_employee_api.actual_termination_emp
Positions
- Create new Job :hr_job_api.create_job
- Updating the job details :hr_job_api.update_job
- Create new position :hr_position_api.create_position
- Updating the position details :hr_position_api.update_position
Where I can get the details for these API's
For Oracle release 11 ,11i release 12, the APIs are located in the operating system directories:
$PER_TOP/patch/xxx/sql and $PAY_TOP/patch/xxx/sql,
Refer to filenames like pe****api.pkh, py****api.pkh, and hr****api.pkh, where **** represents wildcard characters.
You can identify the package name and version of the API.
Run this query
SELECT text FROM all_source WHERE name LIKE '%your_api_name%' AND text LIKE '%Header%';
This query will return the header line of the pac kage and package body showing the package name and current version number.
SELECT object_type,object_name FROM user_objects WHERE object_name LIKE 'HR%API';
Publicly Callable Business Process APIs in Oracle HRMS
Oracle APIs are a logical grouping of all external process routines. The Oracle HRMS API sets delivers a set of PL/SQL packages procedures and functions that provide an open interface to the database.
There are three options for you to find the details:
- Oracle Documents
To find a current list of publicly callable business process APIs in Oracle HRMS; you need to go into your On Line Help from within applications and use the search field to find 'Publicly Callable Business'. In the Search Results frame you will see a link to 'Publicly Callable Business Process APIs in Oracle HRMS (Oracle HRMS)' listed. - Irep
To find correct information on APIs you check Oracle Integration Repository (irep) which can accessed via MetaLink by selecting the Knowledge tab - Knowledge Browser sub-tab, then in the Online Documentation box select - Oracle Integration Repository. - Search the database
You may find official documentation on Publicaly Callable APIs as in options 1.
You can search in the HR Schema for the stored procedures with name 'HR%API'. Open the Package spec and then read the inline comment about the parameters. This is very useful to understand what is meant by each paramater and what the API does. - Etrm via metalink
TRM helpful in selecting the appropriate API call.
Before using any API's of payroll and HRMS you must have clear understanding of
- Data Tracking
- Validation paramater
- Correction, insert mode of API's
You can download "Configuring, Reporting and System Administration in Oracle HRMS" document from the Oracle documentation library. It has a list of api's.
0 comments