Reports
Discussion List
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 734 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Grouping EthnicitiesSummary Grouping ethnicities after a single row of data has been calculatedContent Hi everyone, Using this post, I was able to successfully get an ethnicity report to re…User_2025-02-11-03-07-51-707 168 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM -
Oracle Employee auditing that captures changes to a persons recordContent We currently have been looking at the history tab within person management and have realized that it does not give us much information. After connecting with Ora…User_2025-02-05-16-39-03-485 25 views 1 comment 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Effective Date of Latest Job CodeSummary Pulling Effective Date of Latest Job Code in an analysisContent I have created an analysis using the subject area ‘Compensation – Salary Details Real Time’. I ha…Shelly Feyerherm 102 views 9 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…Lauren Owen 27 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …User_2025-01-28-08-47-04-905 418 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI excel template xsl when otherwise tags giving data in different format with extra spacesSummary BI excel template xsl when otherwise tags giving data in different format with extra spacesContent Hi All, In one of the custom BI report we are using excel temp…User_XT9HW 37 views 1 comment 0 points Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM -
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…Rajeev Nayan 70 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Managing privileges for AgentSummary Schedule an AgentContent Hello Everyone, Does anyone know which privilege from the list below removes the access from users to Schedule Agents? Thank you, Alvaro…Alvaro Couto 51 views 6 comments 2 points Most recent by Laura Meine Reporting and Analytics for HCM -
Behaviors tagged under each competency in Talent profileContent Hi, Can someone help me with the database table where we get the Behaviors tagged under each competency? Regards, NivyaNivya Mathire 6 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The …Revital Mefano 35 views 4 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
Pivot Report - Have a heading and change value sequenceSummary How to change value sequence and have a label in pivot report?Content I have created an OTBI report with pivot output. On left side is the desired output and on …User_2025-01-25-04-02-13-126 52 views 4 comments 0 points Most recent by E McDonald Reporting and Analytics for HCM -
OTBI how to round up a number with decimal points to be without the points?Summary OTBI how to round up a number with decimal points to be without the points?Content Hello, In OTBI report, there is a field based on sum of FTE , which may includ…Revital Mefano 467 views 10 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
Candidate Pre-Screening ResponsesSummary Need to build a report to reflect the pre-screening responses for specific candidateContent Hi All I am new to HCM, and I am having trouble determining how to jo…
-
OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Summary OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Content Hello , We have an OTBI with layout of a sun displayed in a ‘perf…Revital Mefano 36 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Trouble with Template Builder for WordSummary Can't get the template builder for Word to properly installContent Hi - I have been having issues getting the Template Builder for Word to install properly. I tr… -
BI Publisher password is cleared from Formatting section post upgradeSummary The passwords for my BI Publisher reportsContent Hello I have some password protected BI Publisher reports on a weekly schedule and have noticed that after an up…User_2025-01-28-08-42-56-900 28 views 7 comments 0 points Most recent by User_2025-01-28-08-42-56-900 Reporting and Analytics for HCM -
Transaction Console ReportContent Hi All, Need your help in which we can extract the below data fields. This is a kind of requirement from the internal Audit. Resignation Submission Date ---- Not…Kiran Kancherla 559 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
TalentProfile ReportSummary Path for editable version of the TalentProfile ReportContent Hi All, Does anyone know what is the path for the editable version of the Talent Profile Report ? th… -
Wrap Text in OTBI ReportsContent Hi All I unchecked wrap text checkbox in Table content properties to wrap all the columns in the report. In the view it shows the columns are wrapped. However, w…Ridma Karunanathan 131 views 5 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Need the logic to convert English to Chinese language in SQLSummary Need the logic to convert English to Chinese language in SQLContent Hi Team, I have a BI(SQL) report and some of the fields like 'Legal Entity, BU, some EIT fiel…User_2025-02-01-03-43-13-079 96 views 4 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
View Headcount by Selected LeaderContent Hello everyone, I created a dashboard for HR business partners covering basic worker and person assignment information e.g. headcount, gender breakout. I would l…User_2025-02-11-03-07-51-707 43 views 4 comments 1 point Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM -
Detailed report for pie charts does not work with dashboard promptsContent We are building a dashboard for Talent Profiles and have successfully built a chart that accurately pulls data from Talent Profiles. The chart works well with th…User_2025-02-10-08-27-16-805 36 views 2 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
adding recruiter's assignment name from work assignment real timeContent How can i pull the recruiter 's title (recruiter full name- hiring team) from their core hr record. anytime I join recruiting real time to workforce assignment r…Riti Malhotra 13 views 2 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM -
Table in Data Source: AuditViewDB where it contains the names and employee number of employees.Summary I'm currently using the Data Source: AuditViewDB for some audit purpose. I need the table from that data source that contains the names and employee number of em…Mark kristan De los Reyes 39 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
BIP report to have attachmentSummary Attachments in BIPContent Hi Team, We are trying to download CV in Bulk from Oracle Recruiting Cloud. I was able to bring in the URL from UCM for the attachment …Varun Kumar Kota 67 views 3 comments 1 point Most recent by Hariharan Sekaran Reporting and Analytics for HCM -
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…User_VR8E0 21 views 1 comment 1 point Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 460 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
OTBI vs BIP filtering clarificationSummary HOw OTBI handles filtering verse BIPContent Hi, Seeking clarification/advice on the following scenario. We have an OTBI report that pulls in a person's work exte…Denise Izzi 30 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the …Chiara Arcidiacono 30 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM