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
-
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… -
Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaSummary Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaContent Hi Experts, Wondering if there is some documentation around… -
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… -
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). …
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des… -
Setting Permissions on OBIEE analysisSummary Customize access permissions on BI analysis (not BIP)Content When we are setting up permissions on BI analysis, it seems as though even though a user was set wit… -
OTBI Date Prompts in Calendar FormatSummary OTBI Date Prompts in Calendar FormatContent I have added a Presentation Variable(Date Prompt) to my OTBI Report. I am using the prompt to run the report. However…
-
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher … -
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… -
Calculating the Number of Business DaysSummary Count the number of Business Days between 2 datesContent I constantly get requests to provide reporting based on Business Days rather than Calendar Days. Calcula… -
Calculations not working inside pivot tableSummary Using a pivot table to remove multiple rows caues calculations not workContent Hello all, I have an analysis that is pulling from 3 subject areas and is set up t…
-
Custom Profile Content Types in OTBISummary Custom Profile Content Types in OTBI (Workforce Profiles - Person Profile Real Time)Content We have created some custom profile content types in HCM Cloud under … -
Person IdentifiersSummary Person IdentifiersContent Hello, In which subject area (if at all) we can find the " Manage Person Identifiers for External Applications" Thanks, Michal
-
OTBI and Extended LookupsSummary Visa categories' extended names no longer appearing in OTBI analysesContent Hi, has anyone else who records 'Visa Categories' (as Extended Lookups) experienced a…User_2025-01-29-19-59-51-150 91 views 14 comments 1 point Most recent by User_2025-01-29-19-59-51-150
-
HCM Cloud Dashboards for Salary and TurnoverSummary I am looking for HR dashboards for Headcount, Salary, Absence and TurnoverContent I am looking for HR dashboards for Headcount, Salary, Absence and Turnover. I d…
-
Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OSummary Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OTBI AnalysisContent Hi, Do we have a separate 'Worker Number'…
-
Chart Legend ColorsSummary Is there a way to change the chart colors in OTBI?Content I cant find or figure out how to change the colors on my bar chart. Any help would be greatly appreciat…User_2025-01-28-08-47-04-905 55 views 3 comments 1 point Most recent by User_2025-01-28-08-47-04-905
-
Fetching Gross Pay YTD for a terminated employee in BI ReportSummary Fetching Gross Pay YTD for a terminated employeeContent Hi, I am able to fetch Gross Pay YTD till last payroll process date but not after that. I require to fetc…
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…
-
Is there a way to sort a date field by month only?Summary Field format shows MM/DD but sorts by Year. Is there a way to sort/filter by just the month?Content I have created a Birthday report and the date field format re…User_2025-01-28-20-43-56-568 71 views 3 comments 1 point Most recent by User_2025-01-28-20-43-56-568
-
Is there a way to create a sql viewSummary Is there a way to create a sql viewContent We want to create a sql view (e.g. employee hierarchy) and use it in various reports rather than repeat the code in ev…
-
Query related to Job Code and Position NameSummary Query related to Job Code and Position NameContent Hi I would like to know if we can fetch the job code and Position Name in one table. Can anybody share the que…
-
Years in Job calculationSummary How to calculate years in jobContent We are trying to calculate the number of years an employe has been in a specific job, but since there is no "start date" for… -
PTO balance Fast formulsSummary I want to write PTO fast formulaContent Hi All, I am compiling below fast formula /***************************************************************************** …
-
Translate English to Simplified ChineseSummary Need to be able to translate reportContent Hello, Does anyone know of a way to translate reports to any language or what table would have the translations?
-
R13 Performance Management - Comments in CLOB formatSummary Does anyone have a sample report that would show comments in the new CLOB format?Content Hi, all, I'm trying to pull a report that shows sections comments from w… -
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a… -
OTBI report per current detailsSummary Create a report that presenting only the valid dataContent Hi, I'm trying to create a report that will present only the valid assignment, manager, job descriptio…
-
Fusion Role vs Reporting RoleSummary Is there a way to see what the reporting role is for someone's Fusion security role?Content Hi all - when I look at the Fusion roles for our employees, I would l…