-
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses Availability
Hello, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration page (/fscmUI/redwood/cx-analytics/application/container/dvconfig), I can see the "Create Configuration" screen, but the analysis search dropdown is empty.…
-
Is it possible to create an OTBI report that fetches all manager details for an employee?
We’re encountering two issues with an OTBI report designed to fetch manager data. First, certain employees' data isn't appearing in the report despite being present in the system. Second, the report is only capturing one manager when an employee has multiple managers of the same type assigned. Has anyone encountered this…
-
Missing Sections in OTBI for Candidate Details Section in ORC
I am using the Recruiting - Recruiting Real Time subject in OTBI and am searching for the following sections coming from the Candidate Profile within the Oracle Recruiting Cloud: National Identifier (social security numbers), Biographical Info (date of birth), and Candidate Attachments (uploaded candidate documents). I…
-
Human Capital Management - Transaction Administration Real Time Subject area didn't result
Dear Experts, Human Capital Management - Transaction Administration Real Time subject area not retuning any results. I have all roles: Role name: TMEIC Human Capital Management Application Administrator ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB Duty Roles This job role is related to the following duty…
-
Alter OTBI column properties on multiple columns in one action
In an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can you set the Value Suppression to Repeat on all columns within the analysis ? Thanks in advance.
-
Build a OTBI analysis using 2 subject areas but results is giving blank table.
I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User System Usage ' but after selecting the required columns from the both the subject area the table showing in the results tab is coming blank i.e. without any…
-
I want to prepare an OTBI report to capture roles and data access information
Dear Members, I want to prepare an OTBI report containing the below details: Username Email Job Title Company Manager Name Role Name Role Code Security Context Security Context Value Please suggest the relevant subject area(s) to achieve the same.
-
BI Publisher Accessing WebCenter Content (Web Content Server)
We have created a BI Publisher report intended to access PDF attachments stored in WebCenter Content (Web Content Server). However, when the report attempts to retrieve content from WebCenter Content via Oracle Fusion BI Publisher, it fails with an error stating "Content Server Request Failed" and indicates that the user…
-
How to send OTBI report to SFTP server
Hello Expert, We have a requirement where we need to push an OTBI report to an SFTP server, and we would like to know how we can achieve this. Regards, Pritam
-
How to find an OTBI agent ran by another user?
-
Oracle Provides PVOs for Views?
-
OTBI Prompt
How would a prompted input be used for filtering the analysis (i.e user selects a date in a calendar dating from that date till present for generating the analysis)?
-
Is OTBI reporting supported for Oracle Fusion Field Service (FFS) or OFS?
Since Field Service data now resides within the Fusion environment, we would like to confirm the following: Does Fusion Field Service (FFS) currently expose dedicated Business Objects that are available within OTBI for reporting purposes? If not, is there an official roadmap to support FFS-specific Business Objects in…
-
OTBI Fetches Different Results when compared to UI
Hello , I have a requirement to fetch the Requisition Numbers & Recruiter Full Name in the Analysis and for that I have used both 1. Recruiting - Recruiting Real Time 2. Recruiting - Recruiting Events Real Time The results are not matching the UI .
-
Union (merge) 2 columns into one
I am building an analysis in the Recruiting – Recruiting Real Time subject area to report on Candidate Interactions. Interactions can be recorded in 2 different places: in the candidate profile (the data is located in "Candidate – Interactions" folder) and in the job application (the data is located in "Job Application –…
-
How would a new column be generated in the analysis result
How would a new column be generated in the analysis result that would be based on two other existing columns/prompted input (i.e calculating number of days between effective start date and effective end date and then recording the difference as number of days in the new column)?
-
Hi I am creating an Otbi and the data coming in Otbi is different from the UI in the oracle fusion.
Hi I am creating an Otbi and the data coming in Otbi is different from the UI in the oracle fusion. The subject area i am using is Project Costing - Actual cost real time
-
API Run report NO DISPONIBLE
Hola, estoy tratando de hacer una conexion mediante una API para envía una solicitud al servidor de Oracle BI Publisher para ejecutar un informe específico. pero me marca el error 404, sin importar los cambios que realice me sigue marcando el mismo error , estoy usando oracle fudion cloud.…
-
Unable to retrieve Department and Office Location for Affected Person from Case Management subject a
Description: The customer is unable to retrieve the Department and Office Location attributes for the Affected Person within Oracle Analytics reporting. We attempted to join the Case Management subject area (Table A) with the Workforce Management subject area (Table B) using the available common dimensions. The join…
-
Finding DFF field in HCM OTBI Subject Area
Good afternoon. We have added values to this HCM table/field, HRT_PROFILE_ITEMS.ATTRIBUTE1 as a DFF that we need to add to our OTBI reports. We have followed the required steps of checking the BI enabled box, deploying the DFF and running the "Import Oracle Fusion Data Extensions For Transactional Business Intelligence"…
-
Training Suppliers Details OTBI report not providing all the data in the UI
Hi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through the OTBI report is less when compared to the UI export report. Navigation for UI: My Client Groups > Learning > Training Suppliers OTBI Report Criteria…
-
FDI attributes without Start & End date included
When creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other required attributes) are not included. This makes these attributes unusable as we cannot determine which row is accurate for each employee. What is the…
-
Access run history & older report outputs of OTBI scheduled reports
Hi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output of each run for a scheduled OTBI report? In our older HCM Peoplesoft system, there used to be 'Process Monitor' which used to let us access run history &…
-
Employee Address Historical Data
Hi! How can I create an OTBI analysis that displays an employee’s full home address history, rather than only their current home address?
-
OTBI Dashboard : How to enable Export to Excel for seeded L1 reports?
We built a new OTBI dashboard by copying a seeded OTBI dashboard and added an L0 KPI graph. Business requirement: when a user clicks the L0 KPI and navigates (drills) to the L1 report, they need to export the L1 data to Excel for further analysis. Issue: the Export option is not available on the seeded L1 report page. Has…
-
Drill down from OTBI adhoc report to Expense Report
I am trying to create an action link in an otbi report related to expense report info. Currently the action link is attached to the report number field- but apparently there's a known problem with doing that and I've been advised to use expense report id instead of report number. I'm also following directions from oracle…
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real Time
I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their last salary information. I can get the terminated employees to pull, but as soon as I start adding columns related to salary (salary facts), it is not consistently…
-
Email Update and Add Email
Hi Expert, Looking an HDL where we can add and update the work email through HDL. Thank you!
-
How to extract and update fusion approval groups via get API request or any other web services
I am building a web application to be integrated with Oracle Fusion. One of the key data I need is the approval groups that are defined in the BPM worklist. Is there a way to pull and post this data directly from the fusion?
-
What is the maximum number of rows that an OTBI report can fetch correctly
I am trying to write an OTBI report from Fusiuon on Payables and I am seeing some incorrect values on invoice amount and few other fields. I am not sure if it is because the total number of records is higher. Is there an Oracle specified limitation on OTBI report data vloumes.
