OTBI
Discussion List
-
Missing Talent Profiles on ReportsContent We are doing an HDL for License and Certifications and we are missing about 1200 employees when we try and pull the profile report attached. When we pull up one …User_2025-01-31-00-25-12-234 92 views 7 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily …Prudence K 33 views 2 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 138 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
Citizenship FieldContent Hi Guys, I don't able to find the field "Citizenship", some one know in which subject area can I find it? Best Regards GiuseppeGiuseppe Iacono 40 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
My Team Tab - Adding BI Catalog to PageSummary Adding BI Catalog to PageContent Background: We are planning to only use infolets as the primary channel for managers to access "reports" in HCM. We also want ma…User_2025-02-04-10-47-55-876 82 views 5 comments 2 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…User_2025-01-25-01-17-59-580 53 views 9 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Person running report not showing up on reportSummary Inaccurate dataContent I've created a few different report and I've found that when I run the report my data is not on present. This causes issues for our payrol…User_2025-01-31-00-25-12-234 47 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Reporting on Employee Schedule ChangesContent Hi, Has anyone built reports around employee schedule changes? For example, if a manager goes into Time Management > Manage Planned Schedule and changes the sche…Dishti Malhotra-Oracle 56 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
Merged ColumnsSummary How to prevent merged columns in reports?Content Hi Everyone, I noticed that some of our reports come out with merged columns, which always throw off our sorting…User_2025-01-29-23-59-58-976 61 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM
-
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future …Mike Borghoff 53 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Assignment Name vs Job NameSummary Report comparing Assignment Name and Job Name to list differencesContent The Oracle bug where Assignment Name and Job Title (Name) are different causes our downs…User_2025-01-23-21-24-21-434 62 views 10 comments 0 points Most recent by Debo Reporting and Analytics for HCM
-
column information for PAY_ACTION_INFORMATIONSummary PAY_ACTION_INFORMATION Developer DFF Columns detailsContent I am looking for details on action_information1...300 columns in pay_aciton_information. what data is…Rakesh Lathiya 2018 119 views 2 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM
-
Nesting Case statements?Summary Is it possible to nest Case statements in otbi?Content I am working on a recurring report that requires me to classify people based on certain characteristics. I…Cheryl Burwell 58 views 3 comments 0 points Most recent by User_2025-02-04-18-47-48-634 Reporting and Analytics for HCM -
HCM CLOUD BENEFITS (OTBI) Open Enrollment DashboardSummary The goal of this dashboard is to assist the benefits department management of their employee benefits data and the downstream actionable benefits data throughout…Adam Gates-Oracle 480 views 25 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e…User_2025-01-28-08-17-22-037 158 views 2 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Summary Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Content Hi Team, Is it possible to get Previous/Prior Salary Frequency like Annuall…Harish Kumar Kovi 55 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Create performance titleContent Hi Guys, How i can realize a performance title that show the Learn Count for each plan cycle name? Best Regards GiuseppeGiuseppe Iacono 13 views 1 comment 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Performance Document - Report on Core RoleContent Hi Experts, We have customized the core role section recently. Please find the screenshot of New Core role section attached. Can you please guide me how i can re…User_2025-01-30-00-14-06-021 20 views 12 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
3 Basic Payroll OTBI (BI Answers) ReportsSummary Element Entries - Payroll Results - Costing ResultsContent XML is ready to be copied and pasted into the XML section on the advanced tab of any subject area. Hop…Becky Stalsby 192 views 5 comments 8 points Most recent by Annette M Reporting and Analytics for HCM -
HCM Location for Manager Self-Service ReportsSummary Where are other companies, placing self-service reports in HCMContent The manager experience we are designing for HCM is to provide infolets as the primary chann…User_2025-02-04-10-47-55-876 54 views 6 comments 3 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT LEAVE CASES.Summary BI Report to achieve SANDWICH ABSENT LEAVE CASES.Content Please Kindly Help us to achieve these scenarios in BI Reports. Here below are the two scenarios, We are…Ravikanth Rao Thota 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi…Shanna Oppenheim 52 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
List of employees that are LINE MANAGERSSummary List of employees that are LINE MANAGERSContent Employee Details that are Line Managers Hello Community, Could anyone share a sample report which will list down …Prosenjit Manna 72 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
All pre-built reports for HCM and FinanceSummary All pre-built reports for HCM and FinanceContent Where do I get full list of pre-built (OOTB) reports (OTBI and OBIA) for HCM and Financial? I got bits and piece…Vijay Gorania 133 views 4 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM
-
Changes to 19b patch affected custom fieldsSummary Changes to 19b patch affected custom fieldsContent Hi all, We have custom fields under Workforce management - worker assignment real time > Location. After 19b p…User_2025-02-05-05-51-12-049 31 views 2 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
Employee Roster by Month Including Hours WorkedContent Does anyone have an example of a report that can be selected based on a begin/end date and list all employees with an active assignment for a specific department… -
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…User_F89L9 79 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
19B Release causing report issuesSummary OTBI Report with Location GL field is breakingContent 19B released over the weekend. Noticed that reports that have Location GL field are causing ODBC error now.…User_2025-01-28-20-43-56-568 56 views 5 comments 1 point Most recent by Linda Dunn Reporting and Analytics for HCM
-
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job…Dena Swanson 39 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM -
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…User_2025-02-04-11-13-27-138 93 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM