OTBI
Discussion List
-
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 352 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
-
Adding Department to existing report - Employee Absence CalendarSummary: We are using the report - Employee Absence Calendar - from here - https://community.oracle.com/customerconnect/discussion/70219/employee-absence-calendar/p1 it …Ian.Gooderham 61 views 6 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Why do I keep getting an error when trying save an agentSummary: I am creating a new agent, when I save I get the below error? Any ideas why. Thanks! Content (required): Version (include the version you are using, if applicab…Lisa_R 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Performance Document RatingsSummary: Performance Ratings from 2 different performance documents on the same row. Content (required): I'm reporting on End of Year Review ratings but need to pull in …David McLellan 52 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Rescheduled agents are running twiceSummary: We've run into an issue with rescheduled agents running twice - once at the origninally scheduled time and again at the new time. Content (required): When viewi…Kelly Basnett 43 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab…
-
Need inputs to use all secure views in the reportSummary: Need inputs to use all secure views in the report Content (required): If we want to display Core HR data like Person, Assignment, Position, Job, Department..etc…
-
Calculation Card Reporting - CitySummary: We need a way to report on employees that have a split percentage city tax (part work city & part home city to represent working partially in office vs. remote)…Chelsea Holden 31 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
How to get the two rows of data in single row in OTBISummary How to get the two rows of data in single row in OTBIContent Hello Team, I am using organization hierarchy in one report, we have two tree codes here, i want to …Harish Kumar Kovi 375 views 3 comments 0 points Most recent by Vinay Soni Reporting and Analytics for HCM