OTBI
Discussion List
-
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 61 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
OTBI Community - Course detailsSummary OTBI display all Community - Course detailsContent Just wondering if anyone has been successful in creating a report with all courses listed against a Community …User_2025-02-05-23-02-10-916 77 views 3 comments 0 points Most recent by User_2025-02-06-08-05-57-271 Taleo Learn -
Learning community reportContent Hi does anyone have a learning community report they could share? Kind regards MelissaUser_2025-02-06-11-18-47-896 56 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 242 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 -
Reconciled Transactions ReportSummary: Reconciled Transactions Report and UnReconciled Transactions Report Content (required): What are the prerequisite for using these report. Whats setups involved …CraigX 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
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 302 views 6 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Reporting on Supporting Reference Balances for a secondary ledgerSummary: When reporting on Supporting References in OTBI the values associated with secondary ledgers exist in the "Subledger Journals Real Time" subject area but not th…Daniel Martin 41 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
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 41 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Identifying managers in OTBISummary How to identify a list of workers who are managers in OTBI for us in an analysis destinationContent Hi everyone, I've posted this topic in the Core HR forum, but… -
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…