-
How to restrict OTBI dashboard report output when User field isn't in subject area?
Hello, I'm setting up an OTBI dashboard which will only return rows in report(s) based on user details, i.e. User is equal to/is in @{NQ_SESSION.USER}. However, the subject area for one of these reports only contains email, not User detail. I've tried converting the email to UPPER(email) and using this as User and although…
-
Need to Group by the Column based on data from 2 different Subject areas in OTBI
Hi Team, I am creating a OTBI report, and it is basically a Payroll Reconcillation Dashboard, it is having lots of details, one potion is having the details about the salary elements and their pay value. Below is the snip, this is what I want to create. This sample I created with Excel. I want to create the same in the…
-
How to show 2 result sets in one otbi analysis - Cloud HCM (Learning)
Hi all Looking to get some insight from the wider community on HOW to combine 2 sets of filtered data into a consolidated analysis. The ask from Customer is to have for learning allocations a specific set of workers that meet criteria, associated with layers within department hierarchy, as well as Assignment Status as well…
-
Unexpected Language Variation in Data Extraction - BIP Report
Hi community, We are experiencing an unusual behavior with the "Environment Health and Safety - Incidents Real Time" subject area in a BI Publisher (BIP) report regarding the language of the extracted data. We have created a BIP report that links a data model to an Oracle BI EE dataset. The data model contains a very…
-
PPM Project Billing Funding OTBI does not show funding amount when accounting date is added
I am trying to build an OTBI Analysis combining multiple Project OTBI. But when accounting date is used Project Funding amount is coming as null. Is there a way to edit the formula for funding amount column to ignore the accounting date
-
Why is CASE function always returning ELSE statement?
Within our Case function we are comparing a number of months with "Timestampdiff" function with a descriptive flexfield that has numbers. We added the "Timestampdiff" function as a separate column in our analysis and did the same for the dff and both return numeric values. Our code is looking as follows: CASE WHEN…
-
Learn Metrics Report - Annual & Monthly Summaries
Hello Everyone, I am attempting to develop a dashboard that will provide users with overall training summaries of completion; however, I am running into several issues and usually the analysis will error. I would prefer to use the Learning Records Real Time subject area and wondering if anyone has something similar…
-
How to add column headers for pivoted fields in layout
Hello - I cannot find a solution to this yet I see many unanswered questions. I just need a firm 'no' if it's not possible. If it is, a brief explanation of how would be much appreciated. When you add a pivot table to a layout in Oracle Business Intelligence Analytics - this is data model and report related, not analyses -…
-
find row with maximum date within a group
-
Oracle HCM - inactive organisations in prompts
Hello, I have some organisations (ex : services or legal enity) that are inactive in the system (EX : OLD SERVICE). It doesn't affect any reports but it still appears in the prompts (see example below). Is there a way to exclude those services from the choice list ? without having to use a SQL function in each invite of…
-
Payroll balance analyses timing out for relatively small data sets
I recently noticed that my Payroll Balance OTBI analyses have started to time out. I'm aware that the Payroll Balances tables have few indices and are subject to performance issues, and at first I thought that maybe my data set for the particular report was just too large. However, after running a comparison between a…
-
Unable to retrieve data related to absences in Subject area related to absences/Shift
As a part of 25A we have got the below new feature related to OTBI reporting Feature Name: New Subject Area - Absence Shift Details Real Time Feature Link: https://docs.oracle.com/en/cloud/saas/readiness/hcm/25a/amg-25a/25A-absence-mgmt-wn-f36405.htm We have tested this feature in our lower environments also in test…
-
OTBI Deeplink for Invoice view
Hi All, We are trying to add deep link in an OTBI report. Subject Area: Payable Invoices - Transaction Real time Columns: Invoice Number, Invoice ID from general information. We are trying to call below Action Link in Invoice ID values as below:…
-
Can you please let me know how to invoke a web service from OTBI action link?
I am trying to call a SOAP web service from OTBI action link and its giving below error. How can we invoke this webservice from OTBI? Action could not be invoked. ServiceExecutionFailure : Error invoking web service StandardReceiptService at endpoint https://servername/fscmService/StandardReceiptService Client received…
-
How do i perform a lookup within a OTBI analysis report
Summary: I need to perform lookup through Grade Name field to map Grade names for Direct managers adjacent to Direct Manager field in the same report (where I have Person Name & their Banding listed). Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable):…
-
Projects Top Task Name and Top Task Number not displayed in OTBI for some Project Numbers?
Hello, We have created an analysis using Projects - Performance Reporting real time however it's showing incomplete data. When we add the column "Top Level Task Name" or "Top Level Task Number", some projects are not displayed. This issue also appears when we utilise the Projects Control - Budget Real time subject area…
-
How to see if the employee has executed custom BI reports that are linked to springboard
Summary: Hi! There is a requirement for me to enable checking (like an analysis) if employees have executed custom BI reports that are linked to springboard. What can I do to achieve this requirement? For example: I want to check how many employees who have viewed the custom BI reports today. Thank you. Content (please…
-
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?
One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can see it both on the screen and in OTBI. The flexfield is configured to be visible in OTBI, and the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process has been run. Additionally, the Person View…
-
Multiple rows of learning records appearing from learning initiatives and renewals.
When we pull learning OTBI reports, we're noticing 1+/multiple rows of learning records for users who were assigned a learning item through a learning initiative with renewals. For example, a learning item assigned through a learning initiative with an expiry of 1 year, and renews 30 days from expiry. E.g. if the user had…
-
OTBI path for this notification and which template - Redwood Users Delegation Roles
The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for this notification and which template should be modified. #Redwood
-
Enterprise Scheduler Job Application Identity for HCM-FUSION_APPS_HCM_ESS_APPID RoleMembershipRemove
How does FUSION_APPS_HCM_ESS_APPID being triggered and execute RoleMembershipRemove. We found in audit report that it removes multiple roles in 1 user.
-
Getting error while connecting with Oracle BI Connection
Summary: Getting error while connecting with Oracle BI Connection Content (please ensure you mask any confidential information): I login with user created specifically for AI but getting error while connecting with Oracle BI Connection though the credentials are same Version (include the version you are using, if…
-
How to access PVO Queries?
Is there documentation or some way to access the database queries behind PVOs used in BICC? For example, how can I see the queries behind these PVOs? HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO
-
Inquiry About CMP_CWB_HRCHY_CF_DN Table Population in Oracle Fusion HCM
Hi, I am currently working on the OTBI subject area "Compensation - Workforce Compensation Real Time" and need more details regarding the CMP_CWB_HRCHY_CF_DN table. Specifically, I would like to understand: What process or job populates this table? How often is it updated, and is there any process to run for refresh it?…
-
OTBI Agent triggered each time a report is updated
Hello experts, does anyone know if it is possible to schedule an OTBI report in order to be received by the HR each time their employees data in the report are updated. For example, if an employee changes his manager, the HR should receive by email the report that highlight that this employee's manager has been changed. Is…
-
Can we add Report and Analytics area same as payables under expenses module
Summary: Is there a way to add the report and analytics option to access the report directly from the expenses area same as payables. Please find attached screenshot of payables for your reference. Screenshot 2025-03-10 172231.png Content (please ensure you mask any confidential information): Version (include the version…
-
Heatmap empty cells colors
Hello experts, we have created an Heatmap as a custom report. The Heatmap displays colored cells but also empty cells, if the report is opened within the system. However, if I download the report as formatted excel file, we can see that the same empty fields are black-colored. Is it possible to change the color to white,…
-
List of HR metrics and dashboards available
Hi, Is there a list of the Oracle pre-delivered HCM reports in BI Publisher and OTBI formats? In particular we are interested in HR metrics and dashboards, things like turnover and retention, headcount, recruiting metrics, etc.? I tried searching the community but I am only finding references to Fusion Analytics and as far…
-
OTBI - View only role to access GL subject area data
We need to provide some non financial users the ability to view General Ledger data (gl balances and gl transactions) without giving functional access to the General Ledger. Just provide the user view only access to view GL information, without giving them privileges that invoke a Financial users license…
-
Need solution to create an OTBI report to find AHCS Subledger Entry's Line level information
HI All, I am working on AHCS/FAH module and need to create an OTBI report to fetch the Line level details for a transaction loaded to Oracle using AHCS template. The data which is visible from Review Subledger Entries—> View transaction—> Line details, should be fetched.The report should have the option to populate the…
