-
Rehired Employees are Unable to retrieve employment letter using the current user name
* ---- For example: Person Number: 187775 Current Username: A187775 (Results in an error) Old User Name: uakhokh (Fetches data correctly or could download the letter using this old user name)---- Query Segment with Possible Issue: The following part of the query (at the end) seems to be refencing the and papf.PERSON_ID =…
-
Updates to performance goals
Within the database itself, is it possible to see how often a goal is updated? Does the database create a new row when a performance goal or goal measure is updated? (Is it always in correction mode and won't be update mode?)
-
How to remove or hide the actions of a report so that the user cannot modify it
Hi! How to remove or hide the actions of a report so that the user cannot modify it
-
Check who has received an agent
Summary: Content (please ensure you mask any confidential information): Hi there, is there a way to see who has received an agent that I have set? Thanks Bobby Version (include the version you are using, if applicable): 24D Code Snippet (add any code snippets that support your topic, if applicable):
-
OTBI - Using custom images in HTML
Hello Experts, Is there any way to reference the images uploaded to the catalog via HTML? I've uploaded images to the catalog and would like to use them in HTML that I'm adding to a dashboard. I noticed when adding a Link/URL object to a dashboard I can select images from the catalog and it references it using…
-
How to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard
Hi Team, We are building a custom OTBI analysis in Fusion, need to know how to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard. Please share any info. if anyone worked on the same requirement. Regards, Sravan
-
How to set Ownership of /User Folders to SYSTEM ACCOUNT
Problem Description --------------------------------------------------- In PROD, ownership is currently set at Authenticated User In OTBI Catalog, within the ADMIN view the Catalog Root > User Folders directory we are unable to set /User Folder ownership set to System Account. Would like to know how we can set all User…
-
How to add row number (fixed order) in analysis?
Summary How to add row number (fixed order) in analysis? Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number will change when other columns are being sorted. Is there a way to lock row number so it does not change when other columns are sorted? Thank you. Jon…
-
"Security - Roles and Privileges Real Time" doesn't return inherited privileges
We need a OTBI report which does the same as Security Console Export Privileges and Roles. We tried out subject area Security - Roles and Privileges Real Time for Roles it gets similar results but for privileges it doesn't return inherited privileges. How we can get the data the same as under Security console, it is time…
-
Page number of Total pages on Dashboard HTML Output or PDF Output
How can I print Page # of Total pages in a dashboard or in the PDF Output? I modified the layout in the Print and Export options, then modified the page and added the Page # and Page total and I can see it in the view Report but it does not show on the screen when I run the dashboard. Thank you for your help, Isabel
-
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
