OTBI
Discussion List
-
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 35 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 … -
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… -
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 43 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 514 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… -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 26A…Ramamurthy Shankarachetty-Oracle 18.4K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…User_2025-02-05-22-11-22-331 1.1K views 6 comments 5 points Most recent by otavio.teixeira Reporting and Analytics for ERP -
New Joinee's are not being enrolled into the learning modules through initiativeSummary: We have observed that for the past four days, new joiners are not being enrolled into the learning modules through the assigned learning initiative. However, th…
-
Require report to verify the transaction against the supplierSummary: We need to identify the list of suppliers, For the purpose of cleansing and de activating the suppliers which does not have any transactions (PR/PO, Receipt, In…