Reports
Discussion List
-
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 110 views 15 comments 6 points Most recent by Radouane Allam Reporting and Analytics for HCM -
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv… -
Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… -
Can Employer Comment under Termination Details be on a report?Summary Is there a way to add the Employer Comment informaiton to a reportContent We list the company that an employee leaves us for in the Employer Comments box on the …Denise Jo Crangle 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 138 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 13 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 45 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Physical Signature Example ReportSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign…Brian Kleb-Oracle 768 views 24 comments 9 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
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…Lynn Sack 15 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 42 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 13 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Filters on evaluation deep linkSummary: Filters on evaluation deep link Content (please ensure you mask any confidential information): I have the following deep links: Evaluate Performance (EVALUATE_P…Stefano_Mazzocca 12 views 1 comment 0 points Most recent by Senthil Murugan Balasubramanian Reporting and Analytics for HCM -
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 76 views 5 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo…Jose Guerra 5 views 1 comment 1 point Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 30 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna 15 views 1 comment 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 140 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 16 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is… -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Termination ReportSummary: We are new to Oracle and looking to build a simple termination report that returns all terminated workers. Current problem we have is that it's returning termin…Darrin N 81 views 14 comments 0 points Most recent by Manmohan Mohapatra-Oracle Reporting and Analytics for HCM
-
Changed information not shown in the Audit ReportsSummary: Hi, Regarding Address or Legislative information changes within the Audit Reports ; The log does not display all the fields that have been created, updated, mod…
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 13 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 24 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 50 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…
-
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…