-
Support for SSO Login User Credentials - For BI Publisher/OTBI
Hello Team, While attempting to establish connectivity with BI Publisher using the BIP connection, or while connecting to OTBI Fusion Analytics using the default Fusion Application adapter in OAC, the connection fails when using Fusion SSO user credentials. The adapters currently support only native Fusion user credentials…
-
Request to add Data and Duty Role information to What's New for Newly Added Functional Areas
As of now, What's New in Fusion Analytics Warehouse doesn't include data and duty roles to be enabled for newly added functional areas. We enabled a new functional area and loaded the pipeline, but users were not able to see the functional area. It was not until searching through the Application Roles that we realized that…
-
Add measure Number Openings Left to Fill to the FAW HCM Talent Acquisition Job Requisition fact
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Penske Truck Leasing Co LP Description (Required): FAW currently does not offer the measure of 'Openings Left to Fill' under the HCM Talent Acquisition subject area. the measure is offered in…
-
Additional filtering and/or record purging options for Data Augmentation tables
Use cases arise where data augmentation tables are leveraged for custom ETL or views in FAW-ADW. In such scenarios, the data augmentation attributes are not directly published to the semantic layer. However, depending on the source PVO, these tables can accumulate records quickly (i.e. PVO for XLA_AE_LINES) in production…
-
How to Create Deep Links for Finance Screens in FDI
Hi everyone, I’m looking for guidance on how to create deep links for all Finance(AP,AR,GL,FA,CM) screens in FDI. If anyone has experience with setting up deep links, best practices, or any documentation/tutorials that explain the steps, please share. Thanks in advance for your help!
-
Requirement to default Current period in FRS report prompt
Currently FRS reports showing the default period which we have selected to default at accounting period prompt but client expressed their concern to default it based on current GL open period i.e the default period has to change based on GL open period. Can anyone Kindly advise how can we default Accounting period with…
-
Need Ship to Details and Item details in VRM Fact tables
Hi Team, I am creating this Idea on basis of SR# 4-0001310008. when we are trying to create with Item details/ship to customer details along with Revenue Management Subject areas (Financials - Revenue Management Contracts, Financials - Revenue Management Accounting Events, Financials - Revenue Management Accounting) we are…
-
Improving the Error message for FDI Data Connection
Recently there was an error in BIPublisher in FDI in development environment post refresh from Production Fusion. The Error message says as below. oracle.apps.bi.extractservice.exception.DataExtractException: Following report paths do not exist in BIP : /Custom/FDI/Projecttask.xdo,Custom/FDI/Project Data…
-
Need Vendor Details in PR alert Mail.
I would like to raise a requirement regarding the Purchase Requisition (PR) email notifications. Currently, when a PR is raised with an approval flow, the email that gets triggered does not include vendor information. However, the vendor details are available and included in the Purchase Order (PO) email alert. We would…
-
FDI Documentation Enhancement: Publish Outline Logic for Key Metrics
While the Oracle FDI documentation does outline the high-level logic behind metric calculations for ERP, HCM, SCM and all applicable functional pillars, I was not able to locate the same for Key Metrics. Client teams often expect this to be available (when we had key user trainings sessions), so they can clearly understand…
-
FDI: Add Employee Email Address to HCM Subject Areas in FDI
Hello, Our customer has requested the addition of employee email information in the HCM Subject Areas of FDI. In a recent Service Request, the Oracle support team mentioned that an internal enhancement request is already open (Enh 33850532 - FAW: EMPLOYEE EMAIL ADDRESS COLUMN IN HCM) and recommended submitting this idea to…
-
How to Create Deep Links for PPM Screens in FDI
Hi everyone, I’m looking for guidance on how to create deep links for PPM screens in FDI. If anyone has experience with setting up deep links, best practices, or any documentation/tutorials that explain the steps, please share. Thanks in advance for your help!
-
Enhancement: Request to Address Conditional Drill Limitation in FDI Product
In the current FDI product, we have implemented a conditional drill feature in our reports. However, we are encountering the following issue: When executing a report with conditional drill enabled, we receive the error message: “Exceeded configured maximum number of allowed input records” whenever the query processes more…
-
Apply System Step or Publish Custom Branch in Semantic are taking too much of time
Hello Team, Apply System Step or Publish Custom Branch in Semantic are taking too much of time to complete. FYI we have 150+ steps in the semantic model extension. We know when ever we create or modify DA apply system steps will run and it will validate all the steps in the semantic and when we publish the custom branch…
-
#PM - Restrict Consumer role from downloading/exporting data reports and dashboards
Enhance the application Consumer role to be split into two distinct roles: Viewer: Can view reports and dashboards but cannot download or export any data. Exporter: Has permission to download/export report and dashboard data
-
How to create deep link for Project Cost for PPM in FDI
I'm using the standard subject area (PPM-Project Costs) to build reports. One of the report columns is Project Number. I need to create a deep link to show Project number as in FAW. Once I click on the number, Project Number page opens in fusion.
-
API to reset the last extract date in BICC PVOs
API to reset the last extract date in BICC PVOs. Use Case and Business Need (Required): We have created data sync integration from SaaS to PaaS for BICC PVOs. But sometimes we need to sync the full extract in case the integration errors out due to any reason. So we need an API through which we can reset the last extract…
-
Ability to reset&reload specific offering ex:- only Financial Analytics, Financial and HCM Analytics
Ability to reset&reload specific offering ex:- only Financial Analytics, Financial and HCM Analytics
-
Ability to reset&reload specific Offering
Ability to reset&reload specific Offering where multiple offerings was enabled. Ex: reset&reload only HCM Analytics - any related dependencies between functional areas cross offering should also auto included.
-
Ability to Add and Modify Descriptions on Derived Columns in the Semantic Modeler
Delivered measures in the subject areas in FDI have names and descriptions which can both be seen in the workbooks in OAC, but the custom derived columns added to the subject areas through the semantic modeler cannot. While a workbook author in OAC can add a custom calculation with a name and description and reference the…
-
Soft Delete option in FDI
FDI sometimes retains source records even though the source transaction was deleted or deactivated in Oracle Fusion Applications. Example: “Data Deleted in Fusion Application Shows in FDI”. Please provide a “soft delete” detection or a “purge” option per functional area to remove records when source is deleted, or flag…
-
Gain And Loss subject area : Dimension Organisation
Hello in order to have better visiblity on internal mobilities cross the organisation tree we would like to have dimension organisation available in the Subject area like the workforce core. This will be very usefull to drill down and get more granularity. Also for customers who took the choice to use custom AOR security…
-
Using BICC PVOs and need a method for identifying records that are deleted in Cloud Fusion
Currently using BICC PVOs to extract Cloud Fusion data from different workstream areas (FSCM and HCM) to build a data store - used for reporting and analysis. We have noticed that the BICC PVOs identify updated and new records, but we are unable capture deleted records in the Fusion app without a full table load. Full…
-
Rollback Security when Semantic Model (SME) migration fails
We were trying to promote a bundle of our SME from Test to Prod environment after hours and ran into a failure (twice). We ran out of time to perform a successful migration so were intending to leave the SME migration for the next after hours time. We received reports that users could see more data and reports than…
-
Key Metric Bundling
When creating a Content Bundle for key Metrics it would be nice to be able to select the key metrics for an Instance refresh. Currently there are no checkboxes to select which key metric you want. An alternative I tried was to export each data flow and import one at a time in the new instance. However, this method imports…
-
Enhancement Request
Please refer to SR 4-0001246705 4-0001135482 Customer is trying to custom the OOTB mapping for that they adding the column TRANSFER_ORDER_LINE_NUM_CHAR but it is not available in the Add Physical Column It is visible in the table DW_INV_TRANSFER_ORDER_CF
-
Data Reloads/Data Maintenance - ability to reload current financial year/current month only
My organisation requires a full reload of the GL functional area once a month on the last day of the month to ensure Analytics Currency (GBP) is present on all transactions. Some business users post GL Journals with future accounting dates to non-GBP Ledgers (EUR, USD, etc). If you have an accounting date of 30/11/2025 and…
-
Oracle Fusion Reports should access Oracle APEX ATP Data
Hi, As we know moving from on prim Oracle EBS to Oracle Fusion can have different challenges and one of them is location customization to develop features which are not avaialble in Oracle ERP. Now in Oracle Fusion we can develop functionality in Oracle APEX using Oracle fusion API but issue is we also need data stored in…
-
Sorting option for feedback template
Currently, in Oracle HCM Cloud Feedback Center, feedback templates appear in a random or system-defined order, and there is no option to configure or define a custom display sequence. Our business requirement is to display feedback templates in a specific sequence based on organizational hierarchy or type, for better…
-
Data Aggregation Issue with GL Data in FDI
We have created a GL subledger report in FDI that retrieves journal information. However, the data appears aggregated, and we cannot view detailed entries. For example: In BIP, a single journal line generates 356 distinct rows, each with a unique aeHeaderId. In FDI, the same journal line shows only one aggregated line. The…
