Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Creating OTBI report with employee termination detailsContent I need to create a OTBI report to get employee termination details. I used Workforce Management - Work Relationship Real Time subject area but after release 13 c… -
Salary Currency field causing error on reports in R13Summary Compensation Reports error out. Determined caused to be related to Salary Currency field.Content I have two Compensation Reports that error out. I determined the… -
Location of Worker Availability seeded report in BIContent The Worker Availability report is visible by default on the Manager Resources Dashboard. As of R12 this dashboard is not enabled by default, as the patch notes s… -
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C… -
OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptSummary OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptContent Hi, I have a scenario where I need to add 2 dates on to the d…
-
OTBI Analysis, Action Links in OTBISummary Not able to create link through Action Links in OTBI AnalysisContent Hi I am trying to create an analysis in which I am using two subject areas "Workforce Manage…
-
What is the best way to create an audit report on employee salary and direct deposit changesSummary This audit report includes employee salary changes, direct deposit distribution changes, and security role changes made by users in two specific roles.Content We…
-
OBTI Analysis Comparing DatesSummary I am not able to compare dates in analysisContent "Hi, I am trying to perform a query which i think should be easy but i'm suffering from just looking at it for …
-
BIP BurstingSummary Image in RTF Template received as attachment in emailContent Hi, We have a requirement to have company Logo and some images in the email notification, which will… -
Oracle HCM Cloud Report documentationContent Hi all, as of Release 10, there was some excellent documentation on the shipped reports here: https://docs.oracle.com/cloud/farel10/globalcs_gs/globalcs_report.h… -
Setting the As Of DAte in Compensation - Salary Details Real TimeSummary Looking for a list of Subject Areas where a Prompt may NOT be used to set the effective dateContent Hello, I have used the instructions that are attached to effe… -
Delivering OTBI Analysis on a specific day to a specific person's dashboardSummary Delivering OTBI Analysis on a specific day to a specific person's dashboardContent Hi I want to fetch the details of the employees which have the end date of the…
-
Display Bin even with zero resultsSummary Is there a way to still include a Bin in the analysis output with zero results?Content Hello, I have an analysis where I am using Bins to count employees by age … -
Cross Reporting across Legal EntityContent Hi All, I would like to know if in Oracle Fusion HCM Rel 13 ,cross reporting can be met or not! For example CHRO's of multiple legal entity (in our case 9) repor…
-
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…
-
Fast formula - Assignment History detailsContent Hi all, I need to export into a compensation worksheet the Last Updated Date from assignment history (please, see attachment) when it's been changed the custom f…
-
How to add Lead reviewer id in performance task status reportSummary Need to add Lead reviewer id in performance task status report along with nameContent We have added Performance Document Manager from Performance Task Status Det…
-
Fast formulas - standard fields & content typeContent Hi all, In order to build fast formulas, I'm lookig for the dbi for that standard fields: * PER_PERIODS_OF_SERVICE.ORIGINAL_DATE_OF_HIRE * PER_ALL_ASSIGNMENTS_M.…
-
OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filtSummary OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filters)Content HI, OTBI Analysis: Can I do a Analysis A - Analys…
-
Release 13 - 50000 cell limit in BI Answers??Summary Our reports no longer can export the data they need!Content Hi all, Following our upgrade of release 13 there seems to be a limit on 50000 cells exported, we hav… -
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' … -
BI Folder Structure: R12 vs. R13Summary BI Folder Structure: R12 vs. R13Content We're testing our recently upgraded pod and noticed that the folder structure that shows in Reports and Analytics is very… -
Possible to embed link to run a report, inside a Dashboard pageSummary Embed link to run a report, inside a Dashboard pageContent We have a request to embed a link in a Manger's Dashboard that will allow them to run a pre-built repo… -
OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format)Summary OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format) should come up.Content Hi, I have a OTBI analysis where I ha…
-
Gauge/Dial Chart AssistanceSummary Creating a gauge chart within OTBI with custom thresholdContent I'm looking to build a simple gauge capturing capturing the average number of days it takes our H…
-
Enabling and adding custom reports to the My Team > Goals reporting paneContent I want to enable goal reports for managers and allow the managers to access specific links to analysis and/or dashboards through the reporting pane at "My Team >… -
Exceeded Maximum Results Error when adding a promptSummary Any way around this?Content I'm looking to build out a trend report, using the WF Trend Subject area, which will allow the user to select a manager via a prompt …
-
How to give incremental Sequence in a Bi ReportContent Hi, I have requirement to create position report where I need to give sequence number like 1,2,3 etc. What need to used in data model to achieve this in BI publi…
-
-
OTBI: YTD Values in Payroll Balances Subject AreaSummary OTBI: YTD Values in Payroll Balances Subject AreaContent Hi, Is there a way we can display the YTD Balance values from the "Payroll Balances Real Time" Subject A…