OTBI
Discussion List
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 114 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM -
Termed employee report with both Manager hierarchy AND final salarySummary: Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary? Content (required): Has anyone written an O…User_2025-02-04-15-06-22-759 21 views 1 comment 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting on Investigation QuestionnairesSummary Looking for a way to report on investigation questionnairesContent Hi Experts! Does anyone know if it is possible to report on the investigation questionnaires w…Lindsay Lamont 53 views 9 comments 0 points Most recent by Sacha Agostini Reporting and Analytics for HCM -
Assigment changes- help needed in reportsContent Hi, Is someone can share his knowledge regarding report which can indicate what are the fields in the transaction that were changed(which field). The report is s…User_2025-01-22-19-54-47-882 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 11 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
How do I turn an OTBI Dashboard into an Infolet?Summary: Looking to convert some of the delivered dashboard into infolets Content (required): Version (include the version you are using, if applicable): Code Snippet (a…Jean M Christenson-Oracle 64 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Historical Position Change Report All In OneSummary: Our Benefits team wishes to have a report to view historical employment data in one snapshot, to aid in our retirement eligibility process. Does a report like t…User_2025-02-11-20-55-10-551 31 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch…Raghavendra M 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Min, Mid and Max Salary Ranges missing for some associates in OTBI Report. How can we fix this?Summary: Unable to pull Salary Range Min, Mid and Max for some associates in OTBI report. Content (required): Hello, While pulling a report created in OTBI the Salary Ra…AH SL 38 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to translate link text in Analytics Dashboard?Summary: How to translate link text in Analytics Dashboard? Content (required): We have created a dashboard with link tool, now the requirement is to translate the capti…Punam Roy Karmokar 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Data is not coming oracle seeded HCM OTBI reportsSummary Data is not coming in oracle seeded HCM OTBI reportsContent When we go to path Shared Folder --> Human Capital Management --> Workforce Management --> Transactio…User_2025-02-07-13-23-10-820 26 views 8 comments 0 points Most recent by Nirmal Reporting and Analytics for HCM -
How to extract Termination Notification details which are still under approvalSummary: I am trying to create a query to extract Termination Notifications, which are still under approval. Following is the query that I prepared. But it's ending into…Dharmendra Shukla 51 views 7 comments 0 points Most recent by Akhil M Reporting and Analytics for HCM -
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 63 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Learning community reportContent Hi does anyone have a learning community report they could share? Kind regards MelissaUser_2025-02-06-11-18-47-896 57 views 4 comments 0 points Most recent by User_2025-02-06-08-05-57-271 Reporting and Analytics for HCM -
Success Criteria (HTML Tags) are not exported to excel- ErrorSummary: A few days back, I was able to download the development goals success criteria on EXCEL with data format set to HTML. However it is not working now. I have to c… -
Need OTBI/BI query for checklist QuestionnaireSummary Need OTBI/BI query for checklist QuestionnaireContent Hi All, We have created Off boarding checklist and we are planning to develop a report(OTBI/BI)based on que…User_X612P 232 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
i'm not able to read finance data related to over time and training expence in custom HR dashboardSummary: Hi i used finance subject area (General ledger-Transactional balance real time) in HR dashboard but system is not allow to me to select subject area , i think t…Mahgoub S.Mohamed 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Duplicate a page in Dashboard - OTBISummary: Content (required): Hi there How can I duplicate a page in an OTBI Dashboard? Thanks Bobby Version (include the version you are using, if applicable): 21C Code …Bobby Jourdan 1 view 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 41 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Catalog of Payroll Flows Dashboards in OTBI reportingContent From 21C or 21D release onwards, following OOTB Payroll dashboards will be deprecated: * Active Processes Dashboard * Payroll Flow Details Dashboard To continue …Tanvi Jain-Oracle 283 views 6 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 21 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Dashboard- Headcount to be represented as a % - By Length of Service per GradeSummary: I am looking to represent length of service per grade as a bar graph showing % of headcount . I am able to achieve this when using stacked 100% or presenting th…Anita 42 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Phone Numbers Comparision ReportHi Experts We have client requirement for design a report which pulls up Employee details along with their work and home phone numbers. The inputs are Start Date and End… -
Can you tie Worker Assignment Event Real Time to the HCM Approval Notification area?Summary: We have a request to pull all terminations during a defined time period for a certain Business Unit and then show when the termination transaction was initiated…Cheryl Burwell 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Transaction Status DashboardSummary HCM Transaction Status DashboardContent Hi Team, Do we any dashboard to monitor all HCM transactions? Thanks. Version 20B -
OTBI - Not returning Most Current Assignment RowSummary: OTBI - returning more than just the Most Current Assignment Row. This began happening after our 21C update. Content (required): Hi, I'm creating an OTBI report … -
Comparison between the content provided by latest Cloud HCM OTBI and Fusion HCM AnalyticsSummary: Is there any comparison available between the content provided by latest Cloud HCM OTBI and latest Fusion HCM Analytics. Content (required):If a customer has to…Mangesh Bhanage 51 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Document of Record ReportingSummary Document of Record ReportingContent As HR we are trying to report off the Workforce Management - Document of Record Real Time to look at employees and try and se…Matthew DeCilio 93 views 10 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Reg OTBI CountHi we are have OTBI report which gives the count of enrollment for each plan , for some of the plan no emp is enrolled ,in the report we are not getting this plan detail…User_7836 31 views 10 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 147 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM