-
Regarding - Receivables Aging by Accounting Date
With 26R1, a new Preview feature is provided related to AR aging. There is no details or no documentation reference under: Features Available for Preview Appreciate if the product team provide appropriate level of (Techno-functional) details on "Receivables Aging by Accounting Date". thanks,
-
FTE Gain and Loss Validation using OTBI
Has anyone figured out the query/report using OTBI for the validation of these 2 key metrics from the Gains and Losses subject area in FAIDP/FDI? Any help would be highly appreciated.
-
How can we Migrate FDI from Default Identity Domain to different Identity Domain?
FDI is initially provisioned with default identity domain and various development was done in FDI along with few custom schema(s) in the underlying ADW. Can someone point or suggest the recommended approach to point the FDI (Default Identity Domain) to FDI (Test Identity Domain) and subsequently promote to Prod?
-
Reporting Project Burdened Cost by Bill-To Customer Account in Fusion AI Data Platform
Hi All, I have a requirement to show project revenue minus project burdened costs per bill-to customer account in Fusion AI Data Platform. I see there is a built-in relationship between revenue and bill-to customer account via the Bill Plan ID. What I do not see is how to relate the cost to the bill-to customer account. We…
-
Errors when using custom subject area
Hi, i am getting these errors when using a custom subject area
-
Integrated Oracle FDI with Fusion App - SSO
How is Oracle FDI which is created in the same identity domain as Fusion ERP utilize SSO from ERP ? I have read multiple Oracle documentations where it says FDI automatically inherits the existing SSO configuration from ERP, but want to understand how is this happening behind the scenes? We haven't received IAM Upgrade yet…
-
How to restrict ledgers, BUs of interest for daily refresh
Hi, We use FDI Finance analytics, and have multiple ledgers, legal entities, BUs. Not all businesses use analytics. Is there a way to select only some ledgers or BUs for daily refresh. As this will reduce data refresh time, also, improve performance.
-
email trigger is not working in ai agent studio
We have Microsoft email id and tenancy id and client id and secret but the email is not trigger how i can configure the email trigger
-
When we use a column from "Organization Hierarchy", the intended number of records are NOT returned
Problem Summary: When we use a column from "Organization Hierarchy", the intended number of records are NOT returned Problem Description: We are developing a report in which we are using the subject area " "Workforce Management - Worker Assignment Real Time" in one of our OTBI reports. When we don't use the folder…
-
How do you Validate Data in Inventory Receipts Subject Area
We have a requirement to validate the Receipt Line Count metric on SCM - Inventory Receipts Subject Area of FDI against OTBI. As we do not have a pre-built data validation for this Subject Area, We wanted to understand a way to create a validation report on OTBI for this. As per the Metric Calculation logic provided by…
-
How to Validate OOTB metric Item Based Purchases %
We have a requirement to validate the OOTB metric Item Based Purchases % available on Procurement - Spend subject area. As per metric calculation sheet for Procurement, following is the formula : Filter(Count Distinct(Purchase Order Line ID) Using Is Purchase Order Matched Flag = 'Y' and Inventory Item ID > 0) / "Purchase…
-
How to use OTBI subject areas in Oracle FDI?
Hi, I am trying to pull/use OTBI subject areas in Oracle FDI. Is there a way to do so? Thanks, Ruvina
-
Oracle FDI Semantic Model Status Not available after data augmentation with bi publisher
Hi, is it correct that after performing data augmentation with a report from BI Publisher, the augmentation has the "Semantic Model Status" set to "Not Available"? And if it needs to be set to "Available", how can this be done?
-
Saving a data science model
I'm following this guide: https://blogs.oracle.com/analytics/create-a-data-science-model-for-oac I don't understand how the "Save to the Model Catalog" part works: can someone explain how should I change the code in order for it to work in my environment? How should I retrieve all the info?
-
Model input and output schema
Hi, I am trying to create model for regression, when it asks to add a JSON in Input/Output Schema what does it exactly expect to be the file and does it exists any documentation about it?
-
Gender Pay Gap
We are trying to setup some dashboard to show Gender Pay Gap. We think one of the best option we have is to upload a python script in order to pre calculate imported data. Here are some examplese: https://docs.oracle.com/en-us/iaas/Content/data-science/using/models-practices.htm We didn't understand yet what should be the…
-
26R1 Preview feature: "Receivables Aging by Accounting Date"
In 26R1 Preview feature - A feature introduced for AR Aging "Receivables Aging by Accounting Date". Anyone leveraging this feature? Appreciate any details on what changes in the current AR Aging SA, any new metrics introduced (if any), what is the use case around it etc.? Any pipeline impacts?
-
Enable AI Assistant for Datasets not just Subject Areas
In OAC there's a capability to index a specific dataset for AI assistant usage. Is this supported on the FAIDP side? When going to the OAC console of FAIDP I see subject areas listed, but not datasets.
-
Discrepancy in Net DR/CR for Non-Translated Transactions (X, XX) in DW_GL_BALANCE_ALL_CF (FDI)
Hello Experts, We would like to understand how data flows into the DW_GL_BALANCE_ALL_CF table in Fusion Data Intelligence (FDI / ADW). In the source (Fusion GL), each transaction has a Translated Flag with values such as Y, R, X, and XX. During our analysis: For translated transactions (Translated Flag = Y and R), the…
-
Success Navigator : Starter Configuration
Hi, We were initially informed that one of our non‑production environments needed to be allocated for Starter Configuration. After completing that step, we encountered an error during setup indicating that the environment is not empty. We’re now blocked, as there is no documented method to purge the environment and prepare…
-
Change Data Tracking - Feature Info
The march2026 roadmap for FAIDP includes "Change Data Tracking" under Platform. Is there more information available for this feature?
-
Import historic data from external source
We are developing a monthly import of employees info. With time data evolves and we want to keep track of historic values. Is it ok to import data with a time reference (eg: year and month) in order to add new data every time? I'm asking because I know FDI is not very user friendly with historic data
-
Oracle FDI - Budget date of the purchase requisition and PO
I need some assistance on where Oracle FDI stores the Budget Date for PR and PO distribution lines. In our organization, when a user creates a requisition, funds availability (budget) is validated based on the Budget Date. If funds are not available, we adjust/reshuffle the budget so the requisition can be approved, and…
-
Having an issue to achieve Hierarchy based Absence reporting in FDI (Direct and Indirect)
Need to create a dashboard to show all direct and indirect managers under a selected manager, along with their combined direct and indirect reportees’ absence data. Since the Manager Hierarchy in FDI doesn’t return data for me, I explored alternatives: Using the Position Hierarchy (Top Position as filter and Manager Name…
-
Getting an FDI Subscription
Hi, Is the following OCI subscription correct to have an FDI instance that can be used to connect to a Fusion ERP / HCM / CX / SCM instance ? Thanks , Tamer
-
Salary gender pay gap
I have this example: 1st column: salary 2nd: gender 3rd and on: other variables I'm trying to plot a scatter chart, so far I have this: I'm trying to obtain something like this, with line showing all coefficients: What I'm doing wrong? I tried different configurations
-
FTE by Gender/Nationality
I am trying to create a workbook using the subject area 'HCM - Workforce Core'. Attached the one I created. , but I have to filter it with some salary code(lonkode). ( We already have the same report available in Qlik and I am trying to recreate it in OAC), but I don't see any HCM related subject area is having this…
-
Dynamic column names and respective column values for BI report
I am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format. Please can someone help me on this.
-
Create an Integrated Oracle FDI with Fusion App - SSO requirement
In Administering Oracle Fusion Data Intelligence 24R4 document, it has below statement: When you create an Oracle Fusion Data Intelligence instance using the Integrations option in Oracle Fusion Cloud Applications, you automatically get: • The users, groups, and roles from Oracle Fusion Cloud Applications. Also, you don’t…
-
Is it possible to consider leading zeros from an XML file in Excel Model BI Publisher?
I'm designing a report with two sheets: One containing a regular table. Another with a pivot table. In my XML file, I have the <OP> field displayed as follows: <G_1> <ORD>1</ORD> <ORG>0001_OI_CED_MAT</ORG> <ITEM>VGA20143</ITEM> <DESCRI>VIGA I 6 A572 (W150 X 18.0) C/ 6000MM</DESCRI> <OP>0001.2461</OP> </G_1> For the first…
