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.
This SQL query extracts a detailed list of positions in Oracle HCM, including position name, business unit, department, job name, job code, and grade. It joins HR_ALL_POSITIONS_F, PER_JOBS_F, PER_GRADES_F, and organizational unit tables, filtering active records based on SYSDATE. The result offers a complete view of position attributes for reporting or auditing purposes.
This SQL query fetches a current list of job names and their corresponding job codes from Oracle HCM by joining PER_JOBS_F_TL and PER_JOBS_F. It filters for active jobs (based on the current date and effective date range) and selects only records in the English language (LANGUAGE = 'US'). The output is sorted by job name and job code for easy reference.
This SQL query retrieves content item codes and names from Oracle HCM for specified context types such as Certifications, Training, Skills, and custom-defined types. It joins HRT_CONTENT_ITEMS_B, HRT_CONTENT_ITEMS_TL, and HRT_CONTENT_TYPES_B to display content items along with their associated context names, enabling efficient classification and reporting of workforce qualifications and competencies.
To enable seamless integration between Oracle Cloud Applications and Oracle Visual Builder (VB) Studio, specific Oracle roles must be mapped to corresponding VB Studio IDCS roles. Administrators (e.g., Application Admin, HCM Admin) should be assigned the DEVELOPER_ADMINISTRATOR role in VB Studio. Developers, including those with sync-enabled roles, should be mapped to DEVELOPER_USER for standard access and development tasks.
This list outlines essential terms related to Oracle Redwood Pages, Visual Builder Studio (VBS), and the Redwood Personalization Helper Tool. It includes key concepts like Redwood UX, VBS workflows (Git, pipelines), and personalization elements (component IDs, JSON payloads), helping users understand and manage modern UI customizations in Oracle HCM.
This SQL query fetches active lookup values from Oracle Fusion’s common lookup types, including lookup type, code, meaning, tag, and application name. It filters based on specific lookup types like TITLE, EMAIL_TYPE, and SEX, and ensures only enabled and date-effective values are returned in the user’s current session language.
This SQL query fetches all profile items associated with a specific person number (e.g., 7662) in Oracle HCM. It returns the profile code, content type, content item name, active date range, and audit details such as creator and last update information. Useful for analyzing worker skills, competencies, certifications, or qualifications stored in Talent Profile data.
This SQL query retrieves detailed message logs for a specific HDL (HCM Data Loader) upload using the UCM_CONTENT_ID. It joins message lines with related business object and data set tables to provide insight into successes, warnings, and errors during the HDL process. Replace 'UCMFA03221083' with the relevant content ID to check specific load results.
This SQL query detects employees whose termination has been reversed in Oracle HCM Cloud. It compares versions of PER_PERIODS_OF_SERVICE records, identifying those with earlier entries showing a termination date and later updates removing it. The query returns the person ID, last update date, and person number of affected employees.