OTBI
Discussion List
-
Report that identifies when an employee becomes a manager of peopleSummary: Is there a way to build an report that will identify when an employee (non-manager) becomes a manager (people leader). We utilize the "Working as a Manager" fie…S. Johnson 28 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get completion record for learning activities under course and offering?Summary: Hello, I'm trying to create a report for completion of activities. Can anyone point me where to find from the Workforce Learning - Learning Records Real Time su…
-
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?Summary: Content (please ensure you mask any confidential information): One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can… -
How to have the report names show when embedded on the left side bar?Summary: Hi there, We are embedding reports as pages/tabs to the left side of certain pages I'm not sure how to get the name of the tab to show. Is there a setting that …Ruby Hui 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 286 views 25 comments 0 points Most recent by ZeyadAbdullaMohamed Reporting and Analytics for HCM -
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally…
-
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this? -
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…User_53LLL 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Reporting Agent failed with error message SQLSetStmtAttrWSummary: We have reporting agents set up which all ran into error, when normally no issues. Content (please ensure you mask any confidential information): We have report…Max W 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 578 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBISummary: We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some …Balakumar231286 68 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 3 views 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM
-
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf…Claudia Linares L 21 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 43 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
OTBISummary: Hello Everyone, Unable to access OTBI reports data, able to access BI reports using her current roles Thanks Krishna Content (please ensure you mask any confide…Krishna Sigilipalli 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b…
-
Subject area to pull checklist questionnaire in OTBISummary: We are trying to develop reports on questionnaires that have been configured for checklist. But when we are using "Workforce Management - Checklist Real Time", …Priyanka Ray 37 views 4 comments 0 points Most recent by Priyanka Ray Reporting and Analytics for HCM -
How to apply "Group By" Condition on a column - in OTBI Analyis?Content Hello Everyone, I have a requirement to apply "Group By" condition on OTBI analysis. I am applying this condition in under Advanced tab - Advanced SQL Clauses. B…Anil Pillaresetty 817 views 6 comments 1 point Most recent by gclampitt Reporting and Analytics for HCM -
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 3 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
People Group Segments Subject AreaSummary People Group Segments Subject AreaContent Hi All, In which subject Area I can find assignment people group segments while creating analysis ? Thanks.
-
The supervisor hierarchy should be displayed in the report as a graphical representation.Summary: The supervisor hierarchy should be displayed in the report as a graphical representation. Content (please ensure you mask any confidential information): Require…
-
Dashboard prompt dependentSummary: Creation of a Dashboard prompt with Job Family, Job Function and Job Profile field dependent from each other. Content (please ensure you mask any confidential i…
-
Remove Null value from Dependent LOV prompt in OTBISummary: When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL param…
-
Using SET VARIABLE PARAM_EFFECTIVE_DATESummary I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 daysContent I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix. I want to us…Chris Campbell 972 views 7 comments 0 points Most recent by Bharat Mandloi Reporting and Analytics for HCM
-
Prompt filtering based on another promptSummary: Hi, I have 2 prompts as presentation variables and I need them to connect between each other. For example when I selected a specific country on the first filter…