OTBI
Discussion List
-
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 408 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 176 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… -
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 1 view 0 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How to make HCM Line Manager Dashboard available to HR Admin Roles ?Currently Line Manager Dashboard works only for its direct and indirect reports. We want it to execute under the Data Security of HR Admins, so that they can see data fo…RahulMore 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…Kameron Withak 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM