Reports
Discussion List
-
Succession PlansSummary I need to report number of Plans without CandidatesContent Hello, I can see the plans without the candidates (highlighted in the attached), but once I add the Co… -
HR Help Desk - Organizational hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t…Mitch_123456 43 views 4 comments 0 points Most recent by Mitch_123456 Reporting and Analytics for HCM -
Probation End DateSummary Is Probation End Date available in OTBI?Content Hi, Is the Probation End Date available in OTBI? If yes, which Subject Area is it located in? Many thanks, Andrew…User_2025-02-05-22-44-35-842 46 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Manager Name not updating in Absence ReportSummary Manager change not reflected in reportContent Hi, I have an absence report that has a legal entity prompt that end users use that has worked perfectly fine until…User_2025-02-05-22-44-35-842 26 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
field that pulls number of direct reportsSummary I am working on a report that requires a field to pull 'Number of Direct Reports'. A non-manager would have 0 or null. Manager will pull active direct reports.Co…User_2025-02-06-07-21-22-662 63 views 4 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru…Hetal Vaghela 31 views 2 comments 2 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
Employees who had their job changed?Summary OTBI report for all employees who had their job changeContent Hi Experts, Is it possible to create a report in OTBI which gives me a list of all employees who ha… -
OTBI reports not working in 20ASummary All OTBI reports are erroring out in 20AContent We recently got our test instances upgraded to 20A over the weekend and all our OTBI reports are not working. We …Roy Paolo Paunlagui 87 views 10 comments 0 points Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM
-
Track hours for ACA requirementsSummary Looking to find details to track hourly employees to see if they meet hours for ACA eligibilityContent Hi all, Client is outsourcing ACA administration, however,…User_2025-01-30-00-53-42-934 81 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of…Andrew Braid 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…User_2025-02-06-07-21-22-662 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to provide the secure access to folder using custom role to employeeSummary How to provide the secure access to folder using custom role to employeeContent Hi Expert, Want to provide the report folder access to the set of employee who is…User_2025-02-05-01-04-36-989 28 views 3 comments 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…Roy Paolo Paunlagui 52 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 91 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
how do i pass HR assignement no to balance feed querySummary how do i pass HR assignement no to balance feed queryContent Hi Members, I need a help. There is an employee having two assignment no at the same legal entity. I…User_2025-02-05-22-36-27-300 39 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties…Aloka Bhattacharya 521 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…Aloka Bhattacharya 112 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM
-
HCM Subject Areas - Field ListSummary List of fields within HCM Subject Areas - and DescriptionContent Hi, I am new to reporting within HCM OTBI so this may be a silly question and may or may not hav…User_2025-02-05-10-44-58-756 70 views 3 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM
-
Attributes of Pay ElementsSummary Taxable, Niable and Pensionable flags associated with each pay elementContent Hello, I am trying to develop a report in Oracle Fusion to obtain every payroll ele…User_2025-02-04-17-55-40-189 44 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so… -
Weekly & Monthly Team Calendar View for Employees & ManagersContent Hello! I don't think a day goes by where we are not asked for weekly and monthly team calendars to allow our managers to make informed decisions around holiday r…Kevin M Storrie 100 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
Dashboard Prompt using BI Publisher/DataModelSummary Using a prompt on a dashboard for a BI ReportContent I have placed a BI Publisher report on a dashboard. This report is built from a data model that contains a p…Shelly Feyerherm 62 views 2 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
Report sorting based on supervisor hierarchy 1 followed by hierarchy 2Summary Requirement: Report sorting logic required to sort based on Supervisory Hierarchy 1 followed by Supervisory Hierarchy 2 as displayed in the table above. Kindly l…
-
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…Misbahul Khair 47 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
How to embed a an OTBI report in the Skill and Qualifications pageSummary How to embed a an OTBI report in the Skill and Qualifications page?Content Hi, I want to embed an OTBI report in the Skill and Qualifications page, in order for …Silvia Guido 72 views 2 comments 0 points Most recent by Silvia Guido Reporting and Analytics for HCM
-
HR Help Desk - SR`s out of SLASummary Can we report on how many SR`s go out of SLAContent Hello All, i was wondering if anyone knows how i would go about creating a report on how many SR`s per period…Mitch_123456 47 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Organisation Hierarchy treeSummary Organisation Hierarchy treeContent Hi, We have a requirement to pull the report of manger hierarchy in top and down. Suppose if I give employee number it should …Reddykrishna 105 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report showing changes to key fields onlySummary I have been asked to develop a report that will extract data changes onlyContent Hi, I have been asked to develop a scheduled report on based on the following fi…User_2025-02-05-22-44-35-842 38 views 8 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM