Reports
Discussion List
-
OTBI Analysis results specific to user running requestSummary OTBI Analysis results specific to user running requestContent Hello, I created an OTBI analysis that i want to make available for specific users to run. The trou…Jose Castelan 53 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Data model to Fetch Proposed value of Job in Workflow notification seeded TemplateContent Hi, I have a requirement to add job title in Transfer Details section of seeded Workflow notification(Transfer Report). I managed to fetch Current Value of Job b…User_2025-02-06-14-37-05-233 36 views 2 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Newly Added Lookup Values not available in OTBI - Service date rule at person levelSummary Newly Added Lookup Values not available in OTBI - Service date rule at person levelContent Hi Team, Newly Added Lookup Values not available in OTBI. Lookup type … -
Conversion of Timezone in RTF templateContent I am facing a situation where the client is entering the data in the UI as 9:00 AM but since the database stores the time in the UTC format it is storing as 13:0… -
BI Report Output file renamingSummary Can we rename the report output file name in BI Reports, currently it’s coming as report job id.Content Can we rename the report output file name in BI Reports, …Vibha Pandey - Oracle 36 views 3 comments 0 points Most recent by Subhash Kumar Bichhode-Oracle Reporting and Analytics for HCM
-
Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardSummary Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardContent Need a table name/Coumn name to identify whether it is a 2020 tax …User_2025-02-04-07-00-18-658 47 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM
-
Line Manager information of Future hired WorkerContent Hi, I have created OTBI report listing all our future hired Workers (xml attached). For some reason the Line Manager information is not populated on the report. …Niko Hölttä 47 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 331 views 7 comments 11 points Most recent by Claudio Civati Reporting and Analytics for HCM -
Get Data From Previous Row in AnaltycsSummary Get Data From Previous Row in AnaltycsContent Hi, I have null values in Analytics. I dont want to show like null values. So I want to get data from previous row …User_2025-02-05-02-38-04-251 63 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Goals Version TypeSummary When an employee updates their goal, update does not reflect in report until Version Type = ACTIVEContent Is it normal behavior for when an employee updates a pr…User_2025-01-28-20-36-10-715 57 views 4 comments 0 points Most recent by User_2025-02-04-23-22-13-274 Reporting and Analytics for HCM
-
Duplicate Element EntriesSummary Element entries for employees are appearing twiceContent Hi, Please see attached XML file/ If an employee has more than one element entry then that will appear o…User_2025-02-05-22-44-35-842 46 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL for Hire Date + 30 daysSummary does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?Content Hi folks - hoping this is an easy one! Does anyone have a quick a…Matthew Grillo-95429 43 views 2 comments 0 points Most recent by Matthew Grillo-95429 Reporting and Analytics for HCM
-
Adding Dynamic BI Publisher Link to DashboardSummary Creation of a simple dashboard with links to all reports in our instance (static BIP links don't solve our issues)Content Hi all, We are trying to create a more …User_2025-02-05-05-51-12-049 141 views 17 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Will it be possible to get direct & Indirect employee assign to managerSummary Will it be possible to get direct & Indirect employee assign to managerContent Hi All, Will it be possible to get direct & Indirect employee assign to the manage…User_2025-02-05-01-04-36-989 48 views 11 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BI Report for IntegrationSummary Need a BIP report with .dat output formatContent Hi Experts, As a part of business requirement we need a BI report with output in .dat format and need to send th…Charan Kollipara 53 views 4 comments 0 points Most recent by User_2025-02-06-08-02-11-890 Reporting and Analytics for HCM
-
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an…DavidBlake 168 views 13 comments 0 points Most recent by Gregg Vadasz Reporting and Analytics for HCM -
Need help for building Confirmation Letter after probationContent Dear All, I am new to report development in oracle fusion HCM cloud. It would be really helpful if someone can post Confirmation Letter after Probation & Extensi…User_2025-02-06-14-37-05-233 103 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to see custom fields in OTBI?Content Hello experts, I have created a custom field in worker assignment page. How can I see custom fields in OTBI? Are there any batch processes to launch? Thanks in a…Valerio Curzi 61 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Agents querySummary Recipient / Specified UserContent Hi, If I set up an agent as a specified user i.e. (me), will the recipient who is located in a different region still only see …User_2025-02-05-22-44-35-842 35 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Embed a BI Publisher Report link in the Goals page to fetch data for the searched employeeSummary Approach to embed a link to run a BI Publisher report to fetch Goals details for that employeeContent Hi, Apologies if I had missed any existing thread/post on t…Kalyan Amaravathi 72 views 4 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Email address not accepted in scheduled BI Publisher reportSummary & in email address is preventing scheduling of BI Publisher ReportContent Hi, A colleague is trying to schedule a report but he is unable to enter an email addre…User_2025-02-05-22-44-35-842 30 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Passing values from report to an oracle fusion pageSummary Passing values from report to an oracle fusion pageContent I have a BIP report with bursting to email, which will be sent to the manager for individuals. Now in …User_2025-02-06-10-22-06-460 36 views 1 comment 0 points Most recent by Laksh Kapoor Reporting and Analytics for HCM
-
BI Publisher Termination ReportSummary Can a fix I made to the analysis version be applied to the Data Model version?Content Hi, Can someone please add the following Action Codes to this Data Model & …User_2025-02-05-22-44-35-842 48 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Need inputs to display data under "Calculated Time" section in OTLContent Hi All, As per the OTL setup we are referring two layouts while displaying OTL data. Initially employee will enter hours , Payroll time type, Hours and related f…Visu 41 views 4 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m…Inge Marinus 21 views 3 comments 0 points Most recent by Inge Marinus Reporting and Analytics for HCM -
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary =IF((Base SalaryContent SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (select salary_amount from cmp_salary where assignment_id=a.…User_2025-02-07-09-10-02-492 47 views 28 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary round(base_salary * 4.81%)Content SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (case when C.MIDDLE_NAMES is null then C.FIRST_NAM…User_2025-02-07-09-10-02-492 55 views 2 comments 0 points Most recent by User_2025-02-07-09-10-02-492 Reporting and Analytics for HCM
-
Analyses report to fetch Supervisor Level 2 and aboveSummary Analyses report to fetch Supervisor Level 2 and aboveContent Hi, I am looking to fetch the following using Analyses. * A list of Supervisors with Level 1 (not ma…Manoj.Gupta 48 views 6 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement …
-
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…Jennifer Eichholz 46 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM