OTBI
Discussion List
-
Holiday Calendar - Subject AreaSummary Holiday Calendar - Subject AreaContent Hi Team, Can anyone know how to pull public Holiday calendar in OTBI report. Please share if we have any subject area for …User_4VVG2 37 views 2 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM -
US Affirmative Action ReportingContent Hello, I was wondering if any had report examples that they use for AAP reporting? I have a few job change reports, but none that combine job change values and s…User_2025-01-31-00-25-12-234 123 views 4 comments 1 point Most recent by AlyssiaKing Reporting and Analytics for HCM -
Termination ActionSummary Where is Termination Action in OTBIContent Good afternoon We have created a leaving report in Work Relationship Real Time subject area however the Termination Ac…Dawn Cawston - CPS 62 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Personal Payment details - cannot include Person NumberSummary Target Bank Details report returning limited results when person number is includedContent Hi, I'm running a very basic query in OTBI to show the Target Bank Det…
-
Performance Standard ReportContent Hello Guys, Could someone explain the meaning of these standard reports, I can't understand them :( I hope in your help, Best Regards, GiuseppeGiuseppe Iacono 18 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report not showing all dataSummary Some users see only their data in OTBI reportContent Hi Experts, OTBI report is showing only user data for some users. These users can see all data in applicatio…Rakesh Lathiya 2018 94 views 7 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM
-
Analysis for Displaying Legal Employer wise Monthly wHeadcount and Monthly CTC For the YearSummary Need to develop an analysis which will display Legal employer wise monthly Headcount and Monthly CTC . Here Year and Month are PromptsContent Could please explai…User_2025-01-30-17-37-30-647 27 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compare Employee Status to Last Week in OTBISummary Want to be able to show only employees with a change in status in OTBIContent Hi, I am trying to create a report that only shows me employees who have had a chan…tiffnyc 27 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Remove Borders from DashboardSummary How to remove Table border from Dashboard using OTBI analysisContent How to remove the border lines for table layout in Dashboard using OTBI analysis, i tried th…Jagdish Varadraj 34 views 6 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Payroll Element Entries History Real Time subject area is taking lot of time to run and getting timeSummary Payroll Element Entries History Real Time subject area is taking lot of time to run for single BU also and getting exceeded time out errorContent Dear All, I hav…Vijaya Kumar Komari 41 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Bursting & Agents - Email Encryption, Password Protection etc.Content Hello Community, Is there any HCM security feature such as email encrpyption and password protection of xls file in case we want to send any sensitive informatio… -
Join Transaction Data with Assignment DataSummary How do I find hire transaction completion dates for certain assignment categories?Content Hello - I am trying to create an analysis in OTBI that compares the dat…User_2025-02-08-04-27-03-855 40 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Pass Binding Parameter to Embedded OTBI Analysis on Fusion pageSummary Pass Binding Parameter to Embedded OTBI Analysis on Fusion pageContent Hi Experts, What is the exact method to pass a binding parameter available on Fusion Page …Salman 236 views 2 comments 2 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Use session variable to show only Health and Safety incidents for the user logged inSummary Recording demonstrates steps to get display name of user logged in and pass as a sub report to query incidents for user logged in.Content Overview of steps: * Cr…Stephanie Golly-Oracle 102 views 4 comments 7 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
% Veterans by Assignment ManagerContent Hello, I'm trying to get % of veterans for a manager hierarchy when logged in as an HR user (access to all workers). I can calculate the % of veterans for the wh…Susan Anderson 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
manager phone number details in OTBI reportSummary Is there a way to get manager phone number details in OTBI reportContent Hi All, We have a requirement to capture manager phone number in the report. trying to b…User_XT9HW 88 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subjectSummary What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subject area "Transaction Administration Real Time" ?Content The pend…Sreedharan-Oracle 23 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI formula to remove all the special characters from a column valueSummary OTBI formula to remove all the special characters from a column valueContent Hi, I am trying to remove all the special characters from a column value in OTBI ana…User_MC37Q 570 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch the time card exceptions using OTBI/BIP report?Summary How to fetch the time card exceptions using OTBI/BIP report?Content Hello Team, We are trying to build a report where we need to show the details of person and t…Harish Kumar Kovi 67 views 2 comments 1 point Most recent by Sai1654 Reporting and Analytics for HCM
-
OTBI Subject Area for availability patterns of a employeeSummary OTBI Subject Area for availability patterns of a employeeContent Hi, Anyone knows subject area to get availability patterns of an employee? Regards, RashmiUser_MC37Q 34 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Securing CatalogSummary Securing CatalogContent Hi, we are going to make the reporting tool (OTBI) available to our HR end users. First we will like to create some security around the i…User_2025-02-05-08-23-23-591 50 views 3 comments 2 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
OTBI: how do we check if one column value is present inside another columnSummary OTBI: how do we check if one column value is present inside another columnContent Hi, Need a logic to compare if one column value is present inside another colum…User_MC37Q 66 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeSummary Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeContent Hi, I have a query on OTBI subject area: Payroll : Personal Payments Deta…User_MC37Q 64 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Aggregate actions, and make it consistent across languagesSummary Aggregate actions, and make it consistent across languagesContent Hi, we need to aggregate action and make it consistent across languages in OTBI. I modify the f…Nicola Petri 18 views 6 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Future-dated department showing up in report instead of current dataContent Department attribute in 'Workforce Performance - Performance Task Status Real Time' subject area is fetching future-dated assignment information for employee ins…User_2025-02-05-23-59-37-171 33 views 9 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM
-
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. JyotiUser_2025-02-06-14-37-05-233 23 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Looking for Transfer Compensation Change ReportContent Hi, I am in need of Transfer Compensation and Location Change report. Please help. Thanks, JyotiUser_2025-02-06-14-37-05-233 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on when someone became a line managerContent Has anyone developed a report that allows us to see when someone first has a direct report assigned to them or knows of anyway to do this? Version 20BUser_2025-01-31-00-25-12-234 20 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…User_2025-02-07-19-03-14-525 36 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Descriptive FlexfieldsSummary Deploy Descriptive Flexfields to Unified Sandboxes [HCM 20B]Content Please provide information of new features in Deploy Descriptive Flexfields to Unified Sandbo…User_080V4 46 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM