Vacation Rule in Oracle EBiz

Objective:

• Add Vacation Rule option to User to Set up Vacation Rule for Others.

Step 1:

• Create Custom Menu

1. Routing Rules Administrator
2. Create Routing Rule
3. Update Routing Rule

Step 2:

• Create Custom Responsibility and add the EC Workflow Administrator Menu.

Step 3:

• Go to “Workflow Administrator Web Applications”
• Administrator Workflow > Administration > Select EC Workflow Administrator > Apply

Step 4:

• Add the Responsibility to the User.

Note:

1. Only an Administrator can create Vacation Rule for others. We can set Vacation Rule through the “Workflow Administrator Web Applications” responsibility. 
2. Workflow System Administrator may be a SYSADMIN, Workflow Administrator (Web Admin).
3. Usually SYSADMIN Login have the System administrator and Workflow Administrator Role.
4. If we want to give this rights to Other User, we have to give Admin rights to the User.
5. Workflow System Administrator is EC Workflow Administrator, then a User who holds EC Workflow Administrator can access the Vacation Rule (Set up for Others).
6. Workflow System Administrator is System Administrator, then a User should hold System Administrator Role access the Vacation Rule (Set up for Others).
7. Workflow System Administrator is Workflow Administrator, then a User should hold Workflow Administrator Role access the Vacation Rule (Set up for Others).

Query to find Current Employee List - Oracle HRMS

SELECT A.PERSON_ID,

A.EMPLOYEE_NUMBER,

A.FULL_NAME,

B.ASSIGNMENT_ID,

A.SEX,

A.ORIGINAL_DATE_OF_HIRE,

A.DATE_OF_BIRTH,

A.EMAIL_ADDRESS

FROM PER_ALL_PEOPLE_F A,

PER_ALL_ASSIGNMENTS_F B

WHERE A.PERSON_ID = B.PERSON_ID

AND A.BUSINESS_GROUP_ID = B.BUSINESS_GROUP_ID

AND SYSDATE BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE

AND SYSDATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE

AND A.CURRENT_EMPLOYEE_FLAG = 'Y'

--AND A.BUSINESS_GROUP_ID     = 0000

ORDER BY 1;

Edit the Query if you need.

Query to find the Employee and his Leave Details

This Query will fetch the Employee Person id, Employee Number, Employee Name, Leave Start Date, Leave End Date, Leave Name, Employee Assignment Id.

Change the Query as Per your Need.

SELECT A.PERSON_ID PersonId,

B.ASSIGNMENT_ID AssignmentId,

A.EMPLOYEE_NUMBER StaffNumber,

A.FULL_NAME StaffName,

Y.NAME AbsenceName,

Y.ABSENCE_ATTENDANCE_TYPE_ID AbsenceId,

X.DATE_NOTIFICATION NotifyDate,

X.CREATION_DATE CreatedDate,

X.DATE_START LeaveStart,

X.DATE_END LeaveEnd,

X.ABSENCE_DAYS TotalDays

FROM   PER_ABSENCE_ATTENDANCES X,

PER_ABSENCE_ATTENDANCE_TYPES Y,

PER_ALL_PEOPLE_F A,

PER_ALL_ASSIGNMENTS_F B

WHERE   X.ABSENCE_ATTENDANCE_TYPE_ID = Y.ABSENCE_ATTENDANCE_TYPE_ID

AND     X.BUSINESS_GROUP_ID = Y.BUSINESS_GROUP_ID

AND     A.BUSINESS_GROUP_ID = Y.BUSINESS_GROUP_ID

AND     A.PERSON_ID = X.PERSON_ID

AND     A.PERSON_ID = B.PERSON_ID

AND     B.BUSINESS_GROUP_ID = Y.BUSINESS_GROUP_ID

AND     B.PERSON_ID = X.PERSON_ID

AND     SYSDATE BETWEEN A.EFFECTIVE_START_DATE AND  A.EFFECTIVE_END_DATE

AND     SYSDATE BETWEEN B.EFFECTIVE_START_DATE AND  B.EFFECTIVE_END_DATE

AND     X.DATE_START BETWEEN '01-JAN-2016' AND '31-JAN-2017' /* Duration */

AND   A.EMPLOYEE_NUMBER = 'XYZ' /* Employee Number */

AND Y.NAME = 'Unpaid Leave' /* Leave Name */

ORDER BY 6, 8; 

Position Related Useful Links

Position - Doc ID 434046.1

Position Hierarchy - Doc ID 549628.1

Oracle HRMS - Useful Links

User Profile Options

https://eqextportal.qantas.com.au/OA_HTML/help/state/content/navId.2/navSetId.iHelp/vtAnchor.profiles/vtTopicFile.iHelp%7CHelpServlet%7CUS%7Cper%7C%40profiles/

Person-Name Formats

https://eqextportal.qantas.com.au/OA_HTML/help/state/content/navId.2/navSetId.iHelp/vtAnchor.profiles/vtTopicFile.iHelp%7CHelpServlet%7CUS%7Cper%7C%40profiles/

How to Process Payroll after Termination - Oracle EBiz

1. Set Termination Rule to Last Standard Process for elements process on Normal Payroll Run.
2. Set Termination Rule to Final Process for elements process on Late Payroll Run.
3. Terminate the Employee and fill the Final Process Date as per your requirement. Ensure HR      system status of Terminate Assignment.
4. Actual Date is the Employees  actual date of Termination, all the regular Payroll Elements will be end dated.
5. Final Process date is the date where your process Final settlement, Late Payroll Run Elements will be processed.
6. Eg. If an Employee Terminated on 25-May-2016, his Actual Date is 25-May-2016, LSP Date is 31-May-2016. If you give Final process date as 30-June-2016, you can run Elements(Final Process Elements- Refer Point 2) till 30-June-2016. The assignment screen can be opened and can run Quick Pay or Payroll for the employee till 30-June-2016. Later 30-June-2016 you can't open the Assignment screen of an Employee.

Salary Administration

Useful Oracle Metalink Id for Salary Administration

142548.1

392567.1

Key Flex Field to Database items - Oracle Hrms

We can convert the Key Flex Field into a Database items by running the concurrent

"Create Key Flexfield DB Items"

Oracle R12 Payroll Setup Steps

1. Complete Core HR Setup
2. Define Payment Type(Optional)
3. Define Payment Method
4. Define Payroll
5. Element Creation
6. Element Link and Costing
7. Define Salary Basis
8. Write Formula(Fast Formula)
9. Formula Result
10. Quickpay or Payroll Run

*Concepts includes Retropay, Balances.

Steps to Create a Request in Employee Self Service

Create SIT
Create Function
Add Function in Employee Self Service Menu and Global Self Service Menu
Personalize SIT Flex Field
Workflow
AME for Approval

Oracle R12 Core Hr Setup Steps

1. Login with Sysadmin Responsibility
2. Responsibility Creation(Custom)
3. User Creation and Attach Corresponding Responsibilities
4. Key Flex Field Creation 
1. Job
2. Position
3. Grade
4. Compentency
5. People Group
6. Cost Allocation
5. Value Sets Creation
6. Values Creation
7. Location
8. Business Group & Business Group Info
9. Profile Option 
1. HR Business Group
2. HR Security
3. HR User
10. Organization Creation & Organization Hierarchy
11. Job 
12. Position & Position Hierarchy
13. Grade & Grade Rate
14. Hire an Employee (Enter & Maintain)
15. Assign Assignment(Job, Position, Grade, People Group)