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
-
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' … -
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… -
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…User_2025-01-25-02-53-28-953 50 views 5 comments 2 points Most recent by User_2025-01-25-04-02-13-126 -
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 Formula - EFF multiple rowsSummary how to call an EFF multiple rowsContent Hi all, I need to override a value in compensation worksheet through fast formula. The value is an extensible flexfield w…User_2025-01-28-21-18-09-074 79 views 3 comments 0 points Most recent by User_2025-01-28-21-18-09-074
-
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: 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…
-
OTBI: Need to display ratio between 2 analysis in a dashboard page.Summary OTBI: Need to display ratio between 2 analysis in a dashboard page.Content Hi, We have analysis 1: All Employees Head Count Analysis 2: HR Employees Head Count W…
-
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 >… -
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…
-
50,000 Cell Excel Export limit from OTBIContent My current client's Pods seem to have a 50,000 cell limit on exports from OTBI into Excel. I've never come across this restriction with previous clients, and for…User_2025-01-25-01-23-28-110 177 views 8 comments 1 point Most recent by User_2025-01-25-04-02-13-126
-
OTBI Date DifferenceSummary Attempting to determine the number of days between record update and record effective dateContent I have reviewed other posts related to date difference within C…
-
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…User_2025-01-31-01-21-22-432 102 views 2 comments 0 points Most recent by User_2025-01-31-01-21-22-432
-
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere… -
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …
-
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
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an…
-
QR Code Integration in BI Publisher ReportsContent Hello Experts: Could anyone please confirm if QR Code integration is done earlier for BI Publisher, or any other type of reports. If Yes, what is the process to … -
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…User_2025-01-22-19-51-06-974 38 views 2 comments 0 points Most recent by User_2025-01-22-19-51-06-974
-
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…
-
R13 Workforce Performance - Performance Rating Real Time subject Area issueContent Hi I am getting below error in R13 while running the OTBI report, but not in R12. ERROR : Runtime error for service -- ADFService11G - JBO-25002: Definition HcmT…
-
Default Presentation Variable Prompt to AllContent Hello Customer Connect community, Is there a way to default a presentation variable to default to all? I am using the following syntax in my logical SQL: AND Cou…User_2025-01-22-19-43-38-766 110 views 5 comments 0 points Most recent by User_2025-01-22-19-43-38-766
-
Duplicate Rows in a ReportContent Hi All, Hoping someone can assist me - I'm getting duplicate rows in a report and it seems to be tied to FLSA status as I have one row with a value and one row w…
-
User_2025-01-30-21-33-03-247 263 views 4 comments 0 points Most recent by User_2025-01-30-20-59-13-989
-
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…User_2025-01-28-08-47-04-905 26 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
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 …
-
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…
-
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… -
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…