Do You Have to Pay Extra to Use Express Mode?
No, you don’t need to pay anything extra to use Express Mode in Visual Builder Studio for Redwood page customizations. It’s already included in your Oracle HCM subscription.
Is Express Mode the Only Supported Customization Method for Redwood Pages?
Yes, Oracle only supports extensibility changes made using Visual Builder Studio (VB Studio) – Express Mode for Redwood pages. Other tools, like Page Composer, are not compatible with Redwood UI. Express Mode is the recommended approach to ensure supportability, consistency, and upgrade-safe customizations.
Are Transaction Design Studio (TDS) Customizations Available in Redwood Pages?
No, customizations done using Transaction Design Studio (TDS) in responsive pages aren't automatically applied to Redwood pages. You must manually recreate those rules using Business Rules in VB Studio to reflect them in the Redwood UI.
Do I Need to Recreate Page Composer Changes in VB Studio for Redwood UI?
Yes, if you're moving to Redwood UI, all extensibility changes made using Page Composer on responsive pages must be rebuilt using VB Studio Express Mode. Since Page Composer is not supported on Redwood pages, VB Studio has become the standard tool for making UI customizations in the new experience.
Is Page Composer Available for Redwood Pages in Oracle HCM?
No, Page Composer is not available for Redwood pages. Page Composer is only applicable for responsive pages (non-Redwood UI). For Redwood pages, Oracle recommends using Visual Builder Studio (VB Studio) – Express Mode to make UI customizations and enhancements.
SQL Query to Retrieve Goal Plan Assignment Details for Employees
This query retrieves key information related to Goal Plan Assignments, including Goal Plan Assignment ID, Goal Plan ID, Assignment ID, Goal Plan Name, and Person Number. It filters the results for a specific goal plan and ensures the correct language translation is applied.
SQL Query to Retrieve All Security Profiles Assigned to Roles in Oracle HCM
This SQL query retrieves all Security Profiles (Person, Organization, Position, Country, LDG, Payroll, etc.) assigned to specific Data Roles in Oracle HCM. It helps in understanding how access control is structured based on roles and which security profiles are mapped for each role.
How to Identify Duplicate Email Addresses in Oracle HCM
To identify employees with duplicate email addresses in Oracle HCM, use SQL to group records by email address and filter those appearing more than once. This helps ensure data quality and prevents email-related issues in communications and integrations.
How to Upload Person Address with Custom Address Type using HDL
If you're facing issues while loading Person Address data via HDL, especially with custom address types—ensure that you're using unique Source Keys or a unique combination of Source System Owner and Source System ID.
Troubleshooting Errors in "Process HR Checklist" and Using HDL to Re-initiate Tasks
When the "Process HR Checklist" fails to allocate tasks due to an error, it is essential to check the log for error messages and fix the root cause. As a workaround, If you want to assign the checklist manually, like using HDL, please follow the mentioned steps.
Changing Person Number Using HCM Data Loader (HDL)
If you're unable to change the Person Number through the UI, you can use HCM Data Loader (HDL) to update the person number.
SQL Query to Identify Employees Without a Profile Code
This query retrieves distinct person numbers from Oracle HCM where the employee exists in the profiles table but doesn't have a profile code assigned. It helps identify incomplete or missing profile information for cleanup or data validation purposes.
How to Identify the Seniority Date Version in Oracle HCM
To find the seniority date version in Oracle HCM, query the PER_SENIORITY_DATES_SETUP table along with HCM_LOOKUPS to get the seniority date code, its meaning, and the corresponding version. This helps ensure accurate tracking of employee service calculations.
How to Identify If Rich Media is Enabled in Your Oracle HCM Environment
To determine if Rich Media services are enabled in your Oracle Fusion environment, you can query the ASK_DEPLOYED_APPLICATIONS table. This helps verify the deployment of services like video storage, transcoding, and content delivery.
Data Loader Support for Creating Anytime Feedback (Person Notes)
Oracle HCM supports the mass creation of anytime feedback using HCM Data Loader. This enables users to upload feedback on behalf of others efficiently by assigning a different author and streamlining inputs from external sources.
HCM Tree Types – Overview and Examples
In this blog, we will understand the HCM Trees that are Managed in Workforce Structures under My Client Groups; tree types include department, organization, position, and geography. You can create multiple trees and versions (except for geography), but only one is active. Each tree starts with a root node, with parent-child relationships forming the structure. For example, in a Department Tree, Operations is the parent of HR, Legal, and Finance.
Overview of Role Provisioning and Deprovisioning with an example
Role provisioning in Oracle HCM assigns roles to employees automatically or manually based on their responsibilities. Automatic provisioning uses predefined rules, while manual provisioning allows administrators to assign roles individually. Deprovisioning revokes roles when no longer needed, such as during role changes or employee exits. Effective role management improves security, compliance, and operational efficiency by controlling access to sensitive data.
How to get the AOR details, which person has assigned which Areas of responsibility using SQL Query
This query retrieves employee assignment and Area of Responsibility (AOR) details, including Person Number, Name, Assignment Number, AOR Type, Scope Value, Responsibility Name, Scope Name (Business Unit, Department, or Legal Entity), and Responsibility Status. It joins assignment, person, responsibility, and organizational data while ensuring active and current records are displayed.
Understanding User Name Management in Oracle Fusion HCM Cloud
In Oracle Fusion Cloud Human Resources, managing user names is an essential part of ensuring a smooth login experience, secure access, and proper system integration. Oracle provides flexible options to configure how user names are generated and maintained, helping HR and IT teams align identity management with business needs. Here’s a quick overview of how user name management works in Oracle HCM and some best practices to keep in mind.
Oracle HCM ContentItem HDL and SQL Mapping for Certification Items
This document provides the HDL template and SQL query for extracting and loading Content Items related to Certifications in Oracle HCM Cloud. It maps fields such as ContentItemCode, ItemDescription, ContextName, and ContentTypeId from HRT_CONTENT_ITEMS_B, HRT_CONTENT_ITEMS_TL, and HRT_CONTENT_TYPES_B to the ContentItem.dat HDL format used for data migration or integration.
Categories
- All Posts
- 01. Common for all modules
- 02. Questionnaire For Client
- Absence Management (DEFINITION)
- Absence Management (HDL Templates)
- Absence Management (ISSUES)
- Absence Management (REQUIREMENT)
- Benefit Management (DEFINITION)
- Compensation Management (DEFINITION)
- Compensation Management (FAQ)
- Compensation Management (ISSUES)
- Fast Formulas (FF)
- Global Human Resource (DEFINITIONS)
- Global Human Resource (FAQ)
- Global Human Resource (HDL Templates)
- Global Human Resource (ISSUES)
- HDL Templates (Data Loader)
- Human Resource Helpdesk (DEFINITION)
- Journeys (FAQ)
- Oracle Learning Cloud (DEFINITION)
- Oracle Learning Cloud (FAQ)
- Oracle Learning Cloud (HDL Templates)
- Oracle Learning Cloud (ISSUES)
- Oracle Payroll Cloud (HDL Template)
- Oracle Recruiting Cloud (DEFINITION)
- Oracle Recruiting Cloud (FAQ)
- Oracle Recruiting Cloud (ISSUES)
- Oracle Time and Labor (DEFINITION)
- Oracle Time and Labor (ISSUES)
- OTBI Report
- Redwood_Visual Build Studio_RWPHT (DEFINITION)
- Redwood_Visual Build Studio_RWPHT (FAQ)
- Redwood_Visual Build Studio_RWPHT (ISSUES)
- Spreadsheet Loaders (HSDL)
- SQL Queries (SQLQ)
- SQL Queries + HDL Template
- Talent Management (DEFINITION)
- Talent Management (FAQ)
- Talent Management (HDL Templates)
- Talent Management (ISSUES)
- Technical Contents (DEFINITION)
- Touchpoints (DEFINITION)
- Touchpoints (FAQ)