How an Application Life Cycle goes:-
1. Evaluate the Essential information’s to make up the core work.
2. Install EBS
3. Start configuring the functional you are going to develop and deploy
4 .Convert the Legacy system and transfer data to EBS
5. Test the system and data flow.
6. Migrate according the client environment.
7.Sustain the configuration and update it.
Implementation
Quick Start Implementation:
CRP’s (Conference Room Pilots):-
-Configures Oracle HR & Payroll Applications
-Generates the default settings and loads configuration.
-Loads the reference tables.
Configuration models:-
1.Single operating company in one country.
2.Single operating unit with many countries.
3.Multiple operating unit in one country.
4.Multiple operating unit in multiple country.
CRP’s (Conference Room Pilots):-
-Configures Oracle HR & Payroll Applications
-Generates the default settings and loads configuration.
-Loads the reference tables.
Configuration models:-
1.Single operating company in one country.
2.Single operating unit with many countries.
3.Multiple operating unit in one country.
4.Multiple operating unit in multiple country.
Important API's
HR_ASSIGNMENT_API
CREATE_SECONDARY_EMP_ASG To Create a secondary Assignments for Employee
CREATE_GB_SECONDARY_EMP_ASG To Create a secondary Assignments for UK Employee
CREATE_US_SECONDARY_EMP_ASG To Create a secondary Assignments for US Employee
SUSPEND_EMP_ASG To Suspend The Employee assignments(Temparary)
ACTUAL_TERMINATION_EMP_ASG To Remove All Assignements for employee(Permanent)
UPDATE_EMP_ASG Update The Existing assignment for an Employee
UPDATE_GB_EMP_ASG Update The Existing assignment for an UK Employee
UPDATE_US_EMP_ASG Update The Existing assignment for an US Employee
UPDATE_EMP_ASG_CRITERIA To Update Assignment Criteria for an employee
ACTIVATE_EMP_ASG Use to Activate Suspend Assignment for an Employee
UPDATE_APL_ASG To Update Assignment for an Applicant
TERMINATE_APL_ASG To Terminate Assignment for an Applicant
SET_NEW_PRIMARY_ASG Use to set The purticular assignment as a Primary.
HR_EMPLOYEE_API
CREATE_EMPLOYEE Use to create a New Employee
CREATE_GB_EMPLOYEE Use to create a New UK Employee
CREATE_US_EMPLOYEE Use to create a New US Employee
RE_HIRE_EX_EMPLOYEE Use to rehire ex-employee who got termination Already
GET_PERSON_DETAILS Display The Person details
HIRE_INTO_JOB Hire a perticular person to purticular Job
HR_ENTRY_API
INSERT_ELEMENT_ENTRY Use to create a new element entry
CHECK_SALARY_ADMIN_UPDATES
UPDATE_ELEMENT_ENTRY Use to Update a existing element entry
DELETE_ELEMENT_ENTRY Use to delete a new element entry
HR_GRADE_API
CREATE_GRADE_RATE_VALUE Use to Create a grades
UPDATE_GRADE_RATE_VALUE Use to Update a grades
DELETE_GRADE_RATE_VALUE Use to Delete a grades
HR_JOB_API
CREATE_JOB Use to create a new jos for a puticular job group
UPDATE_JOB Use to Update a jos for a puticular job group
DELETE_JOB Use to Delete a jos for a puticular job group
HR_ORGANIZATION_API
CREATE_ORGANIZATION It's used to create.update and delete Organizations
UPDATE_ORGANIZATION
DELETE_ORGANIZATION
CREATE_ORG_CLASSIFICATION It's used to create.update and delete Org.Classification
ENABLE_ORG_CLASSIFICATION
DISABLE_ORG_CLASSIFICATION
CREATE_ORG_INFORMATION It's used to create.update Organizations
UPDATE_ORG_INFORMATION
CREATE_BUSINESS_GROUP Used to create Business Group
CREATE_OPERATING_UNIT Used to create Operating units
CREATE_LEGAL_ENTITY Used to create legal entity
CREATE_COMPANY_COST_CENTER
HR_PERSON_API
UPDATE_PERSON Used to Update the persons records
UPDATE_GB_PERSON
UPDATE_US_PERSON
CREATE_SECONDARY_EMP_ASG To Create a secondary Assignments for Employee
CREATE_GB_SECONDARY_EMP_ASG To Create a secondary Assignments for UK Employee
CREATE_US_SECONDARY_EMP_ASG To Create a secondary Assignments for US Employee
SUSPEND_EMP_ASG To Suspend The Employee assignments(Temparary)
ACTUAL_TERMINATION_EMP_ASG To Remove All Assignements for employee(Permanent)
UPDATE_EMP_ASG Update The Existing assignment for an Employee
UPDATE_GB_EMP_ASG Update The Existing assignment for an UK Employee
UPDATE_US_EMP_ASG Update The Existing assignment for an US Employee
UPDATE_EMP_ASG_CRITERIA To Update Assignment Criteria for an employee
ACTIVATE_EMP_ASG Use to Activate Suspend Assignment for an Employee
UPDATE_APL_ASG To Update Assignment for an Applicant
TERMINATE_APL_ASG To Terminate Assignment for an Applicant
SET_NEW_PRIMARY_ASG Use to set The purticular assignment as a Primary.
HR_EMPLOYEE_API
CREATE_EMPLOYEE Use to create a New Employee
CREATE_GB_EMPLOYEE Use to create a New UK Employee
CREATE_US_EMPLOYEE Use to create a New US Employee
RE_HIRE_EX_EMPLOYEE Use to rehire ex-employee who got termination Already
GET_PERSON_DETAILS Display The Person details
HIRE_INTO_JOB Hire a perticular person to purticular Job
HR_ENTRY_API
INSERT_ELEMENT_ENTRY Use to create a new element entry
CHECK_SALARY_ADMIN_UPDATES
UPDATE_ELEMENT_ENTRY Use to Update a existing element entry
DELETE_ELEMENT_ENTRY Use to delete a new element entry
HR_GRADE_API
CREATE_GRADE_RATE_VALUE Use to Create a grades
UPDATE_GRADE_RATE_VALUE Use to Update a grades
DELETE_GRADE_RATE_VALUE Use to Delete a grades
HR_JOB_API
CREATE_JOB Use to create a new jos for a puticular job group
UPDATE_JOB Use to Update a jos for a puticular job group
DELETE_JOB Use to Delete a jos for a puticular job group
HR_ORGANIZATION_API
CREATE_ORGANIZATION It's used to create.update and delete Organizations
UPDATE_ORGANIZATION
DELETE_ORGANIZATION
CREATE_ORG_CLASSIFICATION It's used to create.update and delete Org.Classification
ENABLE_ORG_CLASSIFICATION
DISABLE_ORG_CLASSIFICATION
CREATE_ORG_INFORMATION It's used to create.update Organizations
UPDATE_ORG_INFORMATION
CREATE_BUSINESS_GROUP Used to create Business Group
CREATE_OPERATING_UNIT Used to create Operating units
CREATE_LEGAL_ENTITY Used to create legal entity
CREATE_COMPANY_COST_CENTER
HR_PERSON_API
UPDATE_PERSON Used to Update the persons records
UPDATE_GB_PERSON
UPDATE_US_PERSON
Reports in HRMS
Absence report
advance pay listing
advance pay listing
assignment status report
assignment unavilable for processing report
aduit report
cost breakdown report(budget over a period)
Calculate commitment(costing)
Element result lisiting report
element link details report
Employee payroll movements report
full person details report set
pay advice report and more..
advance pay listing
advance pay listing
assignment status report
assignment unavilable for processing report
aduit report
cost breakdown report(budget over a period)
Calculate commitment(costing)
Element result lisiting report
element link details report
Employee payroll movements report
full person details report set
pay advice report and more..
Data Pump
Data Pump:
Allowing to load existing data from HRMS system into single Batch interface table
-uses appropriate API
-Data Pump engine used for data load process
-HR_API_modules Contains all HRMS API.
Advantages:
-can map same interface table to map data into different Business API's
-e.g. Create_employee and create_peron_address API's can be called by data pump int he same batch.
-Also rum multithreaded, restarted after error fixed.
Key components of data pump:
1. Meta Mapper:- Generates specific procedures & update data in interface table
pl/sql code: HR_PUMP_META_MAPPER.GENERATEALL;
or
HR_PUMP_META_MAPPER.GENERATE ('HR_EMPLOYEE_API','CREATE_EMPLOYEE');
Meta mapper view will be HRDPV_GREATE_EMPLOYEE
2. Batch Tables:-
Used to hold data to be uploaded
HR_PUMP_BATCH_HEADERS
HR_PUMP_Batch_LINES
HR_PUMP_BATCH_HEADERS: Has
batch_id
batch_name
batch status
business_group_name
HR_PUMP_Batch_LINES: Has
batch_line_id
batch_id
api_module_id
Batch Line table has 230 columns mapped to API parameters
3. Data Pump Procedure:
Meta mapper creates API Procedures to be used to insert records into batch line tables.
E.g. HRDPP_CREATE_EMPLOYEE.INSERT_BATCH_LINES
Generated views are procedure can be seen undar HRDPV_view & HRDPP_Procedure.
Execute HR_PUMP_META_MAPPER.HELP ('HR_EMPLOYEE_API','CREATE_EMPLOYEE');
4. Data pump Engine:-Standard concurrent program that performs upload of data with two essential parameters batch name and validate.
Allowing to load existing data from HRMS system into single Batch interface table
-uses appropriate API
-Data Pump engine used for data load process
-HR_API_modules Contains all HRMS API.
Advantages:
-can map same interface table to map data into different Business API's
-e.g. Create_employee and create_peron_address API's can be called by data pump int he same batch.
-Also rum multithreaded, restarted after error fixed.
Key components of data pump:
1. Meta Mapper:- Generates specific procedures & update data in interface table
pl/sql code: HR_PUMP_META_MAPPER.GENERATEALL;
or
HR_PUMP_META_MAPPER.GENERATE ('HR_EMPLOYEE_API','CREATE_EMPLOYEE');
Meta mapper view will be HRDPV_GREATE_EMPLOYEE
2. Batch Tables:-
Used to hold data to be uploaded
HR_PUMP_BATCH_HEADERS
HR_PUMP_Batch_LINES
HR_PUMP_BATCH_HEADERS: Has
batch_id
batch_name
batch status
business_group_name
HR_PUMP_Batch_LINES: Has
batch_line_id
batch_id
api_module_id
Batch Line table has 230 columns mapped to API parameters
3. Data Pump Procedure:
Meta mapper creates API Procedures to be used to insert records into batch line tables.
E.g. HRDPP_CREATE_EMPLOYEE.INSERT_BATCH_LINES
Generated views are procedure can be seen undar HRDPV_view & HRDPP_Procedure.
Execute HR_PUMP_META_MAPPER.HELP ('HR_EMPLOYEE_API','CREATE_EMPLOYEE');
4. Data pump Engine:-Standard concurrent program that performs upload of data with two essential parameters batch name and validate.