If the approval rule is by-passed then comments and attachment sections will not display. We need to keep the approval rule active to see comments and attachment sections.
[[ (new Date(new Date().setFullYear(new Date().getFullYear(), new Date().getMonth(), new Date().getDate()))).toISOString().substring(0, 10) ]]
This query compares the current and previous names and business units of selected positions as of a given effective date. It identifies the most recent updates to each position, showing when changes occurred and what the previous values were. This helps track organizational structure changes and supports audits or reporting on historical position movements.
This query returns the job and position grades for active primary employees from a given list. It uses current effective dates and joins assignment, job grade, and position data to show both the directly assigned grade and the default grade from the position. Ideal for identifying grade mismatches or validating employee grading structures in real time.
This query fetches active employees' current assignment and position names. It ensures records are current by checking effective dates and filters for primary, active employee assignments only. The output includes person number, assignment name, and position title—helpful for real-time reporting or validating workforce structure.
In Oracle Visual Builder Studio (VBS), you’ll often see “Local Branch” and “Remote Branch” when switching branches. This post explains what they mean, why only some branches show as local, and how your changes get saved. In simple terms, local means it's in your workspace, and remote means it's on the server for everyone. Learn how it works and what to do when switching or pushing changes.
A custom validation was incorrectly triggering on the Continue button in the Individual Compensation section, even when no entry was made. The issue was caused by a rule enforcing the Amount field regardless of user intent. The solution updates the rule to check if a Plan is selected before validating Amount, ensuring the error only appears when a compensation entry is actively being added—not when skipping the section.
This query provides details of approval tasks configured in the HCM module, including task names, categories, subcategories, and their current status as enabled or bypassed. It helps identify how approvals are managed across different functional areas, offering insights into business process governance and compliance within the system.
This SQL query generates a real-time report of employee-to-manager relationships, showing the latest active assignments and display names for both. It ensures only current, primary records are included and supports filtering by manager or employee person number. The output highlights each employee’s reporting line, including their manager’s name, assignment status, and a unique sequence number for easy reference—ideal for auditing and organizational reporting.
This SQL query fetches detailed assignment information for a specific assignment ID in Oracle HCM Cloud. It ensures only active and primary assignments are retrieved by checking current effective dates and assignment status. The query joins key HCM tables including people, names, assignments, and periods of service to return the person number, assignment ID, work terms ID, and period of service ID, making it ideal for validating or enriching assignment-related data.
This SQL query retrieves the latest active and primary assignments for a list of person numbers in Oracle HCM. It splits comma-separated input values, filters data based on current effective dates and active statuses, and ensures only the most recent assignment per person is selected. The final output includes a sequence number, person number, assignment ID, work terms ID, and period of service ID in the original input order.
This query determines whether an employee's service record represents a Hire or Rehire based on multiple periods of service. It returns key dates like Hire Date, Rehire Date, and their corresponding Termination Dates, helping you track reemployment history. Use it to analyze employee rejoin patterns or verify compliance during audits and onboarding processes.
This SQL query helps HR teams extract essential details of terminated employees in Oracle HCM Cloud. It fetches person numbers, names, actual termination dates, rehire recommendations, and the usernames of users who submitted the terminations. By accepting a comma-separated list of person numbers as input, it filters and returns accurate, timely results for audit, rehire evaluation, or reporting purposes.
Now, without IT Security role, you can identified what all roles you have assigned and when this roles has assigned to you, and also who has assign this role to you user account.
If you don't have the security role assigned, no worries, now you have the access to do the role comparison between two users using SQL query.
In Redwood-based Locations, Departments, Jobs, and Positions search pages, export functionality was previously limited, exporting only partial results. With this update, all filtered results up to the maximum limit of 11,000 records will now be exported, improving data access and user experience.
This SQL query retrieves the home address details of all active US employees. It selects employee numbers, full names, assignment numbers, assignment status, and complete address details (address lines, city, state, postal code, and country). It joins PER_ALL_PEOPLE_F for employee data, PER_PERSON_NAMES_F for names, PER_ALL_ASSIGNMENTS_M for assignments, and PER_ADDRESSES_F for address details. The query filters active assignments with home addresses in the US.
The Country label in the Demographic Info region on the Redwood Personal Details page has been changed to Country for Demographic.
The Automatic Duplicate Check in Oracle Recruiting Cloud can be configured at any phase or state of the Candidate Selection Process. Administrators can set the system to trigger duplicate checks automatically when a job application reaches a specific state within a phase, helping ensure data integrity and prevent duplicate candidate records throughout the recruitment workflow
A requisition cannot be posted directly to a job board without being posted on the career site. This policy ensures that all job openings are consistently available on the company’s primary career portal before being distributed to external job boards, maintaining centralized job management and compliance with internal processes.