Oracle Recruiting Cloud, part of Oracle Fusion Human Capital Management (HCM), streamlines talent acquisition with tools for sourcing, engaging, and hiring candidates globally. Below is a concise list of key terminologies specific to Oracle Recruiting Cloud, with their meanings and system context, emphasizing integration with talent management processes like Oracle Learning Cloud.
Oracle Learning Cloud, a module within Oracle Fusion Human Capital Management (HCM), is designed to manage employee training, skill development, and compliance learning across global organizations. It supports personalized learning experiences, tracks progress, and aligns training with career goals and organizational needs. Below is a concise overview of key terminologies specific to Oracle Learning Cloud, with their meanings and system context, focusing on talent management integration.
In Oracle Fusion Human Capital Management (HCM), Talent Management refers to a set of integrated processes and tools designed to attract, develop, engage, and retain employees to meet organizational goals. It encompasses modules like Goal Management, Performance Management, Career Development, Succession Management, and Talent Review, each using specific terminologies aligned with global HR standards.
Oracle Fusion Human Capital Management (HCM) is a cloud-based HR solution that incorporates global HR processes with standardized terminologies tailored to its modules. Below is a concise list of key global HR terminologies as they apply within Oracle Fusion HCM.
This SQL query retrieves active employee assignment details (person number, assignment status, and assignment number) from HR tables. Only active employee assignments ('E' type) are included.
We've turned on the Redwood Personal Information pages, and as a result, HR Specialists are finding that when they try to look at other employees' "Identification Info," they’re greeted with a blank screen. They have no trouble seeing their own data via the "Me" section or "My Client Groups," but attempts to view others’ details lead to an empty display. What exact permissions are required to access other employees’ identification information within "My Client Groups"?
Get the person number, assignment id, workterm assignment id, and per period of service id
An employee's role was updated to a full-time, remote position within a business unit. The change, prompted by a positional shift, allows for remote work and follows a standard weekly schedule. The update adjusts long-standing work terms and assignment details, reflecting a significant, ongoing modification to employment conditions.
Oracle Journeys is revolutionizing the employee experience within Oracle Cloud HCM. From guided and contextual experiences to advanced task types and recurring journeys, the latest enhancements simplify complex HR processes and empower both employees and administrators.
This SQL query retrieves distinct records of employees along with their names, supervisor names, and the department name of their managers. It joins person, assignment, supervisor, position, and organization tables, filtering for active and primary employee assignments. The query ensures only current effective records are included, providing a snapshot of reporting relationships and organizational hierarchy.
This SQL query fetches details of employees with the "Housing Allowance Deduction" element in Oracle HCM. It joins people, assignments, element types, entries, and payroll usage tables to list person number, assignment number, element name, and effective dates. The query filters based on active date ranges and ensures accurate linkage between element entries and payroll assignments.
This SQL query extracts detailed user account and role assignment data from Oracle HCM, including person number, name, user account status, and role assignment status. It uses multiple joins across PER_ALL_PEOPLE_F, PER_USERS, PER_USER_ROLES, and related role definition tables to determine if the user's role is active, terminated, or in a transitional state, providing a complete picture of user-role associations.
For adding custom content like links or dashboards in Redwood, Oracle recommends using Guided Journeys. Advanced Mode in Visual Builder Studio should be used only for specific documented use cases. To help with migrations, the Redwood Customization Helper Tool is available to track and migrate existing customizations.
Express Mode in Visual Builder Studio is your go-to for customizing Redwood pages in Oracle HCM. It helps you control page layout, behavior, and visibility using Business Rules and Page Properties—all without writing code.
Redwood pages in Oracle HCM are getting a significant upgrade. Instead of using Page Composer or Transaction Design Studio, all customizations now happen through the new Visual Builder Express mode—bringing everything into one powerful tool.
This SQL query returns a unique list of usernames, person numbers, role names, role codes, and departments by joining person, user, role, assignment, and department tables in Oracle HCM. It filters for primary employee assignments and ensures only active records in the current date range are included. This is ideal for user access audits, HR reporting, and department-level role mapping.
This SQL query lists all roles assigned to a specific user in Oracle HCM, including user status, role status, person number, full name, role name, common name, creator, and creation date. It joins PER_USERS, PER_USER_ROLES, PER_ROLES_DN, and PER_ROLES_DN_TL, filtering by the username. Useful for access audits, role validation, and security reviews.
This SQL query fetches UK-specific bank branch details from CE_BANK_BRANCHES_V, including the branch name, bank name, branch number, and SWIFT code. It filters records where BANK_HOME_COUNTRY = 'GB' and sorts results by bank name and branch name. Ideal for payroll configurations, payment method validations, and financial reporting.
This SQL query retrieves a list of bank names from the CE_BANKS_V view in Oracle HCM for banks located in the United Kingdom (HOME_COUNTRY = 'GB'). The results are ordered alphabetically by bank name, making it useful for payroll setup, validations, or user interface dropdowns.
This SQL query retrieves active grade names and their corresponding grade codes from Oracle HCM. It joins PER_GRADES_F and PER_GRADES_F_TL, filters for U.S. English language entries, active grades (ACTIVE_STATUS = 'A'), and ensures the grades are valid as of the current date. The output is sorted by grade code, making it suitable for payroll, HR analytics, or data mapping.