OTBI
Discussion List
-
How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li…Calin Pavel 61 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
How can I change the default aggregation rule (such as sum) in the Default Aggregation Rule settingSummary: I need to change the default (sum) through default simple without sum and it isn't working in OTBI using the Worker Assignment Event Real Time SA. Thanks Conten…ClaudiaManea 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo…Barile Alberto 93 views 2 comments 0 points Most recent by Francisco Barrios Reporting and Analytics for HCM
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Inaccessible columnSummary: This report is to fetch the personal contribution of an user. It is working file for everyone but one user. She is getting an error which is attached. I have tr…
-
Not able fetch data from Catalog Category Hierarchy using OTBISummary: Not able fetch data from Catalog Category Hierarchy using OTBI Content (please ensure you mask any confidential information): We are not able to fetch the data …Harish Vashist 31 views 7 comments 0 points Most recent by Swathikamburath Reporting and Analytics for SCM
-
Employees Missing in Compensation – Salary Details Real Time when using Matrix Manager FieldsSummary: Using Compensation – Salary Details Real Time , I’m experiencing an issue where employees drop from the report when matrix manager fields are added. For example…Mike Wulf 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …Rajdeep Chavda 11 views 2 comments 0 points Most recent by User_VQTGR Reporting and Analytics for HCM
-
How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p… -
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
Recruitment Candidate Question and Answers OTBI Report StructureSummary: I have been trying to change the layout of my OTBI report to have the candidate questions per column with their answers per row to avoid having multiple rows pe…GabrielaGilchrist 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
subject area for learning item in Development PlanSummary: Hi all, I am trying to retrieve the subject area for a specific section of Development Plan. 1. 2. So far I have retrieved all table info related to "Basic info…Silvia Stangarone CAI 11 views 2 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Need Sample and Confirmation of AnalysisSummary: Hi We have requirement to create analysis of procure to pay process (PR-PO-Receipt-Invoice-Payment). We need your help to give sample how to create analysis wit…
-
Extract of all Pre-Screening Questions and possible answersSummary: We would like to extract our entire library of pre-screening questions and the options on the multiple choice attached to the question. We have tried creating a…Diana Mitrovski 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
I need to find who created or updated a BIP or an OTBI report and whenSummary: We need to find details like who created a BIP report or a Dashboard or an OTBI report and when. Content (please ensure you mask any confidential information): …
-
OTBI report to pull BPFM hierarchySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagarani M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report cancelled work relationship person details in OTBISummary How to report cancelled work relationship person details in OTBIContent Hi Team, We have cancelled work relationship for some employees we wrongly loaded in wron…Pol Reddy 233 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font …Harish Vummidi 1 view 0 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
OTBI Dashboard Prompt with Presentation Variable - dependentSummary: Trying to create multiple prompts using presentation variable. goal is that prompt 2 will be dependent to filter values from prompt1 but using the variables. Is…
-
Percent of total Responses from Workforce Management - Checklist Real TimeSummary: I am trying to get an OTBI Analysis to return the Count of Responses to the Response Answers to specific Checklist Questions. In the example shown below I would… -
Scheduling OTBI reports to roles /user groups- How does access work ?Summary: If we have a simple headcount report built using Assignment real time subject area, and it is scheduled to a role (meaning multiple users with the same role but…Swapna Govind 1 view 2 comments 0 points Most recent by Swapna Govind Reporting and Analytics for HCM
-
OTBI – Calculate Percentage of Responses per Question in Learning Evaluation SurveysHi everyone, I'm building an analysis in OTBI using the Workforce Learning – Learning Records Real Time subject area, and I’m looking to better understand how learners r…Alessandra T. 1 view 0 comments 0 points Most recent by Alessandra T. Reporting and Analytics for HCM -
There are random end users that are unable to view the pdf when they print certificate?Summary: We have random end users that are unable to view the pdf when they print the certificate for a completed course; however, when they send the pdf link to other u… -
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …HCM_Dot 131 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
DFF deployed & processed correctly however entered data not showing in OTBISummary: Hi! DFF deployed & processed correctly however entered data not showing in OTBI. Does anyone know why data would not show up? We created new fields and the only…Jenny Truong-Scognamiglio 41 views 1 comment 0 points Most recent by Jenny Truong-Scognamiglio Learning -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 572 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to report on budget vs. actuals in OTBISummary: How to report on General Ledger budget vs. actuals in OTBI Content (required): How do I report on General Ledger Budget vs. actuals in General Ledger Balances R…
-
How to transfer location of Install based assets in maintenance to be same as financial fixed assetsSummary: we have requirment from the customer to mass change the location of fixed assets and as sequential this change should affect the maintenance assets Content (ple…