SQL to find the manager and their direct reportees

select papf_Reportee.person_number, to_char(pasf.EFFECTIVE_START_DATE,'yyyy/dd/mm') start_dt_spr from per_all_people_f papf, per_All_assignments_m paam, PER_ASSIGNMENT_SUPERVISORS_F pasf,


How Pending Workers Can Help You Manage Your Hiring Process

If you are looking for a way to streamline your hiring process and ensure that you have all the necessary information about your future employees or contingent workers, you might want to consider using pending workers. A pending worker is a person who has a record in the system with a future start date but has not yet been hired or placed as an employee or a


What is a Nonworker?

What is nonworkers and how are nonworker different from employees? In this blog post, we will explain the concept of nonworkers.


Where is the job application flow configured?

If you are a recruiting administrator, you might want to customize the job application flow for your candidates. The job application flow is the sequence of steps that a candidate has to complete when applying for a job on your career site. You can configure the job application flow based on your requirements.


What is the access path for the job requisition template task?

If you are looking for a way to create or modify job requisition templates in your organization, you might be wondering how to access the task that allows you to do so. In this blog post, we will show you the steps to find the task. The access path for the job requisition template task is:


What are the three types of Recruiting Questions in the Question Library?

If you are a recruiter or hiring manager, you know how important it is to ask the right questions to candidates during the hiring process. But what are the right questions? And how can you organize them in a way that makes sense for your hiring process? In this blog post, we will discuss three types of questions that help you to manage your own question bank. These types are:


What are the question types?

If you are creating a survey or a quiz or any question, you might wonder what would be the best question types to use. Let's discuss 4 question types in this blog. 1. Single Choose: This type of question allows the respondent to choose only one option from a list. It is useful for collecting categorical data, such as gender, age, or preference, etc.


How will you migrate the reports in the production instance?

If you need to move your reports from one instance to another, you can use the Archive and Unarchive features. Here are the steps to follow: - In the instance where your report is located, select it and click on the Archive button. This will save your report as a file in your local storage.


How many default Candidate Selection Processes (CSP) are provided?

Candidate selection process default Candidate selection process template


Four groups of notifications in the oracle recruiting cloud

If you are using the Oracle recruiting cloud, you may want to know how to manage the different types of notifications that you can send or receive. In this blog post, we will briefly introduce the four groups of notifications that are available in the Oracle recruiting cloud and how they can help you streamline your hiring process.


Content versions can be created

Content versions can be created in two ways: from scratch or from existing content.


Before creating a position what are the things we need to create?

If you are planning to hire a new employee, you need to create a position first. A position is a set of tasks and responsibilities that an employee performs in your organization. To create a position, you need to define two things before: the business unit and the location.


How to delete the records in HDL Loader?

If you want to remove some data from your HDL Loader, you can use the delete option in your dat file. This will erase the records that match the criteria you specify. Here is how you can do it: 1. Open your dat file in a text editor.2. Find the...


What is the role required to access sandbox?

If you want to test your changes in a non-production environment, you need to create a Sandbox. To do that, you need to have the Application Implementation Admin Role assigned to your user account. Alternatively, you can also access the Sandbox if you have one of these duty roles:


A user is not able to delete the active sandbox

If you are having trouble deleting a sandbox, you might want to check if it is still active. You cannot delete an active sandbox, because it is in use by your current session. To delete a sandbox, you need to exit it first


Client wants to give view only access to a particular user instead of doing any personalization and Customization

If you want to grant view-only access to a user in Oracle Fusion, you can follow these steps: Go to the Setup and Maintenance Click on Task Pane Click on Search Search Manage Administrator Profile Values


What is a matrix manager and how does it work in an organization?

A matrix manager is a type of manager who has a different role than a line manager. A line manager is the direct supervisor of a worker, who can manage their day-to-day tasks and performance. On the other hand, A matrix manager is a manager who has a specific function or responsibility related to the worker, such as managing a project, allocating compensation, or


SQL to get the document type, document type id, category code, sub-category code, and legislation code

Each document type has a unique ID, a category code, a sub-category code, a legislation code, and a creation date The following query will select all the columns from the table and sort them by the creation date in descending order