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
-
Disappearing images in OTBI DashboardSummary Disappearing images in OTBI DashboardContent I built a dashboard for users to look up Jobs and print out the corresponding Job Profile in a PDF format I am using… -
create Graphs from an "analysis from simple logical sql"Summary I have a report created using "analysis from simple logical sql", and I wnat to add some graphsContent Hi, I hope you are doing well. I have created a report usi… -
Need a report on Bell Curve & PMS distribution manager wise, department wise and Compensation Plan wSummary Need a report on Bell Curve & PMS distribution manager wise, department wise and Compensation Plan wiseContent Dear All, Need a report on Bell Curve & PMS distri… -
Ned inputs to display reports(BIP/OTBI) to specific users/based on the rolesContent Hi All, We developed custom BIP reports as per our requirements and all the reports we placed in custom-->Human Capital Management-->Reports.Now we have a requir…
-
BI Publisher Report Auto Run - Open Report from home page instead opening from BISummary BI Publisher Report Auto Run - Open Report from home page instead opening from BIContent Hi Experts I have created a BI Publisher Report. i have taken the url of… -
How do i fetch blank vales for mobile phone number in a OTBI reportSummary How do i fetch blank vales for mobile phone number in a OTBI reportContent Hi, I have a slightly different issue. I am trying to fetch the home mobile number for…
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…
-
Worker Assignment Event history - job title "as of" assignment effective dateSummary Pulling data relevant to the history effective datesContent We have a report that is pulling all assignment events for an employee -- essentially a full summary … -
Subject Area for Compensation Market DataSummary Subject Area for Compensation Market DataContent Hi, Does anyone know which Subject Area is used for reporting the Compensation Market Data? I've checked the HCM… -
Create OTBI report to fetch the 2 recent most records for a person's legal employer changeSummary Create OTBI report to fetch the 2 recent most records for a person's legal employer changeContent Hi Experts, I need to create an OTBI report that shows the curr… -
In person HCM Cloud OTBI Workshop at Oracle Reston VAContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t… -
Oracle Report Jam at Collaborate 2019: Here to Build Your Reporting ConfidenceSummary April 8-10 2019, San Antonio TXContent Come and meet reporting experts from across Oracle HCM product development who can build a report with you, answer your re…
-
Need logic to get the base element from Retro run results elementsSummary Hi Team, we have a requirement to get the project number and task number from base element:Content Hi Team, we have a requirement to get the project number and t…
-
Fetching Workforce Structure from Job Profile Type in BI queryContent Hi Team, I have a requirement of fetching "Workforce Structure" from Job Profile using BI query.Please help me with the query. Thanks Sandip Karmakar -
Look Up Value as Of DateContent Hello, Is it possible to create a field in OTBI to look up a value as of date. The requirement I have is to pull an employees current job and salary and their jo…
-
How to enable two bursting queries at a time in the BI report while scheduling.Summary How to enable two bursting queries at a time in the BI report while scheduling.Content Hi , I have a requirement that to send resignation alert with checklist to… -
Table name for Element Frequency RulesSummary Table name for Element Frequency RulesContent Hi, Any inputs on how to pull Frequency Rules setup on Element definition? I'm trying with the below tables PAY_ELE…
-
BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun… -
HR Reporting ProxyContent Hi - I have a report that we pull location information from our work structures area. Fusion > Workforce Structures > Manage Locations | scroll down to Legislati… -
Grade on Worker vs Grade on JobSummary We need a report that shows employees grade on worker level and grade on job levelContent I need a report like NAME | Grade (at worker level) | Grade (job level)…
-
Length of Service BandingContent I am trying to Band together number of employees within certain Length of Service Banding. Our Length of Service is from "Enterprise Seniority Date" But the Repo… -
How to embed a OTBI Report in the landing pageSummary How to embed a OTBI Report in the landing pageContent How to embed a OTBI Report in the landing page - Need to access the OTBI Report from Landing page directly … -
How to Include an url in the BI Publisher Bursting Email BodySummary How to Include an url in the BI Publisher Bursting Email BodyContent I have a link which needs be sent to the recipients going through the busting email. Here is…
-
BIP report issueSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi Team, As an Admin, I can run a report and it completes sucessfully for me. Users can't…
-
Assignment Manager Hierarchy for Direct and All WorkersSummary Building an OTBI analysis to use the Assignment manager Hierarchy for direct and all workers based on a promptContent Hello, I need to be able to prompt on Direc… -
Filtering values based on another columnSummary Only show Projected End Date for LOA'sContent Hi I'm trying to run an active staff report, including projected end dates for people with Assignment Status of Mat…User_2025-02-03-23-33-26-899 101 views 2 comments 1 point Most recent by User_2025-02-03-23-33-26-899
-
Previous and current values flip in the OTBI ReportSummary Previous and current values for different action codes for an employeeContent Hi All, I have a requirement to fetch a report consisting of changes to Jobs, EEO1 …User_2025-01-30-21-52-52-008 481 views 21 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
Manage Administrator Profile Values - Is there a Report for this?Summary Get list of all Enabled Profile Values - Manage Administrator Profile ValuesContent Hi All Could any of you have a Report for the Administrator Profile Values? W…
-
Any one tried Calling SOAP web-services to submit and download BIP ReportSummary Any one tried Calling SOAP web-services to submit and download BIP ReportContent We are trying submit and download the BIP reports using Webservices. As per orac…User_2025-01-28-00-10-14-788 68 views 5 comments 1 point Most recent by User_2025-01-28-00-10-14-788
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …