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
-
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…
-
Hiding condition name from the prompt of the dashboard reportSummary Hiding condition name from the prompt of the dashboard reportContent Hi Experts, I am facing an issue on hiding condition name(BETWEEN) from the Prompts of the d…
-
Handling data field containing a comma while generating CSV files using etext templates in BI PublisSummary Handling data field containing a comma while generating CSV files using etext templates in BI PublisherContent Hi, I have an etext template to create a .csv (com…
-
Can we use run time parameter in Bursting?Summary Email BurstingContent Hi Everyone, Can we use parameter in bursting like we use in our sql. Regards, Poornima Paliwal
-
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…
-
After Upgrading to R13 Prompts and Filters on Certain Fields Causing Reports to Error OutContent After upgrading to R13, several reports have stopped running as expected. We have narrowed it down to certain prompts and filters in the report. For instance, we…
-
How to receive assignmentId from Compensation Page & pull out Legal Employer based on itSummary How to receive assignmentId from Compensation Page & pull out Legal Employer based on itContent Hi guys, we are facing an issue related to compensation page. In …
-
Using Concatinate for select valuesSummary Using Concatinate for select valuesContent Hello! I am trying to concatenate a couple of fields, but there are certain "Job"."PER_JOBS_DFF_CNTRBTR_TYP_LFL_" valu…
-
Areas of Responsibility assign to workers- how can we pull data in reports?Content Hello, If someone can share his knowledge regarding how can we pull the data - responsibilities assigned to workers? we want to track the employees's areas of re…
-
Bar Chart SortingSummary Is there a way to sort the horizontal color axis by the measure?Content Is there a trick to getting a chart to sort when adding color to the horizontal axis? I h…
-
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu…
-
Filtering Based on Phone TypeSummary Need to show only results for work phone but also want to pull in those who do not have a value.Content I am trying to create a report which will pull various da…
-
OTBI Drill down to transactional recordSummary OTBI Drill down to transactional recordContent Is there any way we could drill down from an OTBI analysis to the transactional record to take some corrective act…
-
Scheduler Account LoginContent Hi all - we have a problem we are hoping you can assist :) Right now, we have a few developers that will schedule reports. However they are the only ones that ca…
-
Scheduled processes reportSummary need to create a report to show all our scheduled processesContent hi, we have a lot of Scheduled processes who run every day. need to create a report showing al…
-
TERMINATION - ACTION REASONContent Hi, I am writing a report in BI, to bring the details of the terminated employees. One of the columns is Action reason, such as Dismissal, Layoff, Quit Wondering…
-
How to track Single-Choice Question Answers ?Content I need to get the answers given to the set of single choice questions. I have created an analysis using Workforce Performance - Performance Rating Real Time > Qu…
-
FTP using PPKContent Hi all - need your help on this one! I am not overly familiar with using FTP, but can muddle my way through when using a regular set-up (host, login, password). …