Category 81
Discussion List
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 32 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 84 views 0 comments 0 points Started by Jaswant Prajapati Reporting and Analytics for HCM
-
How can I combine HCM and Projects subject areas in OTBISummary: I would like to know if it is possible to combine HCM subject areas with e.g. Projects subject areas in OTBI. Content (required): Hi! I'm creating a rather larg…Nicolas Vahman 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Phase/ State Application ReportsSummary: Content (required): Hello, We would create an simple OTBI analysis that show for each phase/state the number of active job application, We would order the phase…Giuseppe Iacono 12 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 92 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…User_C36BE 754 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Combining year and quarter in a date columnSummary: Need help to show both quarter and year in a table Content (required): Hi I'm running a learning completion report and want to show quarter and year in one colu…Jane Warwick 32 views 1 comment 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
New Manager type not showing in OTBISummary: We've added a new manager type in HCM and it's currently not showing in OTBI. I've ran the Refresh Manager Hierarchy and the Transfer the Flex fields to OTBI. I…User_2025-01-31-00-25-12-234 61 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
HCM Extract for Payroll ProcessHi We have requirement to get employee details who are processed in a payroll based on the given period start and period end date , so we are planning to create extract …
-
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we add spaces in between bar on a stacked bar graph in OTBI Analysis OutputSummary: Adding spaces in between bars on a bar graph in OTBI Content (required): On the output of a bar graph, the bars are connected with each other. Can we add extra …Vibha Pandey - Oracle 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to see Values BU wise Head countSummary: unable to see Business unit wise Count while select column Head Count and Business Unit Name. Content (required): In subject Areas "Workforce Management - Worke…
-
How to remove unwanted Folders on Catalog?Summary: Content (required): How to remove unwanted Folders on Catalog? Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 42 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 290 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
"Job Requisition - Posting Structure"."Job Function" and "Current Phase" ProblemSummary: Content (required): Hello Guys, We would report if we create a simple analysis from "Recruiting - Recruiting Real Time" subject area we lost a lot of data than …Giuseppe Iacono 13 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
Need to add different images of signatories in the rtf template for a BIP reportSummary: Content (required): I want to add signature's image to the letter which is in rtf template where path of the image is an XML element. As far as i researched im …
-
BI Publisher Integration with Google CalendarSummary: Can we integrate BI Publisher with Google Calendar (i.e.) To make a web service call from BI to Google Calendar API and create and update events. Please share i…Srikanth_M 11 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How do I retain drill-down reporting with a null value in a data setSummary: Hello. I have a dashboard which has several pies on it that draw data from talent review categories. I need to enable drill-down person reports from the pies fo…User_2025-02-05-22-55-58-511 33 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
(QUERY) Fix null value isn't show in csv outputSummary: When export as xls or view online it show header with all of null value, but header is disappear in csv output Content (required): Hi, I wanted to fix the data … -
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during…Rob Stahly 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report for ChecklistSummary: OTBI report for Checklist Content (required): Tring to create OTBI report for Checklist for a questionnaire, however, the questions are not reflected nor the re…
-
Missing columnsSummary: Not appearing columns heading when records are exported. Content (required): We have created query to export data which has been generated in xml. However, when…
-
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…Hem 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…Visu 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Attendance Summary ReportSummary: Does anyone have a report where you can see a summary of absences by plan type for an employee? Would like to audit and keep track of usage against balances. Al…Tristan Aquino 45 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom Balance ReportHi We have a requirement to display custom balance details in the report along with some other employee/payroll details , so I would like know whether to go with BIP or …
-
Database mapping documentsSummary: We've recently moved to 21D but the latest database mapping document we have is REL13_21_C_HCM_OTBI_Database_Mapping_with_ViewObjects can anyone point me in the…User_A80ZS 42 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to search for text string across all BI componentsSummary: Content (required): I need to find all BI data models and report templates referring to specific attributes. Has anyone tried to do this, or have an idea how we…Scott Paulin 41 views 11 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM