-
How to create ess job that will directly use the parameter of the data model?
Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to recreate the analysis on a data model by taking the SQL from the Advanced tab. In the data model, we made the Data Source as Oracle BI EE. The problem is, we…
-
Avoid fetching Active employee got Terminated when fetching Inactive Employee Data
How to avoid fetching employee currently active but this employee got terminated multiple times having different assignments number when fetching inactive employee's data currently using Workforce Management - Worker Assignment Real Time Subject area
-
Request for Guidance on Users, Roles, and Privileges Reporting
Currently, we are using the standard subject area "Security - Roles and Privileges Real Time"; however, it does not support retrieving all three combinations together. At present, we are only able to fetch: Users and Roles, or Roles and Privileges but not a complete mapping of Users, Roles, and Privileges in a single…
-
Redwood Purchasing Landing Page - OTBI question
I've consulted these links below and am still unclear from the documentation language how to make the OTBI reports appear in the Create Configuration page. It doesn't seem to open just for any OTBI. What are the steps to make sure I can choose the OTBI report other than it being in the Shared folders? Redwood: View and…
-
OTBI Analysis for AP Invoice Lifecycle
is there any OTBI analysis available which can provide AP invoice lifecycle summary
-
ERP Subject Area custom? field missing 26A
Hi! All of a sudden one custom made analysis stopped working in our production system, it still works in our test system. Since it is working in our test system I was able to get the issued SQL from test, as you can see in the sql there are three "custom fields" in the query. It seems as if those three custom fields are…
-
[OTBI] Extract "comment" field in the transaction console
Hello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which we have to insert a comment in the third step of the terminate work relationship page Transaction info : In BI Publisher, I was able to retrieve this field…
-
Linking Two OTBI Analyses' Together With A Deep/Action Link
Hi all, I'm wondering if the following is possible and if so, how I'd go about doing it. Example I've got two reports, Report A and Report B. Report A brings back an employees Name, Sickness Type and Dates of Sickness Report B brings back more detailed information about the employees' absence we do not want to surface in…
-
How to query PVO in Oracle BI Publisher Data Model
I need to query PVO data in BI Publisher, here's the PVO name: HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue Any screenshots, ideas, hints? Thanks.
-
What federal compliance reports such EEO, ADA, and FMLA are provided
-
OAC - How to create "Live" data set that based on OTBI subject area ?
OAC - How to create "Live" data set that based on OTBI subject area ?
-
Workforce Management – Documents of Record Real Time
I am attempting to create an analysis that shows the status of a specific document submission for each Worker; each worker is required to submit a Document of Record with a Document Type of “NDA” each year. From the “Workforce Management – Worker Assignment Real Time” SA I am returning basis Worker details, and from the…
-
Is it possible to remove a certain field/column from the output of CSV file in OTBI report?
Hi, Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format. As you can see, these are IDs connecting the DM. In the report's layout the highlighted IDs are not included. But when we are exporting in CSV, the IDs are being…
-
How to make a copy of an analysis under an analysis - Recruit to Hire Dashboard
Hi, The Recruit to Hire Dashboard is a seeded resource in the Oracle release, so users can’t modify it directly unless they create a copy. We were able to copy most of the analyses, but there is one called “Hire KPIs” that drill down into five additional analyses. We haven’t been able to figure out how to copy those…
-
How to connect Power BI with Oracle in OTBI?
Hello everyone, Does anyone know if there is currently a manual with the steps to follow to connect the Power BI application with the Oracle Cloud application to import reports and analysis? Currently I have tried to connect but I am getting the message that it cannot connect due to the error: "Oracle: ORA-12538: TNS:no…
-
Filtering data in Workforce Management – Documents of Record Real Time
I am joining the “Workforce Management – Worker Assignment Real Time” and “Workforce “Management – Documents of Record Real Time” Subject Areas, if I add a filter to identify Workers that do not have any records in “Documents of Record” (either filtering on “Document Count = 0” or “Document Type is null”) it returns no…
-
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 .