-
Enhance BICC Incremental Extract Logic to Exclude Records Updated After Job Submission Time
Oracle Fusion BICC incremental extracts currently use the following selection logic: Last Update Date >= Last Extract Date There is no upper-bound condition to restrict records updated after the extraction job has started. As confirmed by Oracle Support, this is the current product design and an Idea Lab enhancement is…
-
Ability to navigate to Fusion application's Home page from Analytics page
Ability to navigate to Fusion application's Home page from Analytics page. this is required as currently there is no any button available on reports and Analytics i.e. BI publisher page which can navigate user back to Fusion application's Home page.
-
Left Outer Join in OTBI
Hi, There are scenarios in OTBI where we want to all the details of Department which are not mapped to any of the person at Assignment level. so obviously it is not getting picked by the subject area. Logical SQL can be built but the problem is maintainability of this custom SQL. Better Left Outer join can be introduced at…
-
New Subject Area - Financials Chart of Accounts
Currently, the only subject area that has the full COA hierarchies is GL Balances. All other subject areas go direct from Top Parent to Child. This means the only way to be able to report other financial transactions, whether general or sub ledger, is to bring in the GL Balances subject area which there is a possibility…
-
Audit Trails for Reports/Data Model
Currently, user having BI Data modeler access having ability to create and run SQL queries without any data restriction. It will be helpful if we have an audit trail that who run which reports/queries.
-
Restricting the Data in reports and analytics while creating Data Model
Currently any user having access to BIP developer is providing the ability to see any sensitive information in the Oracle fusion irrespective of data restrictions placed in the front end through role assignments. User while creating a data model can see any HCM data like (Payroll details, DOB, SSN, etc.) as well as…
-
Create OTBI Analysis from BIP Data Model
In many cases in OTBI, Analysis cannot be achieved because multiple subject areas are required. This leads to building BIP reports which do not have as rich a user experience as OTBI Analysis. This is a particular challenge where pillars sit across multiple subject areas, for example receivables where data is needed from…
-
Enable Mailto link in Action Links with tokenised email address
I need to be able to create an action link with a mailto:url that has a tokenised email address. The use case is that on an invoice holds report, I want to click the requester name and it create an email, pre-populated with the details of the requisition and/or invoice. Whilst it is possible to tokenise some of this, when…
-
New Feature - "Recently used Filters/Objects" in OTBI Analysis
Adding a saved filter to an OTBI analysis currently requires the user to navigate to the Catalog section on the left bar of the analysis. While it is simple to add a filter saved in a folder directly under Shared Folders/Custom, it takes a lot of clicks to get to a filter saved under a child folder many levels below…
-
Improve Dashboards Listing in OTBI/OAC Classic
Currently, when custom dashboards are created, they need to be placed in Shared Folders/Custom/Dashboards to show in the dashboards listing. This can then only group the dashboards in the dropdown in a single collapsible heading. Where there are a limited number of custom dashboards that is fine but many organisations have…
-
Auto scaling for ESS job concurrency increase
To mitigate pod concurrency-related performance issues, we have significantly reduced ESS job frequencies, are redesigning our ETL processes, and continue to tune SQL. However, cloud platforms are fundamentally expected to provide elastic scalability. What architectural limitations prevent Oracle from dynamically scaling…
-
ESS Job Incompatibility Self service features (similar to what we have at EBS Concurrent Processing)
"We need stronger customer-controlled workload management capabilities within ESS. When will Oracle deliver self-service features to manage job incompatibility rules, concurrency controls, and workload-throttling policies that allow us to proactively prevent excessive ESS job concurrent activity from impacting pod…
-
Instance level NLS date format settings
Is there any supported way at the instance level to ensure that the Oracle database always returns English month abbreviations (e.g., “JAN”) when using the format mask 'MON' in TO_CHAR(date, 'MON'), without using NLS_DATE_LANGUAGE in the function call?
-
Environment Variable
When creating deep links to the fusion source, you have do hard-code the environment URL as part of the link. This means that when you migrate report content, you have to manually change every link. This can lead to errors and invalidate testing. This is not too much of an issue for individual report however when…
-
OTBI Action Link to BI Publisher Report – Migration Issue (Page Not Found)
Hi Team, In Oracle Transactional Business Intelligence dashboard, I am using Action Link to open a Oracle Analytics Publisher report (.xdo). Current full URL works: https://<host>/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=... Issue: I want to remove hardcoded host for migration (DEV → TEST →…
-
Ability to publish OTBI/BIP reports directly to SharePoint
I have seen a few ideas around publishing reports to Sharepoint, but documentation references sharepoint 2007 not the 365 Sharepoint that most companies are using. Can we do this with Sharepoint online/365? If so how? IF not enhancement logged.
-
Add Attachments to 'Receivables- Standard Receipts Application Detail Real Time' subject area.
Attachments need to be added to the “Receivables - Standard Receipts Application Detail Real Time” subject area. Attachments are part of the receipt header information. Since not all receipts contain attachments, having this attribute available will help users identify which receipts have attachments and which do not,…
-
Issue with Nationality Headcount in Dashboard
We are currently facing an issue while retrieving the nationality headcount for a dashboard that uses two subject areas: Worker Assignment Real Time and Person Real Time. When applying dashboard prompts such as Legal Employer, Business Unit, etc., the headcount results are not returned correctly. However, the overall…
-
Requirement for Custom BI Report to Extract Bursting Schedule Email Details
We have a requirement to develop a custom BI report to extract bursting schedule details. However, we are unable to retrieve email-related information such as From, To, CC, Subject, email content (body), and attachment details from the available tables. This issue is impacting our ability to complete the Report Job History…
-
Restrict Line Managers access to report on direct reports DOB and Address info
Currently our Line Managers having access to ran reports can pull their direct reports Date of Birth and Address information. We were able to restrict our Line Managers from viewing their direct reports Home Addresses and Date of Birth information. But we can't restrict them from pulling this data in reports. We opened an…
-
Receipt "Notes" field in Costing - Receipt Accounting Real Time OTBI subject area
Customer wants to use the "Notes" field in Costing - Receipt Accounting Real Time OTBI subject area This would really benefit being able to match-up receipts to invoices (or just understand why someone has receipts for a certain amount in free-text). I have already Raised an Oracle SR and they suggest that " This note…
-
SmartView Export for OTBI & OAC
When using the SmartView Oracle BI EE extension, you can open any OTBI and OAC Classic dashboard. It would be good to have the option to be able to export a dashboard in Query Ready Mode, the same as you can in FRC so that users can start in the web view and seamlessly move to Excel. This would also enable authors to share…
-
BIP date function for First Day of Previous Month
We have a report that we run on the first day of each month, and enter the Start Date and End Date parameters for the dates of the previous month. We want to schedule the report to run on the first day of each month. We can use a date function as the default value for the parameters, but our choices are {$SYSDATE$},…
-
Add BICC extract job id in MANIFEST.MF filename
When submitting multiple BICC extract offerings in parallel via the ESSWebService (submitRequest), each completed job produces a MANIFEST.MF file in UCM under the OBIAImport security group. However, there is no reliable way to associate a specific MANIFEST.MF file with its corresponding request. Business Impact: When…
-
SmartView - Enable simultaneous connections to multiple domains
Currently it is only possible to connect SmartView to a single domain. This enables EPM users to connect to all their applications via one connection however if you wish to view data or reports across domains then this is not currently possible. As SmartView can connect to ERP, EPM and OAC, all of which sit in separate…
-
Flag to indicate whether a receipt has an attachment in OTBI
Hello, We have developed a report using the subject area "Costing - Receipt Accounting Real Time". The report is almost complete, but a requirement has arisen to add a flag indicating whether or not the receipt has an attachment. I haven't found a column or formula in OTBI that helps me do this. Does anyone have a possible…
-
Source Asset number to be added in Sales -CRM subject area
We created OTBI report From Sales -CRM Asset subject area but the asset number field seen is only backend field only not matching with the Fusion UI. It is misleading .So found that source_asset_number column from zca_assets is the actual column matching with Fusion UI and not available in the subject area .Could you…
-
Improving SQL Developer Productivity in Oracle Fusion HCM
Problem Statement: Oracle Fusion HCM SQL Developer Experience Currently, developing and validating SQL queries for Oracle Fusion HCM is a highly fragmented and time‑consuming process for developers. SQL code is typically written in external editors such as Notepad++ or similar tools, without any direct connection to Fusion…
-
OTBI Subject Area for Agents and it's config
There is no subject area or out‑of‑the‑box report to view OTBI agents, making it extremely difficult to locate and manage them—especially when hundreds of agents are created across multiple subfolders under Custom. Additionally, if an agent is configured to “Run As” a user who has left the organization, it fails silently…
-
Token base connection for the content server instead of Username and password
We require Token base connection for the content server instead of Username and password. We are using this connection to write BIP report output to specific folder.
