-
Programmatically Retrieve Fusion Data Intelligence Audit, Security, Activity Logs (OCI Logging Mech)
Example implementation as used for Fusion Cloud - https://www.ateam-oracle.com/methods-and-ways-to-extract-oci-events-using-oci-audit-and-integrate-into-external-systems#:~:text=OCI%20provides%20two%20mechanisms%20to,for%20complete%2C%20authoritative%20audit%20extraction
-
FDI - Enable dynamic parameters in scheduled validation
We run scheduled data validation for OOTB ERP metrics. We have to hard-code future fiscal periods however this has drawbacks: Putting in more fiscal periods than actually needed which slows run time or could cause a time-out Requires ongoing parameter maintenance by FDI admin Benefits to dynamic parameters 1. Reduces data…
-
FDI HCM - Latest Primary Assignment Information
Background The FDI HCM Subject Areas return a worker's assignment information based on the anchoring date of the subject area. This includes attributes such as: Assignment ID Assignment Type Assignment Status Business Unit Department Location Job Grade Position Manager ID Manager Name In addition, FDI enforces data…
-
Fine-Grained Author Permissions for Datasets and Subject Areas in FDI
Currently, Author and Restricted Author roles are granted at the application level and cannot be scoped to specific datasets. As a result, users who require authoring access to a custom dataset also receive authoring capabilities across all subject areas they can access (for example HCM subject areas available through Line…
-
Licensing Model for FDI "Consumer Lite" Users
The current licensing model for consumers doesn't make financial sense to roll out FDI across bigger audiences that have less interactive reporting requirements. Considering that a consumer license costs the same as an authoring license, what is the value of making users consumers only. In a large organization, we need a…
-
FDI - Support Subject-Area-Level Separation of Consume and Author Access in FDI
Idea / Enhancement Request Oracle FDI should support subject-area-level separation between consume/read access and author/write access for the same user or role. Today, FDI security does not appear to provide a supported way to let a user consume reports from one subject area while restricting their authoring access to a…
-
FDI - Allow DV Export While Blocking Classic Access for FDI Consumer Users
FDI does not currently document a supported role configuration that satisfies all three requirements at the same time: DV consumption only DV workbook export No visibility or access to Classic In our newly provisioned FDI environment, users with the FAW HCM Licensed Consumer role can access DV content and export data,…
-
Incorporate DFF extensible fields into OCI Data Integration (OCI-DI) analytical views
Dear Oracle Support Team, I hope you are all well. We are writing to share a suggestion for improvement regarding the extraction of absence data in Oracle Fusion HCM. We have identified that in the base table ANC_PER_ABS_ENTRIES (according to the official documentation:…
-
NSAW:OOTB Income Statement Summary & Income Statement Detail report should use accounting period
The Income Statement report comprises two tabs: *Income Statement Summary and Income Statement Detail, both currently structured based on transaction dates rather than accounting periods. To accurately reflect profit or loss within a specific timeframe, the report should be redesigned to align with accounting periods OR…
-
AI-assisted tool to explain FDI vs. source data mismatches
Problem statement: Before users trust FDI, we have to show its numbers match OTBI and Fusion. That reconciliation is manual, slow, and not always straightforward: OTBI does not always have a clean one-to-one subject area match with FDI. When the numbers don't tie out, the cause is usually something like a back-dated…
-
Enable Native QR Code Generation in Oracle Fusion Data Intelligence (FDI) Report's data
Many business reporting use cases require QR codes to be generated dynamically from report data, such as Order Numbers, Invoice Numbers, Asset IDs, Shipment Numbers, URLs, and Fusion transaction deep links. Currently, Oracle FDI/OAC does not provide native QR code generation capabilities within analyses, dashboards, or…
-
Request for a Filter Bar update
The Filter Bar is useful given the ability to pin on multiple canvases in the same workbook. That said, it would be much improved if there were an option to see all of the dimensionality and filtering thereof that is taking place in the Filter Bar. At present a user has to scroll left and right and it's easy to lose track…
-
Object-Level Observability for Performance Optimization of OOTB Loads
Idea Description OOTB loads (snapshot to target DB switch) are inherently reactive operations. However, current monitoring provides only high-level process status and lacks visibility into object-level execution. Proposed enhancement: introduce object-level tracking (execution time, status, and DML metrics such as…
-
Workforce Core: Daily Average Worker Count
Create a new OOTB metric similar to the current 'Average Worker Count'. However, instead of calculating the average (AVG) using only the first and last day of the period (month), it would calculate the average across all days within the period. It could call it 'Daily Average Worker Count'... Tks.
-
Export the pop up data action dashboards to Excel
Connected two workbooks using data actions. One workbook contains a donut chart dashboard, and the other is set up as a table dashboard that opens as a pop-up when triggered. Although the table dashboard includes an export function, it isn't working until you change the pop up to new tab.
-
Dynamic Action Link URL Management in Oracle FDI
Problem Statement Currently, deep links embedded within Oracle FDI Classic Reports are environment-specific. During development and testing, these links point to the lower Oracle ERP environments (DEV/TEST). When the reports are migrated to Production, the embedded URLs continue to reference the lower environment,…
-
Adding "Agreement Document Type" filter as Mandatory Procurement - Agreements Data Validation
Currently the users are able to run the Data validation for Procurement - Agreements without selecting Agreement Document Type filter. This is resulting in wrong values while user is able to run the data validation by without selecting or selecting all Agreement Document Type parameter. But as per Refer…
-
Provide Semantic-Secured ADW Views for FDI Dataflows, SQL, and External Analytics Tools
Idea / Enhancement Request FDI should provide a governed layer of semantic-secured ADW / Autonomous AI Lakehouse views that can be used by Dataflows, SQL, Data Transforms, APEX, and external analytics tools while respecting FDI data security. Today, FDI provides strong semantic-layer access through subject areas and…
-
Governed Dataflow Writeback-Target Workspaces in FDI / Autonomous AI Lakehouse
Idea / Enhancement Request Oracle Analytics Dataflows already allow users to use datasets and subject areas as inputs, and Dataflow outputs can be saved to supported database targets. However, in FDI the missing capability is a first-class governed writeback workspace model for business users and power users. FDI should…
-
Add Project Execution Management Subject Areas to Oracle Fusion Data Intelligence
Idea / Enhancement Request Oracle Fusion Data Intelligence currently provides strong Projects / PPM analytics for financial project reporting, including project costs, budgets, forecasts, commitments, billing, invoices, revenue, labor, and funding. However, many organizations also execute non-traditional projects such as…
-
Ability to share URL's to Folders in the Catalog
It would be useful if we could obtain the URL for specific folders in the Catalog - allowing the ability to share entire folders full of reports and DV's with users easily. While we can share links to individual dashboards, sometimes, there is a collection/suite of reports that will be relevant - the ability to share a…
-
CAA - Missing Project ID for PPM sourced by Payments, missing supplier_party_id from PPM misc cost
The Configuration Account Analysis template is not generating correct values for two scenarios: A project cost transaction is sourced from Payments; therefore, the GL Journal Source is Payables and the GL Journal Category is Payments. The expenditure_item_identifier is populated but has PROJECT_ID of -99999 in…
-
Commentary Capture within FDI/OAC Dashboards - attached to Years, Periods, Segment Values, etc
My organisation is currently starting another phase of Finance and Data Transformation and one element we are looking into now is wider Finance Management Reporting. So far - we have used FDI predominantly looking at Direct Expenses/Direct Costs and using it almost in an Operational Reporting way - enabling closure of the…
-
Ability to Extend Specific Node whilst keeping others collapsed to see the data as Tree
Currently the Tree like drill down capability only exists in Cost Center Hierarchy. This should be standard across all Hierarchies. Current Cost Centre Hierarchy will allow me to see some nodes extended and others not. This allows me to see the financial data exactly as I need. I cannot do the same with Org Hierarchy or…
-
Data lineage GUI
Dear, Would it be possible to provide a graphical user interface (GUI) representation of data lineage, featuring a collapsible parent–child (tree) structure? While we currently maintain comprehensive documentation in Excel, we would like to explore whether a similar capability could be made available within FDI as an…
-
Provide standard reporting to Fusion Application Entry-Point Usage and Transaction Originating
Organization Name: CNAF – Caisse Nationale d’Allocations Familiales Description: There are currently analytics related to user activity, transaction activity, sessions, and report usage. However, there is no delivered reporting capability that allows IT Management to understand how users navigate through Fusion…
-
FDI OAC Layer and new "read only data store" associated with Fusion Data Extraction Feature
Earlier this year the Oracle Fusion team introduced the new "Fusion Data Extraction" feature, which is being positioned as a replacement/improvement to BICC. Data Extraction Using Read-Only Replicated Data Advertised as a part of this feature is a "near real-time replication of Fusion Cloud data into a dedicated, read-only…
-
Implementing 6-Month Wallet Rotation option for Oracle Autonomous AI Lakehouse
This idea proposal recommends adopting a 6-month frequency for rotating wallets (credential stores) in Oracle Autonomous AI Lakehouse environments This measure aims to enhance security, ensure compliance with best practices, and reduce the risk of credential compromise for all business units leveraging these environments.…
-
JE Nomenclature Should Populate on Both Sides of Intercompany Transactions in FDI
Organization Name: Project Maverick Description: Intercompany transactions are booked on both sides (receiver and provider/seller) in the Oracle Fusion source system and integrated into FDI via the standard data pipeline. However, JE Nomenclature (JEN) only populates on one line per side in FDI, resulting in 2 total…
-
FDI - SFTP Data augmentation currently supporting only unencrypted files loading
FDI - SFTP Data augmentation currently supporting only unencrypted files loading : FDI should allow to do process PGP encrypted files using PGP keys to bring End to end security in dataatrest and in-transit as well. Please assist to implement the idea.
