OTBI
Discussion List
-
OTI Query for Fetching Free Text Fields from QuestionnaireDear Community, I am working on an OTBI report and need some help with querying data from a questionnaire called "Student Touchbase". The Questionnaire consists of sever…Ashok Kumar Sharma 51 views 14 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
https://community.oracle.com/customerconnectHow can I get employee's dependent detail and emergency contact number in OTBI reportAnup Karmankar 12 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 51 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Level 02 Organization Name are not generating in the HR Help Desk ReportsThere is a requirement to include the Level 02 Organization Name in the Help Desk Report. However, after adding the columns 'Level 02 Organization Name' and the suitable…Anu shree 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - what is Worker Creation DateIn OTBI, when looking at the subject areas in the analysis reports, what does the following mean: Subject area: Workforce Management - Worker Assignment Real Time Folder…
-
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
Worker Assignment Event history - job title / position title as of assignment effective dateSummary: When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are…Hunter Kennedy 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use AOR subject area to show active AOR's for inactive assignments?Summary: Trying to get a list of inactive assignments with active AOR Content (please ensure you mask any confidential information): I'm trying to use the subject area "… -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 41 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 1 view 0 comments 0 points Started by Giuseppe Iacono Reporting and Analytics for HCM
-
Report/Dashboard about Performance ModuleContent Hi Guys, Does someone know where could we find Performance Reports or Dashboards standard? I hope in your answer, Best Regards, GiuseppeGiuseppe Iacono 68 views 5 comments 0 points Most recent by Dileep Reddy Vattimi Reporting and Analytics for HCM
-
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem…CCannadayCTR 11 views 2 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma…User_2025-02-11-03-07-51-707 36 views 3 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…Suda.V.Ra 13 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Combining multiple max formula criteria in OTBI resulting in no values returningSummary: I'm having trouble pulling in someone's latest record or assignment in a report without it creating multiple line items for their various Job Names. When using …
-
24B Feature Talent Management REPORTING ON PROFILE ATTACHMENTSSummary: When perform the Analysis, report unable to show the link on Profile Attachment attached. Are we supposed to have link to view it? What is the different between…Eyan Shahrin 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Actual Revenue VS. Budgeted RevenueSummary: I want to make a dashboard of Actual Revenue VS. Budgeted Revenue. Which subject area could be used for this query? Comparison is required between 2024 Budget, …Khalood 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI HelpSummary: Need help to get last day of the current month in OTBI. Content (please ensure you mask any confidential information): Version (include the version you are usin…Reddykrishna Chidella-Oracle 12 views 2 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
Logical SQL: How to Calculate Response PercentageHi Community, I have BU, ResponseCount and BUTotalCount columns in my Logical SQL based report. Response Count: It is number of responses from employees on a questionnai…Ashok Kumar Sharma 11 views 6 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Embed a Link on the Dashboard to take to Submit a Flow page in HCMSummary: Like Deep Links/Action Links, can we have a LINK on the OTBI analysis/dashboard to let the User submit an HCM extract via the Submit a flow page. Content (pleas…Vibha Pandey - Oracle 11 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Reporting on future dated positions using OTBI 'Position Real Time' subject AreaSummary: Is it possible to report on future dated positions using the 'Position Real Time' subject Area in OTBI? Content (required): I current report on all active posit…Paul Morrissey 51 views 4 comments 1 point Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Formula for "Begins with"Summary: How to write a Formula that says If Department Begins with 3 THEN "Division1" I know how to write the standard formula using CASE(IF) but not sure what function…THawkins_LGI 11 views 4 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Restrict Diversity fields from Person Real Time Subject AreaSummary: Subject Area - Workforce Management - Person Real Time Folder - Person Legislative Information Fields - Gender Identity, Sexual Orientation User should have acc…Bindu Vasa 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o…Susan Anderson 93 views 11 comments 0 points Most recent by User_MN692 Reporting and Analytics for HCM -
Legends not appearing correctly in graph viewHi, I have to create a graph where I have to show voluntary termination and total termination in one graph(region wise). I have created the graph but in the legend it is…Parul007 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM