Reports
Discussion List
-
PL/SQL - Absences in UoM: Weeks to be Displayed in Days?Hi all, Hope you are well. We have certain absence types such as Maternity, which have the UoM: Weeks. We have a requirement for reporting purposes to display this as Da…David Oldfield 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Ability to integrate report snapshot from third party tools like PowerBISummary We currently have some report dashboards based out of bulk transactional data in PowerBI and want to automate EPRCS report/report package get the snapshot from o… -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 1 view 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…
-
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 155 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM
-
Asset Depreciation - Asset assigned to ProjectsSummary Asset Depreciation - Asset assigned to Projects - Tracking Depreciation in Project CostingContent Requirement: Fixed Assets is shared across multiple projects. D…Girish Kotecha-Oracle 180 views 5 comments 0 points Most recent by Senthil Mohanraj Project Management
-
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t…
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…Prudence K 49 views 6 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Manager only saves ratings (no submit) and then the OTBI report is run, are saved ratings fetched?Summary: Hi Peers, Our client has a requirement relating to an already live Performance Evaluation. They want to calibrate the rating (as an afterthought) Instead of add…S Shree 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 16 views 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM
-
Unable to list just one manager for each Matrix Manager TypeSummary: We have a report that provides employee details AND includes each manager type i.e. Line Manager, Comp Planning Manager, and Timeclock Supervisor. When we run t…Darrin N 11 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to include historical source information?Summary: Candidate Pool Reporting - historical 'Source' data Content (please ensure you mask any confidential information): We are building a report on candidate pools a… -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I remove the blank row from the NR reportHey All, I am working on formatting a report and it seems that there is a blank row appearing always when I export to report to excel file. Is there a way I can remove t… -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.4K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Missing transactions and Balances from Lease balance tablewhat are staging tables and what are the transactional tables in leases. Because when using FLA_LEASE_BALANCE_ALL, it seems the data doesn't get populated until there is…
-
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action…
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 463 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a formula to create a cumulative sum column in a management report?example: the grid would consist of row intersection containing multiple segments, so it could not be a manual effort. There are thousands of segments. Thanks for the sup…
-
Report to show Deleted Payroll ElementsSummary I need to generate an Audit report showing when an element was deleted and by whoContent I tried running the Deleted Data Report but I didn't get any information…User_2025-02-04-08-51-08-912 44 views 9 comments 0 points Most recent by Julie Searles Reporting and Analytics for HCM -
When adding field to my report, the Matrix Manager values are being eliminatedSummary: I have a report that includes both Worker Assignment Real time and Compensation Salary Detail subject areas. I have been able to add all desired fields successf…Darrin N 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Creating a rolling quarter report in application with 13 periodsSummary: We have 13 periods in applications, and we are trying to create a report for rolling quarters, for all the period's "parent of periodoffset of currentperiod-3)"…AnkitGupta07 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Navigation Flow - New Card in a Custom Cluster Not visible for all usersSummary: We have created a new card under a custom navigation flow cluster to include a new area for our users to easily access reports. We have had this Tax Provision c… -
Narrative Reporting- How to override a row dimension based on a selectable pov dimension?Summary: I have a custom dimension in the rows of a report. I need to set the row custom dimension based on the year in the pov. For example, If the year selected in the…643dp 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close