Reports
Discussion List
-
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 419 views 5 comments 0 points Most recent by Madhavi Achyuta-Oracle Reporting and Analytics for HCM -
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …Oriana L. 4 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th…
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our … -
Query to get costing and Element linkSummary SQL Query to get costing segment columns and element link name columnContent Hi All, I want to pull the costing segments along with credit, debit amounts and ele…User_C7E7N 665 views 4 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a…
-
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …
-
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…
-
OTBI Report not showing all the data thats in HCMSummary: Customised report not showing data for all employees but its in HCM Content (required): Hi We have a customised configuration for our DBS details. Up until last… -
How long will the logging within the Audit Reports continue to show the historical data(old values)?Summary: Hi, We would like to know how long the data as retrieved via the Audit Reports is available to us. For the moment it seems as if we can insert any possible Date…
-
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 2 views 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 898 views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su…
-
Display month name's with sorting in OTBI Analysis outputsSummary Display month name's in OTBI Analysis outputsContent Hello Team, I have created OTBI report in that month column value should be displayed like Jan, Feb, Mar, et…User_2025-07-18-14-08-42-473 162 views 7 comments 0 points Most recent by Hari S Reporting and Analytics for HCM
-
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)…Sujeeth Chinta 434 views 2 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…Saurabh_Mharolkar 16 views 2 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the…
-
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract…
-
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s…Mark Stoker 12 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: …BenZionP 110 views 10 comments 1 point Most recent by Andrew Nainggolan Reporting and Analytics for HCM -
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part…Brent_Beardsley 11 views 2 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM -
Display Person Images on BI ReportContent Hi All, Do you know how to display Employee's image on the BI Report? Images are stored as BLOB files, then how can we display them? Read on to know more details…Sricharan Monigari 106 views 10 comments 3 points Most recent by User_4H1FC Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Download PDF DashboardsSummary: Download PDF Dashboards Content (please ensure you mask any confidential information): Hello experts, we would like to download a dashboard as pdf but it seems …
-
Show Only Maximum Current Year Enrollment Coverage Start DateSummary: I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below co…JHaden3 32 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM