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
-
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man… -
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo… -
EEO-1 Report - R13Summary DUNS Number does not fit in field on reportContent Hello Community, The DUNS number on the delivered EEO-1 audit report in R13 does not fit and is cut off. In R1… -
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
SQL Expression for a specific month and day with a year of current year - 1Content Hi - I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of t…
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d… -
Weight updated from PerformanceSummary table of weight updated by PMContent Hi, I need to export the weight field about a goals that you can define from Performance Section. Could you please help me? …User_2025-01-28-21-18-09-074 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl…
-
Cross Subject Area Dashboard OptionSummary Need to join multiple subject area for dashboard purposesContent Hi, I apologize in advance if this is already discussed in some previous thread- if that is the …
-
OTBISummary in otbi how to get the count of same salaried employeesContent Hi, in otbi how to get the count of same salaried employees. -
Payroll Activity ReportSummary Page breaks in Payroll Activity ReportContent Hello, It would be really nice if the payroll activity report could page break between person. I think it would mak…
-
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno…
-
Lost 'Add subject area' functionality in OTBISummary Lost 'Add subject area' functionality in OTBIContent Hello, Since this morning, we lost icon that lets you to add additional subject-area during report creation.… -
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the … -
Absence leave duration issueContent Hi, I am unable to get the correct leave duration in the analysis , employee has applied for 0.5 days leave , but in the analysis it is showing as 1 day , I have…
-
CONCAT Area Code and Phone NumberSummary I want to combine an employees work, home, and cellular phone number so area code isn't a seperate columnContent Using this forum topic https://cloudcustomerconn…User_2025-01-28-08-47-04-905 132 views 5 comments 0 points Most recent by User_2025-01-28-08-47-04-905
-
Creating a Filter Based on Staff with Multiple Rows of Data in AnalysisSummary Creating a filter that will only produce records when an employee has more than one row on the reportContent Hi- I'm working on building a report to focus specif… -
User Audit RolesSummary Can we report on roles removed?Content Hi all - I have seen multiple postings about how to report on what a user has for roles, but those are current roles. Is i… -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…
-
DBI Item for Representative of an employeeSummary DBI Item for Reprensentative of an employeeContent Hi All, I want to know is there any DBI item for Representative of employee based on position. Thanks RatnakarUser_2025-01-30-22-34-07-335 35 views 2 comments 0 points Most recent by User_2025-01-30-22-34-07-335
-
Possiblity of creating a Report which has a combination of data column from two different source oneSummary Possiblity of creating a Report which has a combination of data column from two different source one SQL and other static data (say excel Spreadhseet, XML, CSV..… -
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 145 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Best Practice for text formattingSummary Building and exporting reports with text fieldsContent In building out a report around goals we're encountering issues with exporting the data. If we export the …User_2025-01-28-08-47-04-905 49 views 4 comments 1 point Most recent by User_2025-01-28-08-47-04-905
-
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 65 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 43 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644
-
Creating a drill down report from a pie chartSummary Want to have ability to click on a pie slice and have it open to details.Content I have created a Goals Status report. I would like to have the ability for someo…User_2025-01-28-20-43-56-568 46 views 6 comments 0 points Most recent by User_2025-01-28-20-43-56-568
-
"Private" goal measure in Goals reportsSummary TRying to identify the right measure to use in an analysis to show private goalsContent Hi there, in OTBI I'm trying to create a Goals reports by creating an ana…
-
Show those with No Goals in a Goal ReportSummary Creating a report which shows those with no goals in a particular goal planContent I'm looking to create a report that shows a count of goals for users along wit…User_2025-01-22-19-54-00-543 92 views 4 comments 0 points Most recent by User_2025-01-22-19-54-00-543
-
OTBI Analysis- Column PropertiesContent I have created an OTBI analysis based on Workforce Performance - Performance Rating Real Time subject area. Requirement is to review employee goal and competenci…