Reports
Discussion List
-
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 43 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 18 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Report by Performance Task countSummary Report by Performance Task countContent Currently have a query that reports out current status of performance task: Employee Self Evaluation, Manager Evaluation,…User_2025-01-29-19-46-35-367 77 views 2 comments 0 points Most recent by User_2025-02-06-15-04-02-124 Reporting and Analytics for HCM
-
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…Rajesh Ravikumar 19 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 84 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Seeded Report Location for Worksheet ExportSummary Looking for seeded report location for Worksheet Export under compensation module.Content Hello Everyone, Does anyone know how to find the seeded report location…
-
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.User_2025-02-10-21-24-50-036 38 views 5 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 40 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…User720640-Oracle 667 views 3 comments 7 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 692 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Can we create replica of changes only extract using BIP reportSummary Can we able to create a replica of changes only Extract using BIP Report. If Yes can you please guide me how we can proceed with this kind of requirements.Conten…Ashish Mangal 200 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…Kavya Sreenivasulu 734 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 165 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…
-
Highlight a change within an AnalysisSummary Highlight a change within an AnalysisContent Hello, I have an bonus change report and I want to be able to highlight when the bonus percentage changes. Anyone ha…Lisa_R 33 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 46 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …Prajna Hegde 30 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 21 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Time Card approver details for multiple AssignmentSummary Require Approver details for each assignment hours in Tiime CardContent Hi Team, I have a requirement to get the approver details for each assignment hours in th…User_2025-02-04-13-27-19-123 22 views 2 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
Time Card issues -Actual Period start Date DBI from Time & Labor.Content Hi Expert do you have any idea to fetch Actual Period start Date in Time & labor . I have created a new hire "XXXX" with the hire date of '02/23/2021' ( same dat…User_VR8E0 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need details on right place to get each salary component exact value but not adjustmentSummary Need details on right place to get each salary component exact value but not adjustmentContent In current configuration, monthly salary basis is configured with …
-
Parameterized Bi Report Within A Dashboard Is Not WorkingContent Hi Team, Greetings of the day!! I have created a dashboard with BI Report having one parameter. The report is working as expected with the same parameter but in …Divya Kollipara 41 views 4 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Reporting on Termination and Performance Review Data in the same analysisSummary I am trying to pull a report that shows employees performance review rating before their termination as well as their termination reason.Content I am attempting …
-
Report: Avg. Time in Job/Job Family/Grade/Position throughout the years - using current and past yeaContent Hi all, I'm looking to create multiple analyses that will show me the average time that employees have remained in a job/job family/grade and position throughout…User_2025-02-05-05-51-12-049 27 views 5 comments 0 points Most recent by User381997 Reporting and Analytics for HCM
-
OTBI - Workforce Performance - Performance Rating Real Time > Average Calculated Manager Section RatSummary We have a requirement to report on both the submitted Perfomance Rating as well as the Calculated Perfomance RatingContent We have a simple Report that shows the…Linsay Mair 76 views 2 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
BI Data Model: finding all reports that this is attached toSummary How to know all the reports that use xyz data model?Content Hello, I have a data model in BI Publisher. I assume 3 reports are connected to it. But how can I be …User_2025-01-28-21-53-32-678 29 views 3 comments 2 points Most recent by User_2025-01-28-21-53-32-678 Reporting and Analytics for HCM
-
Performance document analyses with CommentsContent Hello Experts I need to do an Analyses with Performance Rating and Comment given. In Analyses Performance Rating real time, any of the Comments Field there retur…Pedro Teixeira 35 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM