Reports
Discussion List
-
where to find "when is the employee start date" from offer letter in BISummary We need to report "start date" from offer letterContent Hello We have a requirement to include the "When is the employee start date" [hire date] from the offer l…Adil_R 131 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report on objects of PlanningHello All, We would like to have a big report showing all tasks from Task List > which webforms they open/which rule they launch > which scripts/menus/variables are used… -
Is there a report that can show user accesses to a specific Oracle Cloud app (Learning)?Summary: Request has been raised by business stakeholders who want to show usage of the new Learning platform. We can report on learning enrolments but this does not sho… -
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o… -
Errors importing Data Management report templatesSummary Not able to import modified report template files to Data ManagementContent Hello everyone, In Data Management I've extracted and modified a report template (rtf…User_MB094 20 views 2 comments 0 points Most recent by JeroenDrupsteen Financial Consolidation and Close -
Why does the Compensation - Salary History Details Real Time not show the correct adjustment?Summary: In the subject area Compensation - Salary History Details Real Time it is showing a value which is not in the front end for adjustment. Content (please ensure y… -
How to send UCM file as an email attachment using BI publisher reportSummary: How to send UCM file as an email attachment using BI publisher report Content (required): Hi Experts, We need to extract a PDF file from UCM and send as a email…Venkatesan 731 views 15 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 31 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Fiscal YTD not working correctly in HCMSummary: Need to get Fiscal YTD terminations but I cannot get it to result in Sep 1, in instead get 09/22/23 if run today. Content (please ensure you mask any confidenti…Sherie Ross 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…AjayKumar Maddipati 471 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Summary of multiple entites for each period in the report based on the promptWe have a requirement that the summary of multiple entities for each period be reflected every month. We understand that by inserting a formula column and adding a formu…
-
IN below OTBI Manager DR report but country name not showing it showing DRS country nameSummary: Hi Team, we have list of people with direct reporties but when we add the country name in the it showing reporties country but we need manager country . Any one…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Goal approval request notification template non editableSummary: Goal approval request notification template non editable Content (please ensure you mask any confidential information): Hello experts, we have enabled the appro… -
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Mail Bursting Didnt WorkedHi Everyone, I Just Checked the Bursting SQL, My Data Model but couldnt find the reason. In transaction screen I can see delivered with success . But at my mail I can't …Kaan Can Calkan 11 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio…Avinash.Potti 21 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM -
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the …Kyle Norris 41 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 61 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…Priyabrata Prusty 81 views 3 comments 0 points Most recent by Priyabrata Prusty Reporting and Analytics for HCM -
The tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updatedPlease note that the tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updated to sometime between mid-to-late CY2024 (subject to change, s… -
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 32 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Copy and Paste Grids Between Different ReportsSummary Is it possible to copy and past grids between reports?Content I have a number of grids built on the same data across various reports. Is it possible to copy and … -
How does a matrix manager see the indirect reports for the person set up as matrixed to themSummary: I have set an employee up as having a matrix manager. I would expect the matrix manager to see this employee along with his/her direct/indirect reports in a hie…JoeNalbach 43 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Could someone please inform me about the table where I can find information on deleted user roles?Summary: Could someone please inform me about the table where I can find information on deleted user roles? In the per_user_roles table, records are permanently removed … -
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …Bradley Gray 59 views 23 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i…Vis Perera 71 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Report Path for Audit Reports PageSummary: Could someone please share the report path for the page below? I intend to generate a BIP report to monitor user role deletions and additions. Content (please e…TestUser35 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Hide attributes dimensions from member selectionSummary: The FCC administrator would like to hide the attribute dimensions so that it does not appear in the member selection dialog box. Content (required): The attribu…