Delete command - You can use the DELETE action as part of the HDL (.dat) file for objects supporting deletes. Command identifies business-object components to be purged from Oracle Fusion HCM. You cannot delete individual date-effective records so you need to delete the complete logical business object. The supervisor or Job level does not exist. (FUN-720337) Cause The list builder used in the configuration of approval rule is not coherent with the HCM Supervisory or Job level hierarchy. Action Correct the list builder definition in approval rules or HCM employee supervisory hierarchy or Job level hierarchy. Supervisor hierarchy.
Hierarchical query on employees and their supervisor in Oracle HR
We all know the famous emp/dept hierarchical queries to show employees belonging to a department and employees with their manager. I recently came across a question on how to query all employees and their managers (called supervisors in HR) in a hierarchical manor so I created this query as combination of what I've read in https://technology.amis.nl/2005/08/16/hierarchical-query-with-nodes-from-different-tables-dept-and-emp-nodes-in-one-tree/) and Oracle database schema.Note that the employee - supervisor link can be circular. In that case you will not find those employees in the tree, since there is no top node where the manager (supervisor_id) is empty.
with emps as
(
-- The managers
select s.person_id empno
, s.first_name || ' ' || s.last_name ename
, sa.supervisor_id mgr
from per_people_x s
, per_assignments_x sa
where s.person_id = sa.person_id
and exists (select 1 from per_assignments_x a where a.supervisor_id = s.person_id)
union
-- The employees
select p.person_id empno -- all EMP-nodes
, p.first_name || ' ' || p.last_name ename
, a.supervisor_id mgr
from per_people_x p, per_assignments_x a
where p.person_id = a.person_id
)
select lpad(' ', level*3)||ename ename
from emps
connect
by prior empno = mgr
start
with
nvl (mgr,-1) = -1
/
Oracle HRMS Interview Questions
1Q) What are the minimum classifications to create a Business Group?
Ans: Business Group
GRE/Legal Entity
HR Organization
2Q) What are the pre-requisites for creating a Business group?
Ans: Value sets
Key flex fields
Location
3Q) What are the basic setups of Oracle HRMS?
Ans: In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, recruitment, Time and Labour, Compensation Workbench, Oracle Advanced Benefits, Performance Management System, etc., Core HR and System Administrator are the Heart of Oracle HRMS.
All basic setups will do in Core HR with the help of the System Administrator.
In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values, etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, We will create all the employees also. These are the Basic setups in HRMS.
4Q) What is the use of the HR organization?
Ans: If we want to assign the employee information to a Business Group, then we need to have HR organization classification under a business group
5Q) What is a people group?
Ans: It is a flexible area for holding user-defined assignment data
Data can be used for grouping sets of the assignment together
People group can be used for element eligibility
This information is used by the payroll run
The data will be held in PAY_PEOPLE_GROUPS.
Group_name field holds the concatenation of segment data.
6Q) What is kff structure for SIT?
Ans: Personnel analysis flexfields
Interested in mastering Oracle HRMS? Enroll now for FREE demo on 'Oracle HRMS Training'
7Q) What is the DFF structure for EIT?
Ans: Extra-person information
Assignment extra information
Extra location information
Oracle Hcm Supervisor Querybaldcirclekidz Description
Extra position information
Extra job information
Organization developer DF
8Q) How to enable EIT?
Ans: Switch responsibility to human resources, vision enterprises
Double click on security
Click on information types
Create your own information types under your responsibility name
9Q) How to enable SIT?
Ans: Switch responsibility to human resources vision enterprises
Double click other definitions
Click on special information types
10Q) What is the Data Track?
Ans: It is used to maintain record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.
The value of the Data track record depends on the date
Tables ending with _F are date track tables
To control data tracked rows, every Date Track table must include the Effective start date and Effective end date.
The effective start date indicates when the record inserted
The effective end date indicates when the record updated or deleted.
11Q) What are the core flexfield?
Ans: There are 6 Core Flex fields are there
Job
Position
Computer programming video games. Grade
Competency
People Group
Cost Allocation
12Q) What is element entry? what is the purpose of element entry?
Ans: Element entry is to define element yet here enter that is Earning element or deduction element then calculate net pay.
13Q) What are the processing types of elements?
Ans: Elements are nothing but the components of the salary.
Eg. Basic, HRA, TA, BONUS, Loans, etc., There are 2 types of Processing
Recurring: if an entry of this element applies in every period until the entry is ended
Non-Recurring: if an entry applies in one pay period only.
14Q) What are the termination roles of an element?
Ans: Termination Rules of an Element:
Actual Termination: For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.
Final Close: if you want the entries to stay open beyond the employee's leaving date so that you can continue to pay the employee.
The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee.
15Q) What are 2 modes of date Track and what is date track?
Antares autotune free download windows. Ans: Date Track modes are:
Update Correction
16Q) Define Batch Element Entry?
Ans: This is an open interface specially designed for elements. With BEE we can quickly incorporate mass updates in any specific elements.
17Q) What are Reversal and Retry?
Ans: Reversal can be used to correct run results for one assignment after post-run actions have already occurred. Retry is for correcting mistakes after a payroll process finishes.
18Q) Which elements do you link openly in Payroll?
Ans: Worker’s Compensation and Vertex (Vertex is a third party software to calculate US Canadian taxes) using Quantum files. (It is part of Vertex software which will be updated as and when the tax and legal rules are changed by the US/Canadian Government. So we keep getting the Vertex patches to bring Quantum files with the up to date tax rules and conditions)
19Q) What is Consolidation Set, Element Set & Assignment Set?
Ans: Consolidation Set: A grouping of payroll runs within the same time period for which one can schedule reporting, costing, and post-run processing.
20Q) What are the mandatory fields while creating Payroll?
Ans: Payroll Name, Period Type and Start Date
21Q) Define Elements?
Ans: Elements are the building blocks for earnings, deductions, etc. of a Payroll.
Salary Basis
The salary basis is the duration on which the salary is reckoned. It is a rule to administer pay.
Define – Quick Pay & Batch Processing When calculating pay, we can use either
- Quick Pay Process, which is for one employee or - Batch Process for all employees together
What is Retro Pay, Advance Pay & Absence Pay - Retro Pay – Payment for any previous cycle in the current payroll run - Advance Pay – Payment for any future cycle/advance in the current payroll run - Absence Pay – Payment for leaves like sick leave, maternity leave, annual leave, and other statutory leaves
22Q) What are Fast Formulas?
Ans: Fast formulas are pseudo codes used in the payroll for validating the entry values, assignment sets, and element sets.
Post Payroll Process
Three concurrent processes will run in the Post-Payroll process, viz.
Pre-payment Process
Costing Process &
Transfer to GL Process
Oracle Hcm Supervisor Querybaldcirclekidz Responsibilities
23Q) What do you mean by Garnishments?
Ans: Third-Party payments are also known as Wage Attachments, Wage Garnishments, and Court orders in different localizations. 3rd party payments are deductions from earnings incurred by Court debts or fines. For example, payment of maintenance, child support, or other legally incurred obligations.
24Q) What is BACS, NACHA?
Ans: BACS: Banks Automated Clearing System. This is the UK system for making direct deposit payments to employees.
NACHA: National Automated Clearing House Association. This is the US system for making direct deposit payments to employees.
25Q) Does Oracle Payroll enable you to run part payrolls?
Ans: Yes, Oracle Payroll enables you to run part payrolls. This is useful in each of the following circumstances where you do not want to process payroll for the entire organization.
26Q) Can you verify that a payroll run has completed successfully?
Ans: On completion of a payroll run you will need to verify that the run completed successfully. You can display run messages and view the latest balances and assignment level results. You may also need to have relevant information grouped by topic in the report format so that you can review the outcome of processing.
27Q) Can you make adjustments after a payroll run has completed?
Ans: Oracle Payroll enables you to make each of the following types of adjustments when a payroll run has completed.
- Addition of late entries that were not included in the initial run - Corrections to details that were wrongly entered in the initial run - Retrospective distribution of current payments to the period in which they were earned
When you have made these corrections and modifications you can then run the payroll again. However, you do not need to rerun the entire payroll. Oracle Payroll will only reprocess those items that were incorrect in the initial run.
28Q) Can you produce a payment and costing information from a completed payroll run?
Ans: Oracle Payroll enables you to use the results of a payroll run to allocate payments to your employees, and to provide costing information.
Ensuring that Employees are paid by the Correct Payment Method
Oracle Hcm Supervisor Querybaldcirclekidz Sample
When a payroll run has completed you need to pay each employee according to the payment methods that you have specified. You may also need to override the predefined payment methods where employees are receiving special payments such as bonuses, which may not be paid by the usual methods of payment.
Oracle Hcm Supervisor Querybaldcirclekidz Interview
Ensuring that Costing Information can be provided
On completion of a payroll run, you may need to distribute the associated costs across particular cost centers. Oracle supports this using the Cost Analysis module.
29Q) Can you run payroll processes and reports multi-lingually?
Ans: Payroll processes and reports are always submitted and always run in the local language only. This means that US and UK payroll reports can only be run in English.
Oracle Hcm Supervisor Querybaldcirclekidz Salary
30Q) Can you verify that payments have been made?
Ans: Yes. Oracle Payroll is fully integrated with Oracle Cash Management. This enables you to use Oracle Cash Management to verify that payments have been cashed. Reconciliation can be applied to payroll checks (cheques) and third-party checks. You can identify which checks have been cleared and the date on which they were cleared. You can also view a reconciliation report which shows if voided checks appear to have been cashed.