Reports
Discussion List
-
How do i fetch blank vales for mobile phone number in a OTBI reportSummary How do i fetch blank vales for mobile phone number in a OTBI reportContent Hi, I have a slightly different issue. I am trying to fetch the home mobile number for…User_2025-01-30-21-52-52-008 74 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analytics Section on HomepageContent Hello Everyone, Has anyone used "Analytics" section on homepage to display reports/dashboards? Currently, it displays Order to cash infolets and Service infolets…Hetal Vaghela 74 views 4 comments 1 point Most recent by Pooja_Chowdhary-Oracle Reporting and Analytics for HCM -
How to get the previous performance task name in OTBIContent Hi All, I am trying to get the results for current Performance Task name and previous Performance Task name using the Subject Area: "Workforce Performance - Perf…Janardhana K 82 views 5 comments 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
How to split element input values into separate columns in BI ReportSummary How to split element input values into separate columns in BI ReportContent Hi Experts, Currently, in my BI report, all element input values are showing under on…Mahendra 115 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
report to pull manager rating and participant reviewSummary report to pull manager rating and participant reviewContent Hi All, I have prepared two simple reports to pull manager performance rating and participants review…Ritwick Chatterjee 57 views 3 comments 1 point Most recent by Ritwick Chatterjee Reporting and Analytics for HCM -
Etext Template in csvSummary Etext template in csv drops leading 0's from reportContent when we export the file as text, the ID's keep leading 0's, but when it goes to csv leading 0's are dr…Mike Borghoff 29 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
How to get Custom CSV output with E-Text Template TypeSummary How to get Custom CSV output with E-Text Template TypeContent Hi, we require CSV report output in e-text template format. when we choose csv output format its cr…User_MC37Q 161 views 6 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
Missing Manager Names on Hire NotificationsContent Hello, We currently have alerts set up for new hires that goes to our IT department using the attached XML. To get the latest hire date and information we use th…User_2025-01-31-00-25-12-234 35 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Create a Bursting Email with TemplateContent Does anyone have any user guides or instruction templates for setting up a BI Report that is bursting a custom memo to the recipients on the list. We have a repo…Katie.Buchanan 82 views 4 comments 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Missing Prompt ValuesContent I'm looking at a Manager Username Prompt, but not all the values are returning for the prompt/filter. Has anyone seen this before or know why all the options in …User_2025-01-31-00-25-12-234 32 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Total Compensation FigureSummary I would like to add Total Comp to my reportContent Hi, The Compensation - Workforce Compensation Real Time subject area is redundant in my organisation, is there…User_2025-02-05-22-44-35-842 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 42 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 27 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 64 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 29 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 85 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 82 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 58 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 56 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 29 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 50 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 92 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 40 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 586 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 114 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 72 views 3 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM