OTBI
Discussion List
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 43.5K views 193 comments 127 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi…Marilyn O 5 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…
-
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar…User_F89L9 233 views 5 comments 2 points Most recent by Sasank Reddyy Reporting and Analytics for HCM
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.3K views 17 comments 4 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…CB Trett 256 views 12 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.7K views 21 comments 3 points Most recent by Raymund J Reporting and Analytics for HCM -
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one …Elavarasan S 24 views 8 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Redwood Issuing Comments field in Document Record Displays html Text in OTBISummary: We just implemented Redwood for Document Records. The Redwood field for Issuing Comments (seeded Oracle field) displays as a rich text editor field where bold, …Linda Chirash 15 views 5 comments 0 points Most recent by Linda Chirash Reporting and Analytics for HCM
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 3 views 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 261 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R…Julie S. 9 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 16 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…Srushti 74 views 18 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "…Phillip Jones 58 views 17 comments 0 points Most recent by KMChris-Oracle Reporting and Analytics for HCM -
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 18 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…Jeevan Loyal 46 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…CHolden 285 views 8 comments 1 point Most recent by Florencia Maletto Reporting and Analytics for HCM
-
Roles and Privileges Real TimeI am required to show the date when a user was assigned a role. Is that possible either with this subject area or through a custom query. My output needs to be: Person N…David Boudreau 19 views 4 comments 0 points Most recent by David Boudreau Reporting and Analytics for HCM
-
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
Transaction Console Subject AreaGood Day Experts, May I know what subject area to use to get processes from Transaction Console? The following are the process name: - Manage Salary - Change Personal In…JMLMIII 106 views 8 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…