-
Session Variables for Use in Activity Center Visualizations
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
-
How to pass parameters to dashboard via sandbox?
Hi all, I am trying to add a OTBI dashboard to page via sandbox. While I found that the parameter cannot pass to dashboard. Promptfilterxml…
-
Recruiting Real Time and Real Time Events
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
-
OTBI Report - need to fetch the Worker Historic information
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
-
26C Deprecated BI View Objects
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
-
Where are the work order notes?
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
-
Hierarchies in GL Reports
Hi all I am trying to achieve two things in OTBI using GL Balances and GL Journals Subject Areas. I am struggling on both counts so could use some advice please? I am guessing the answer is the same or similar to both so posting together rather than separately. I am trying to get an action link that drills from an analysis…
-
Visual configurations - Pivot Table type not displaying and tabular chart not Org filtering
ISSUE 1: I've created a few configurations, but the only one that I cant seem to get to work is the pivot table. The configuration preview seems fine But on the Maintenance Management Page is just blank: The green highlighted configurations are all the same OTBI Analysis and refer to the same record. The pink highlight is…
-
Can I get a list of all OTBI reports that are in the catalog?
I am looking for a way to get all OTBI reports available in the report catalog. Ultimately, I would like to see the report name and the folder structure it is saved in. As well as the fields included on the report and who has access to it.
-
No Option to Export to Excel after 26B
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
-
At what point does the task id or checklist id gets generated for a Guided Journey?
We have Created a Guided Journey on candidate application page where it is linked to a talent profile report, when a user opens candidate page they click on see document then report output for that candidate should be downloaded Whoever a user is clicking on the see document a blank page gets downloaded after 10-15 min of…
-
At what point task id or checklist id gets generated for a Guided Journey?
We have Created a Guided Journey on candidate application page where it is linked to a talent profile report, when a user opens candidate page they click on see document then report output for that candidate should be downloaded Whoever a user is clicking on the see document a blank page gets downloaded after 10-15 min of…
-
How to get reviewer details for an employee
I am looking for a table and a column which can give me details of reviewer who completed the review for an employee. I dont need total reviewer on a meeting .
-
Column Text Overlapping in PDF/PPT Output for RTF Template, Works in One Environment but Not Another
We have an RTF template in BI Publisher that generates a multi-column PDF/PPT report (Succession Plan). The report prints Succession Plan details and employee readiness information across 4 columns — for example, "Ready Now", "Ready in 1-2 Years", "Ready in 3-5 Years", and a 4th column — where each column displays employee…
-
OTBI: Creating Performance Tiles based on Performance Document Rating Levels
Hi, We need to create Performance Tiles based on Rating Levels similar to the below Unfortunately the Performance Tiles does not have much flexibility, it shows values based on pure measures. The workaround is to use Pivot Tables but the layout is not user friendly at all. I've tried to create measures on Subject Area:…
-
How can I query the Physical PVOs in OTBI?
-
Salaries for current and terminated employees in one analysis
Is it possible to create an analysis with a list of annual salaries for both current and terminated employees?
-
Context Sensitive DFF's showing multiple times
We have setup Context DFF's within the Enterprise Contracts Module. Next we have created an OTBI report and added the DFF's into the report. The DFF columns are showing multiple times, since they technically different fields I assume. Is there a way to combine these columns into one column? Below an example:
-
How To add a if conditions parameter value at header level in etext template in bi publisher where.
-
Can we Install/Configure BIP Publisher software/Plug-In other than Microsoft Office/Word components
We migrated to GWS (Google Wokspace where prefers Google sheets/Documents/ppts) from MS Office. so, couldn't use MS Word in our project. Can we Plug-In/Configure BIP Publisher desktop in Google Sheets/Documents for BIP Reports development Thanks & Regards Yugandhar K
-
In BICC how do we view unmasked Tax Payer ID for Suppliers?
We are using the SupplierPVO but the taxpayer id column is coming as masked. The User has the Supplier Administrator and Supplier manager but still the data is not unmasked. How do we resolve this?
-
OTBI Report Error
Hi Team, We are getting this below error for a few users and when we try to run it we are able to get data successfully. Below is the error message -
-
OTBI Report for Position and Employee Costing
Hi Oracle Team, Could you please advise which OTBI report includes both position costing and employee (person) costing information? Specifically, I am looking for details such as entity, cost centre, account, and activity.Pls see screenshot below. Thank you in advance for your assistance.
-
Report that shows users that created/added a new worker to Oracle HCM?
Does anyone know of a delivered report (or can share a custom report) that shows this? Thank you, Rich
-
Oracle Fusion Table for Negotiation Number and Deleted Negotiation Audit Details
Hi Team, Which Oracle Fusion table stores the Negotiation Number, and is there any table or audit log to identify the user who deleted the negotiation? We are trying to trace a negotiation that appears to have been deleted and need to find both the negotiation details and the user who performed the deletion. Any guidance…
-
Schedule report shows the value of last column empty
Hello When running the report manually all values are returned. But when the report is scheduled and sent by email the last column that is the amount column is empty.
-
OTBI Report to get supplier contacts that do not have an address assigned
Hi all. I have an OTBI report I created to get a list of all supplier contacts and whether they have user accounts enabled. However we realized that contacts with no address assignment were not showing up in the report. After some investigation, I've realized that they simply don't show up in the poz_supplier_contacts_v…
-
Table to get BI Report Template and Data Model Details
We have a requirement to change logo on all the custom reports. Tricky part here is to identify all those custom reports that has templates. XDO_TEMPLATES_B does not exist in fusion. DO we have any table that stores the templates details in fusion.
-
Can AI Agent Studio Custom Agents Execute and Interpret OTBI Reports?
We would like to understand whether Oracle AI Agent Studio supports a standard integration with Oracle Transactional Business Intelligence (OTBI). Our objective is to enable a custom AI agent to: Execute existing OTBI analyses and reports. Retrieve the report results dynamically. Interpret and summarize the returned data…
-
Need PO Approval Details in Oracle Fusion 26B OTBI Analysis
Hello , Currently we are on Oracle Fusion 26B version. I am working on Purchase Order Report including Approval details via OTBI. I am using Procurement Purchasing Real Time subject area but I do not see approval details under purchase order header detail folder. Is there any role I am missing to see approval details…
