OTBI
Discussion List
-
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 1.2K 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 31 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 51 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 321 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 11 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
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
-
Record Identifier In GL InformationSummary Record Identifier In GL InformationContent Is there any additional info resubject area apart from this note. Record Identifier In GL Information under Manager De…CraigX 70 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
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…
-
Checklist not assignedSummary Checklist not assignedContent We have multiple onboarding checklist by country etc and want to report where one of these checklist has not been assigned to a new…Emily Robinson 53 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report requiredSummary: GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required Content (required): Business wants seeded report/query to show GRN has … -
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
-
Extract Draft Status on ECO for a Report in OTBISummary: Business needs the ability to see what Change Orders have a Status in Draft to better understand metrics. Per SR 3-28465964691 this is not something Oracle OTBI… -
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 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BOM Cost Report for Average costingSummary: Customer is requesting for a BOM Cost report. But the available one in OTBI is applicable for Standard Costing (as Scenario information is required as parameter…
-
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
What is the Subject Area for the new MCR fields?Summary: Trying to locate the Role_identifer and the Teacher Reference Number. They are both showing in the employment screen but cannot find them in the assignment subj…
-
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …Mitch_123456 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM