Reports
Discussion List
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 4 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Duplicate Data Rows for EFF fields in Reporting (Data Issue?)Summary: Hello, We are noticing when we are building basic reports whenever we bring in Job or Department EFF fields in the criteria, we get duplicate rows for employees…CCannadayCTR 32 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 11 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM -
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche…User_2025-01-30-17-46-10-378 351 views 12 comments 0 points Most recent by Sigrid B. Reporting and Analytics for HCM -
OTBI - Store Analysis or static Briefing booksSummary: Can we use OTBI to store month-end snapshots of static data to refer back to without exporting offline? Content (please ensure you mask any confidential informa…Clare Murtagh 2 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 1.8K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM -
How to Restrict groupings with 0 from display in HR dashboard chartsSummary: Restrict groupings with 0 from display in HR dashboard charts Condition used in column Level: CASE WHEN "Workforce Trend"."Termination Headcount"Raman Singh 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…Alex van Gulijk 201 views 14 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Community of a learning course - OTBIDear all, We would like to report the community in which a COURSE has been integrated to. In my following example : for my COURSE "English language training", I would li…Jacqueline GRANDIN 31 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…Malak 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Merge Lead Creation Date & Opportunity Creation DateSummary: We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It s…Vigneshwar 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Combining two rows of data into a single columnSummary: Combining two rows of data into a single column IF an employee has two degrees the expectation is to print it into a single row of data. For example Employee 12…Venkateswaran Murali-Oracle 237 views 15 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Passing real time binding parameter to OTBI as presentation variableContent I have a requirement to add OTBI report in Termination Page UI which will capture three Real-time Binding Parameters (Person ID, Termination Date & Termination N…User_2025-02-06-14-37-05-233 656 views 28 comments 0 points Most recent by GopalS Reporting and Analytics for HCM
-
OTBI Custom ImagesHi all, Just a quick one I'm hoping someone knows the answer to! We've been using our own custom images for reporting and have noticed that the system allows us to uploa…MikeW 26 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 126 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
No of days old in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Error on NLS_DATE_LANGUAGE code for Traditional and Simplified ChineseHello, We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error : "ORA-12702: inva…Lise_Rekik_Acc 24 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us…
-
Email Correspondences/System Notifications ReportSummary: Looking for report(s) which would list all email correspondences we currently have set up, the status, frequency and recipients. As well as a listing all system…GMV 22 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration
-
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 273 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 32 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard Design - Export ButtonHi all, I'm currently working on an OTBI Dashboard that certain groups across the business will use. We're using a mixture of Performance Tiles, Graphs and Tables and I …
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the…
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 909 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM