OTBI
Discussion List
-
OTBI reports sent via Email are causing performance issuesSummary OTBIContent Hi. I have noticed that most of the OTBI reports I schedule using the agent and send via Email are causing lagging issues when the user tries to open… -
Query on the subject area: Human Capital Management – Transaction Administration Real TimeSummary Query on the subject area: Human Capital Management – Transaction Administration Real TimeContent Hi, Am I correct to say that the subject area 'Human Capital Ma…Karen Waddell 76 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Preferred Browser for OracleSummary I would like to know what is the preferred browser to use for Oracle applications. Can you provide documentations?User_2025-02-06-07-21-22-662 31 views 2 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Day Difference excluding weekends in OTBISummary Day Difference excluding weekends in OTBI From Workforce Management - Absence Real TimeContent Hi All, I need to calulate the difference between two dates - Abse…Dharmendra Jha 40 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours …User_MC37Q 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its …Jagdish Varadraj 53 views 8 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 48 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 272 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
OTBI: how to achieve UNION ALL operation in OTBISummary OTBI: how to achieve UNION ALL operation in OTBIContent Hi, We need to replicate BIP's UNION ALL operation in OTBI Is it possible? Regards RashmiUser_MC37Q 91 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Trend Headcount by Assignment StatusSummary We require a report that displays headcount for each month for the last year, but it should only count those employees with a specific assignment status.Content …Derrick Campion 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…Suganthi Srinivasan 95 views 4 comments 5 points Most recent by Venkatraman G Reporting and Analytics for HCM
-
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 51 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 94 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 80 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…Mansur Khalil 43 views 3 comments 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u…
-
OTBI Custom Dashboard PromptSummary Looking for ideas on Custom Dashboard PromptContent Hello, We want to create a custom dashboard prompt to add to the other list of prompts. We need a prompt for …Tony Puentes 92 views 7 comments 0 points Most recent by Tony Puentes Reporting and Analytics for HCM
-
Usage TrackingSummary OTBI Usage TrackingContent Is Usage Tracking available for OTBI Reports? Something like in 20A for BI Publisher reports? Or even that which is available for OBIE…User_2025-02-05-23-02-10-916 97 views 6 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Summary Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Content Hi Experts, We are looking for a requirement to fetch Hire date change…Harish Kumar Kovi 56 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Using Subject ID in Transaction AdministrationSummary How do I use Subject ID to join to other Subject Areas to identify employee impacted by transaction by nameContent I would like to create an OTBI report on faile…User_2025-02-04-08-27-17-553 54 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 23 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas…Julian Challenger-Oracle 66 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H…Andy Whalen 59 views 2 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a…Sriharsha Devraj 52 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed …
-
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…Kei Sato 38 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Identify if comma is present in a fieldSummary How to do that in OTBI?Content Hi, we need to embed the following logic into OTBI report (CASE WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_nam…Nicola Petri 14 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI Bursting ReportSummary Bursting report is not splitting out rows to recipientsContent Hello! I have an OTBI bursting report for absence balances. I've included a column with the user n…Susan Anderson 95 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM