-
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:
-
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.
-
How To add a if conditions parameter value at header level in etext template in bi publisher where.
-
“FUSION_APPS_Enterprise Scheduler Job Application Identity for HCM.” user is not coming while search
Recently, we observed that this user account now appears to be renamed to “FUSION_APPS_Enterprise Scheduler Job Application Identity for HCM.” This change was not made by our team. Additionally, when attempting to assign this user account—using either the old name or the new name—to another BI Publisher folder, we are…
-
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?
-
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
-
BI Publisher desktop Not working with Office 365
I installed BI Publisher desktop 32bit and 64 bit on office 365, but both are not working, I am unable to see BIP Addin in office tool Bar, I tried to to enable the AddIn through File--> Options-->AddIn , but I didn't find the Add In there. the AddIn appears in Excel but not in Word. one of my colleague installed the same…
-
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 -
-
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
-
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…
-
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…
-
how to enable dff in otbi report?
Summary: I am trying to enable dff in otbi anlaysis. even though i run the schedule on Import Oracle Fusion Data Extensions for Transactional Business Intelligence dff's didn't enabled? Please let us know the solution for that.. Content (required): Version (include the version you are using, if applicable): Code Snippet…
-
List of HR metrics and dashboards available
Hi, Is there a list of the Oracle pre-delivered HCM reports in BI Publisher and OTBI formats? In particular we are interested in HR metrics and dashboards, things like turnover and retention, headcount, recruiting metrics, etc.? I tried searching the community but I am only finding references to Fusion Analytics and as far…
-
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.
-
Issue to create an analysis from General Ledger subject area
When I am trying to create an analysis in OTBI from General Ledger subject area it is not giving the proper output. I just added salary codes, and when I am trying to add CPR number , then result is showing null . Not only CPR number , when I tried to add any other components together , its showing no values Regards,
-
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…
-
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…
-
Can I run the OTBI thru ESS jobs
-
Workforce Scheduling - Work Pattern Real Time
Hi all, I am trying to report from the Workforce Scheduling - Work Pattern Real Time subject area, I can see data in Fusion apps UI (to confirm there is data there - I have the Workforce Schedule Administrator job role), but I am unable to see any Work Pattern data in OTBI in this subject area, is this an issue that anyone…
-
Generate SQL query using Oracle tables when the OTBI subject area is part of the BI Publisher DM
We have a BI Publisher report. The current report data model includes: one dataset based on an OTBI subject area other datasets based on Oracle standard tables We need Oracle’s help to obtain the complete query from Administration > Manage Sessions and identify the equivalent query using only Oracle standard tables. Our…
-
New to Oracle Fusion and not sure how to grant users to OTBI
-
Pending worker report
I am new to reporting, and I have to make a report using BI Publisher data modeler in SQL. When I put effective start date later than today and DATE_START later than today, I get back both pending workers and employee records for the same person. Both records have start dates in the future. Why is this the case and how do…
-
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…
-
Purpose of the report parameter _linkToReport
In a report you can choose to share a report link. This will bring up a link which you can copy. This provides a link with a parameter at the end _linkToReport=true. I would like understand what this parameter does? Changing it to false, I do not see any changes and thus would like to drop it in particular as it sometimes…
-
In Sales CRM, Custom Fields from Custom object are not visible in OTBI Subject Area.
Hi, In Sales Opportunities, we have created fields in Custom child objects, but those fields are not getting captured in any Sales CRM Related subject areas. We have used Sales - CRM Opportunities and Products Real Time subject area, but unable to find the custom fields created. I have attached the screenshot of the Custom…
-
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…
-
data is sometimes not actual. I have to delete the browser chache. how can I prevent this
-
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…
