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
-
Report on Active Employee count as of dateSummary I need a report that provides me an active employee (Active & LOA) as of start of each monthContent Hi, This is Shailesh. When I look at the counts from 'Workfor… -
End of Year Active AssociatesSummary List of employees that were active the last day of last yearContent I have tried this every which way to Sunday and I can not get the right amount of employees. … -
Question about Worker -> Parent Manager fieldsSummary Question about Worker -> Parent Manager fieldsContent I have a question on how the data in the parent manager fields (Parent Manager 1, 2, etc.) gets populated. … -
Resizing for banner on R13Summary Banner gets trimmed based on device you're onContent We are testing our R13 upgrade right now and noticed the banner (which we put a logo and some stock images) …
-
Reference Number in BI Publisher ReportSummary How to capture unique reference number for BIP report when you run each timeContent Hello Experts, We have BI publisher report (HR Letter) report like No Objecti…
-
Assignment Status Reporting IssueSummary Assignment Status Reporting IssueContent Hi All, I am building a Global Payroll Transfers Report in OTBI with the SA "Workforce Management - Worker Assignment Ev…User_2025-07-18-02-05-33-261 58 views 4 comments 0 points Most recent by User_2025-07-18-02-05-33-261
-
make infolets available based on the user's roleContent Hello, We are using infolet in production but we don't have find a way to display those depending of the user's role. Most of the infolet (in example) are used t…
-
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 201 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058
-
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…
-
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it…
-
-
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar… -
Unable to get the from email address in BurstingContent Hi All, In the bursting query for the parameter3 value we are passing "bipublisher-report@oracle.com" and able to get the email after report submitted. If we use…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766
-
GL Costing Information for the Elements - OTBISummary Element Costing Configuration - OTBIContent Hi All, Where can i find GL Costing Information for the Elements? I need to report Costing account codes for all the …User_2025-07-18-02-05-33-261 131 views 12 comments 1 point Most recent by Venkateswara Rao Vadlamani
-
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…
-
Hire/Seniority DatesSummary How do I report on these dates in OTBI/BIP?Content Hi all - I know that Julian had a great post about what the individual dates are (https://cloudcustomerconnect… -
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Performance Management Comments in OTBISummary Performance Management: Competency comments and Overall comments in OTBIContent Hello, I have realized a custom report to extract Performance Management competen…
-
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Turnover Formula AssistanceSummary Building a turnover % by termination typeContent Using a CASE formula I have identified and split out terminations by our company's preferred type, desired and u…User_2025-01-28-08-47-04-905 69 views 3 comments 0 points Most recent by User_2025-01-28-08-47-04-905
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…
-
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…User_2025-01-28-21-18-43-496 527 views 10 comments 1 point Most recent by User_2025-01-28-21-18-43-496
-
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 …