General Transactional Reporting (OTBI)
Discussion List
-
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo… -
Scheduler IssuesSummary Experiencing intermittent errors with scheduled reportsContent Is anyone else experiencing any issues with scheduled reports? In the last 24 hours, a couple of o… -
Editing Dashboard: Embedded ContentSummary I need to edit the embedded content on a dashboard but cannot - why?Content Hi all - our team copied reports from production to stage this weekend. I noticed tha… -
How to get roles assigned to BI ReportsSummary How to get the roles assigned to BI ReportsContent HiI need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). I…
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTHContent In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norma…
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sqlContent Hi, Anyone know how to fetch the manager name for the terminated employees? For …
-
Data model with parameter with "Select all"Summary Data model with parameter with "Select all"Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employee…
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1… -
Restricting access to OTBI Subject area and data elements within a subject areaSummary How do we restrict subject area access to a user through security role?Content Subject area access is driven by duty roles. A duty role 'Workforce Transaction An…
-
Time in role reportSummary I need to create a time in role reportContent I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Emplo…
-
Dashboard ReportSummary Dashboard ReportContent Hi all, Can we able to make the Dashboard and Report width size equally while we are using 2 layouts? I have highlighted in yellow color,…
-
Bursting ReportSummary A report on Probation which bursts out to Line ManagersContent is there any example reports which look at Probation Period? Also sample reports for Bursting?
-
Access Denied for user to path..Summary Access Denied for user to path..Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific use… -
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard?Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull …
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all dataContent Any suggestions on how to get the subtotals added to this report? Example below, want totals fo… -
How to schedule OBI Jobs using generic userContent Hi All, We have several reports in OBI which we schedule from our personal logic, but this is not correct we should have a capability to schedule them using a ge… -
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where …
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sqlContent Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to …
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etcContent I cannot find the following fields in the worker or any other subject area. Preferred Name,…
-
Conditional FormattingSummary Conitional Formatting is not working properlyContent I have created a report to help our teams identify at risk background checks. The report uses OBI conditiona…
-
Delivered Analytics on system usageContent Hello, I am part of another go-live of Cloud HR Core, different company. Does Oracle now provide any OBTI reporting regarding system usage to capture adoption/us… -
Adding Totals to Stacked Bar GraphsSummary Looking for a best practice for adding a bar total to a stacked bar graphContent Has anyone found a way to add a total to a stacked bar graph?
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin ViewContent In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but m…
-
InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate functionContent Names in our system are entered inconsistently and the goal is to be consistent with… -
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…
-
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel.Content Hi, I have one report which is automatically scheduled to be se…
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12?Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/unar… -
Adding two measures not workingSummary Adding two measures not workingContent I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within th… -
Help with DashboardsSummary Help with DashboardsContent I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test to…