OTBI
Discussion List
-
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated… -
Educational Major meaning in OTBISummary Only code is available in Person ProfileContent Hello Everyone!I need your help again. We are building and Educational report and the Major information a code ("…Alvaro Couto 31 views 5 comments 1 point Most recent by User_2025-03-07-05-33-11-638 Reporting and Analytics for HCM -
HR Action Original creation dateSummary Report on HR Action original creation dateContent Hello, Has anyone written a report of HR Actions history that includes original action entry (creation) date? I…User_2025-02-04-15-06-22-759 81 views 5 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
How to combine two rows of text data into a single column in OTBI?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: How to combine two rows of text data into a single colum…Priscila Terazawa - Support-Oracle 662 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to find encumbrance in PPM OTBI Subject AreasSummary: HI Team, I want to find encumbrance in OTBI Subject Areas. Can you please help me to find same. Regards Nidhi Content (required): Version (include the version y…
-
Requested feedback reportContent We are trying to build a report to get the requested feedback details using ‘Workforce Performance - Requested Feedback Real Time’ subject area. However, no data…User_2025-02-05-23-59-37-171 115 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Payroll Arrears Audit ReportSummary Allows you to audit for any arrears deductions prior to finalizing payrollContent This audit report is run after the first payroll calculation to check for arrea…Becky Stalsby 255 views 4 comments 4 points Most recent by Stephanie Turner Reporting and Analytics for HCM -
OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning valuesSummary: We have. a dashboard that contains an analysis and a prompt. The prompt is based on the following sql query: SELECT 0 s_0, "Product Management - Trading Partner…Hassan El Bouihi-Oracle 51 views 3 comments 0 points Most recent by Wim Bos [MLE] Product Master Data Management
-
Tenure in Job FamilySummary: Content (required): I am looking for time in job family. I have reports already for overall tenure and time in current assignment/job but need something for job…Riti Malhotra 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to properly address P2T ERP missing subject areas when support remains unresolved after a week?Summary: Missing OTBI subject areas after every clone, support unresolved Content (required): Every clone has same issues with OTBI subject areas missing. We follow SR g…Melissa Goodrich 21 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
Report to fetch the timecard approver detailsSummary: Content (required): We have a client requirement to build a report to fetch the timecard approver details. Does anyone know whether it is possible to fetch the …Prajna Hegde 141 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is there an attribute in PPM that shows the Return on Investment (ROI) of a Project or Program?Summary: In Project Performance or Program Analisys or OTBI, is there a collumn that represents the return of investiments? I didn't find this field. ROI = (Gain from In…Wilromar Benevides 31 views 2 comments 0 points Most recent by Wilromar Benevides Project Management
-
Secure OTBI so user can see only 1 folderSummary: We are implementing EHS and want the safety managers to only see the EHS folder under the custom folder. Content (required): Do we need to apply permissions to … -
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 351 views 8 comments 0 points Most recent by Sandeep001rp Reporting and Analytics for HCM
-
Does a CLOB column supported by Advanced SQL Tab in OTBI when combining two subject areas?Summary: I always get an error when I tried combining two subject areas in OTBI under Advanced tab which consist of a CLOB column such as comments. Does anyone know how …Hazel De Castro 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Folder Security in Question LibrarySummary: Hi Experts, In our project there is a requirement to secure the folders created in Question library under Task name : Define Questionnaires. We have capability … -
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType… -
Reporting issue - How to show sickness days vs actual worked daysSummary: Reporting issue - How to show sickness days vs actual worked days Content (required): I am trying to write a report to show the number of days a person is contr…User_2025-03-07-06-11-23-192 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM