OTBI
Discussion List
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
How to get Award Approval Date in OTBI?The item in OTBI has Award Date and Award Completion Date, but the item in Award Approval Date does not exist. Where can I get it? -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
OTBI - Performance Subject area & field to pull Evaluation Topics, Perfomance and Core Value ratingsSummary: We need a report that pulls the manager ratings and comments from the Evaluation Topics section for the performance and core values. Content (please ensure you …Denise Izzi 143 views 2 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav…
-
BIP Reports Metadata tablesSummary need Metadata tables for BIP reportsContent I am looking for the fusion table(s) that store metadata of reports (such as created by and timestamps). can someone … -
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Control Budget data in OTBISummary: Hi We have some users who do not have the budget manager role. Can we write OTBI reports or BIP reports for them to view the real-time data (these users don't h…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI ReportHi All, How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI Report like below image?. Please share us your Ideas or Implementati…Sukumaran Ayyaswamy 31 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?prags 63 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tip on how to remove the dashboard header when embedding in a screenSummary Tip on how to remove the dashboard header when embedding a dashboard into a custom pageContent I have been asked a few times recently if it is possible to embed …Caroline Gladwin-Oracle 409 views 7 comments 10 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 41 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Requisition PDF Report With Data Model,Custom translation file does not workSummary: 1-We want to customize the layout for the new (Requistion PDF report with data model) 2-After create a new template with locale (English) Language 3-We extract …Mustafa Abu Dayeh 11 views 2 comments 0 points Most recent by Mustafa Abu Dayeh Self Service Procurement
-
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, VipushaVipusha Chandrakumaran 80 views 7 comments 2 points Most recent by RyanPasca1 Reporting and Analytics for ERP
-
Disable email notifications for Non Catalog Learning ItemsSummary: Hello We would like to disable any notifications for non-catalog learning items added but can;t see any documentation on how to do this. It isn't controlled via…
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 31 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 32 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Balance Sheet by Project: Does this necessitate a project GL Segment or is there another way?Summary: We are in the design phase of a Financials and PPM implementation. Customer desires Project Balance sheets. Other than creating a GL segment for project (not be… -
Is there a way to review users' usage of self service procurement?Summary: Is there a report which we can run to review when users last used their access to self service procurement, in order to manage which users require access? Conte…
-
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su…JanardhanaKondaveeti 177 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…Venkatesh Babu Somalinga 203 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Looking for Issue description and resolution querySummary: Content (please ensure you mask any confidential information): Dears , I am working on a query to get issue description and resolution , I found them but I coul…Beshoy Hakim-Oracle 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 11 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…Darwin HP 81 views 4 comments 1 point Most recent by Darwin HP Reporting & Analytics for Fusion Service -
In OTBI Offboarding Clearance Journey Report Assigned To is not populated for the checklistSummary: In OTBI Offboarding Clearance Journey Report Assigned To is not populated for the checklist where a group is assigned. Also Completed By is not available in OTB…