-
How to remove hour in OTBI learning report?
I'm trying to create a report showing learning due date and exact completion date. I would like to remove the hour that only date should be visible in the report. Is there any way to remove hour?
-
SQL editor for Oracle BI
Summary What tools are people using to edit SQL in Oracle BI? Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model SQL. The window Oracle provides is small, non resizable and times out frequently, so I try to avoid it, using something like notepad or notepad++ to edit…
-
Is possible to save historical executions from BI scheduled report?
Is possible to save historical executed reports and review it into a file content manager from Oracle Fusion? the customer needs to save the inventory valuation report at specifict time (depend of this time some fields shows different values) and they would like to find this historical files into the fusion ERP under demand
-
Termination Data and Performance data in one report
I'm having problems combining termination data and previous performance ratings into one analysis to add to a dashboard
-
How to pull Spouse Date of Death in OTBI report
Summary: The requirement is to pull the Employee's Spouse's Date of Birth but the field should be left blank if the employee doesnot have a spouse or if the spouse is deceased. How to pass this condition and pull the Spouse's Date of Birth in OTBI report? Content (required): Version (include the version you are using, if…
-
Is it possible to do map visualisations in OTBI
Summary Is it possible to do map visualisations in OTBI Content Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Business Intelligence Enterprise Edition (OBIEE) 11g (11.1.1.9.0) as part of Oracle Cloud Applications has anyone managed to use the out of the box subject…
-
Event based autoprovisioning of AORs
Summary: With auto-provisioning of roles, the rules run when the process is run OR during an employment event (i.e. if someone is hired and fits the criteria of an auto-provisioning rule, they will get the roles). We are looking to start using AOR templates to auto-provision AORs, however, it doesn't seem the provisioning…
-
Reports and Analytics feature in FA - ERP cloud
Hello, The Reports and Analytic feature in Oracle Fusion Application (specifically ERP Cloud) is a service built on OBIEE server and technology stack. With OBIEE approaching end of life and Oracle shifting focus towards OAC, how will the Reports and Analytics feature in Oracle Fusion Applications be impacted? Thank you!
-
Latest data changes not reflecting in OTBI report immediately
Hi, We have GL drill down OTBI report. Latest changes to data not reflecting in this report immediately. For example if we post and journal it is taking some time to reflect in this OTBI report. How we can make report to show changes immediately Thanks Narasimha
-
AOR analysis fails when I add representative or employee data
I'm trying to create an analysis using Workforce Management - Areas of Responsibility. I need to pull the AOR information as well as representative and employee information. I can get what I need from the AOR, but when I try to add representative or employee data, the report fails. I tried to create the analysis for the…
-
Trying to connect two SA
Hi Everyone, I have those two subject area and I wondering if there is a way to joining them together 1- Payroll - Payroll Costing Setup Detail Real Time. 2- Payroll - Payroll Run Results Real Time thanks in advance
-
How we can get instant(Online) run of the report history without scheduling report history
I am trying to export the audit reports scheduling history but, now I wanted to know if we can able to see the history of run without scheduling the report which means instant (Online) run of the report. Please find the attached document for your reference. If anyone could help on this please advice ASAP.…
-
Alerts are stuck in Scheduled status and aren't Running
Hello All, Alerts are stuck in Scheduled status and aren't Running.When we re-submit the same alert again,the previous alert shows up as "Cancelled". Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 25A Code Snippet (add any code snippets that…
-
"Reports and Analytics Access Issue Post 25A Update - 500 Internal Server Error"
Dear Oracle Team, We are currently encountering an issue in our Oracle Cloud Applications environment (Version 11.13.25.01.0 / 25A), where accessing Navigator > Tools > Reports and Analytics results in a 500 - Internal Server Error. The impacted user has been verified to possess both the BI Consumer Role and BI Author…
-
Return in Dashboard is not returning to previous page rather it is returning to main page. Any idea?
Summary: Return in Dashboard is not returning to previous page rather it is returning to main page. Any idea ? Content (required): from main page we drill down to second page. from second page we drill down to third page there when we click on return button it is directing to main page not previous page(second page)…
-
Resizing Rows and Columns - OTBI
Hello! I'm creating an analysis in OTBI. How do I set columns widths using column properties, to keep those widths persisted? When I input values in the Additional Formatting Options (width, height, etc. fields) it does not adjust the column/table widths. Is there something else that needs to be set? Thanks!
-
How to suppress rows and columns with 0 value on a pivot table?
I have a pivot table, and I want to be able to hide entire rows or columns if all of the values are NULL. How can I achieve this? I tried the obvious things such as filtering out null values, combinations of filters, and changing in the view/column properties. I also tried converting any nulls to have a 0 value instead and…
-
How to fetch the First start date and latest end date from multiple rows in OTBI.
I was trying to fetch the first start date and latest end date for and absence taken. since the short-term disability plan stores multiple rows in weekly wise so not able to fetch the first start date of the absence and latest end date in a single row. Is there any workaround to achieve this? Attached screenshot. Thanks.
-
Include report parameter in bursting output?
Content I'm using bursting to control the filename/delivery of a report run as a part of a flow. I'm not actually splitting the data up, so I'm just using the Split/Deliver Key as a static value included in the dataset (e.g. like how Marker is used in this example in the documentation). In the report DM, I have enabled…
-
how to convert number to char in otbi
-
Pull a report of OTBI User Folder Access
Summary We need to be able to pull a report of all user access to all OTBI folders. Content We need to be able to pull a report of all user access to all OTBI folders. To know who has access to HR/financial/admin folders. For audits and prior to refreshes (since these sometimes are deleting access). Example: Custom Folder…
-
NULL values in OTBI
I think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable null values for just one column, or is it a global setting? For example, if employee has no leave of absence records, it would be blank, but all the other fields…
-
BI Publisher report not delivering as expected due to large size
Hi, we are using OAS 7.0, EBS 12.2, OBIA7.6.4, Oracle 19 db on linux set up. We have a BI Publisher report that has around 500K rows that we are exporting in .xlsx file. Due to large data volume the report execution times out and so we are planning to use this report by scheduling. Server config attachment limit is…
-
OTBI Analysis result via SOAP request/response with proper column names
Hi, I am using OTBI and I have created an Analysis. This works great. Now I want fetch the result via a SOAP call. This also works fine. I use the XmlViewService and the executeXMLQuery operation and I get the result I expect. So far so good. This is the result I am getting. <soap:Envelope…
-
Report of Objects in BI Catalog Folders
Summary Is there a way to produce a report of folder structure along with objects/types that exist in the folder Content Hi, Is there a way to create a report or if one is available that shows the folder structure and contents of objects and type within the BI catalog? Thanks Version Oracle Financials Cloud
-
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time
We are trying to create a Analysis report based on General Ledger-Transactional Balances Real Time to display: Natural Account Segment Fiscal Quarter Ending Balance Report prompt is Quarter. In this prompt we are displaying all the available quarters on or before current date. Requirement is - When user submit the report…
-
Performance Goals Dashboard
I have a Performance Goal Dashboard that reports Goals created and Goals not created. When the number for goals created is selected, it brings up report within the dashboard. When I select Goals not created it brings up a reports to select (below)? How can I get it to bring up the Goal not create report within the…
-
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBI
We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some approaches by using the DATETIME functions in OTBI. However, the output is not correct for all the date ranges. Most of the date ranges it gives the correct output…
-
BIP Report fails with Maximum Limit Exceeded even after applying all filters
BIP Report fails with Maximum Limit Exceeded even after applying all filters Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below error for one of the payroll reports - even after providing the limited values of date range and applying values to all the filters - Stopped…
-
Which BI Role is required to develop OTBI Agent
Hi, Can you please suggest which BI Role is required to develop OTBI Agent? Do we need BI Admin Role to create or schedule OTBI Agent? Thanks in Advance.
