Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i… -
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…
-
Assignment HistorySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su… -
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay Content (please ensure you mask any confid… -
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…
-
Looking for Issue description and resolution querySummary: Content (please ensure you mask any confidential information): Dears , I am working on a query to get issue description and resolution , I found them but I coul…
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi… -
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the… -
effective date dashboard promptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
extra "NULL" checkbox in the dashboard promptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to make HCM Line Manager Dashboard available to HR Admin Roles ?Currently Line Manager Dashboard works only for its direct and indirect reports. We want it to execute under the Data Security of HR Admins, so that they can see data fo…
-
Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.
-
sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,
-
How to report on reverse termination?Summary: Trying to report on reverse termination, but I get no results We are sruggling to document reverse terminations performed by our costumers in HCM, since in the … -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b… -
TABLE/SQL FOR TIMECARD CUSTOM ATTRIBUTESSummary: There are 2 custom attributes created in Time and Labor under Time Layout Sets and it shows in the UI. Time Layout Sets. When entering timecard What specific Or… -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…
-
How do I join WLF_SKILL_CENTER_ITEM_DN to WLF_ASSIGNMENT_RECORDS_F?Summary: In HCM work life, I need to join a skill name to an assignment. WLF_SKILL_CENTER_ITEM_DN has SKILL_CENTER_ITEM_DN_ID and PROFILE_ID as possible keys to join to …