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
-
How to create a Report with trend and costing dff details?Summary How to create a Report with trend and costing dff details?Content Hello , In reports OTBI type , the purpose was to get the cost trend details and also the cost … -
Delivered Reports/Dashboards - Security ConcernsSummary Delivered Reports/Dashboards - Security ConcernsContent Hello, We are currently implementing and discovered today that delivered reports contain some sensitive i… -
Cross posting this idea in HCM Reporting and Analytics forum - ability to Audit OTBI report configuSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t… -
How to fetch LE Setup in OTBISummary How to fetch LE Setup in OTBIContent Hi Team, Can we fetch LE setup details using OTBI tool in oracle fusion HCM? The fields that need to be fetched are Code, Na…
-
Need help on Employee Personal Contribution report buildSummary Need help on Employee Personal Contribution report buildContent Hi Team, We are in the process of developing a report that report will be used to identify employ… -
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…
-
How to create XPT templateSummary How to create XPT templateContent How can we create XPT template outside Oracle BI Publisher tool and then upload it to a report? Without using the online templa… -
HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D.Summary HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D. BI version is Oracle Business Intelligence Product Version 11.1.1.9 (Build 11.1.1.9.0BIFNDN…Mohd Shahnawaz Mohd Merajuddin-Oracle 54 views 12 comments 0 points Most recent by Mohd Shahnawaz Mohd Merajuddin-Oracle
-
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p…
-
Learning Hours ReportContent Hi, Has anyone created or come across a report showing the actual or attempted start and stop time of a learning class/course? Thank you!
-
What table holds the query associated with an User EntityContent Look for information where in the Fusion Database where the User Entity is stored? Trying to build an extract/report to generate details about a specific user en…
-
How Do I Expand the Width of a BI Publisher ReportSummary How Do I Expand the Width of a BI Publisher ReportContent Hello Everyone, I created a BI Publisher Data Model for a new report. Then, I Viewed Data and Saved as …
-
HCM – Product Office Hour: OTBI, 30 September 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the HCM – Product Office Hour: OTBI, September 2020 session to have them answered during the live event. Post your questions by posting…Heather Hagedorn- Cloud HCM-Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle -
Where to save analysis to be able to use them in Learning AssignmentContent Hello, I created some analysis in OTBI and I should use them to assign Communities to Learners in OLC, but I am not able to find them while performing the add Le… -
OTBI Analysis not workingSummary Report has stopped workingContent Hi, One of our most popular reports has stopped running all of the sudden - it seems like I'm the only person who can still run…
-
Max Scheduled Reports RowsContent I've found this post from a long time ago that discussed 25k as a max for scheduled reports. I'm still encountering this even with csv. Is this the limit on sche…User_2025-01-31-00-25-12-234 29 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Latest Start DateSummary Is there a latest start date field in OTBI? Need length of service in current assignmentContent Hi, I have a report that calculates the Time in Service of employ…User_2025-02-05-22-44-35-842 45 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se…
-
NRA Year to date EarningsSummary Trying to find the NRA YTD 8233 Earnings for an employeeContent Can you please suggest how to get this balance in Subject area. Please see the below Navigation: …
-
Calculated cloumn is not having value with decimals (Expected value --> 383/12 = 31.9 but current vaSummary Using TIMESTAMPDIFF function getting total months between two dates(Ex: 383 Months) when dividing 383 with 12 (383/12) current value coming as 31.0(383/12 =31.0)…
-
How can we have a Notification when an employee becomes a line manager ?Summary How can we have a Notification when an employee becomes a line manager ?Content Hello, We would like to have a notification that will trigger when a user is assi…
-
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…
-
Not able to find Line manager in Subject AreaContent Hello, I am trying to get information from workers' assignment regarding their line manager. But when I select the info from the subject area Worker Assignment R…
-
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t… -
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some… -
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…
-
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation… -
Month/Year prompt on 2 columns in HR Help Desk reportSummary Need prompts showing month/year combination for 2 prompts in OTBI report for Help DeskContent I am trying to create a report showing analysis of service requests… -
Missing direct deposit or personal payment end dateContent We are finding that we are deep into payroll processing before we recognize an employee forgot to enter their direct deposit information and a paper check is a r…
-
Filter Column Data with other Columns?Summary Issue at the moment of filter column X with data of column YContent Hi everyone! I'm working on an analysis and I have the following information: 1. Column A wit…