-
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…
-
Can I run the OTBI thru ESS jobs
-
data is sometimes not actual. I have to delete the browser chache. how can I prevent this
-
Scheduled Report does not show all values
Hi We have been experiencing issues. A scheduled report does not include calculated column values which show in OTBI directly or when the report is exported, or scheduler is run manually. They dissapear when the agent is left to run automatically. Screenshot of the export with the values Screenshot of the report with…
-
Guidance on Fixed Assets and how to get YTD depreciation figures
Hi, I am trying to recreate the date from the Asset Inquiry screen (screenshot below) but am struggling where to start. I can see three subject areas related to Fixed Assets and would assume that the data below would be held in the Asset Depreciation Real Time subject area. The other two subject areas are Asset…
-
New to Oracle Fusion and not sure how to grant users to OTBI
