-
Object storage connection from fusion bi publisher
Hi, We have requirement to send the bip report output to object storage.. when this feature will be available in fusion. At this moment we are manually uploadiny the output to object storage.
-
Using Parameters in Headers
We created a Financial Table Overview (P&L). Displaying the costs of the last 3 months, YTD figures, FY figures and prev year figure extrapolation etc. For period filtering, we created a custom parameter for " period end selection" . We also used this parameter within the header of the actual costs column displaying the…
-
FAW HCM - Workforce Absence Management Analytics Offering - Overview Dashboard with D&I view
Summary: With 21.R2 FAW release , FAW HCM has added a new offering of HCM- Workforce Absence Management. This analysis shows various capabilities/features of the subject area. Content (required): With this analysis you can answer following business questions : * How many leaves are approved , withdrawn, rejected & pending…
-
Agency Invitation Date?
Is there a reporting field available that represents the date that a job posting was sent to a Staffing Agency to invite them to submit candidates?
-
Migrate Custom Web ADIs To Oracle Fusion (Cloud ERP)
Dears, Any one have migrated his custom Web ADIs from Oracle EBS to Oracle Fusion? I need to explore what is the available options. We have multiple Web ADIs that is using tables and procedures as interface/importer. Regards, Ali
-
Extend Configurable Account Analysis Subject Area
Hello. Is it possible to extend the available columns of the CAA Subject area outside of what is available in the select list. Example: We want to add Invoice Creation Date to the CAA Subject Area but it is not available in the configuration page. What is the best approach to getting additional columns added? Can we use…
-
Data Flow Step Names & Descriptions
It would be helpful to be able to name individual Data Flow steps and assign descriptions to each. Is this a feature we can expect in the near term and does anyone have comparable workarounds for end-users seeking this visibility?
-
Applying filter to report attribute but keep the rank as unfiltered
I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attribute but keep the Rank as unfiltered or unaffected? For Example, In the below screenshot I want to filter on the Balancing Segment but I do not want the…
-
Difference ODI on MP vs Oracle Data Transform
Hi Team, We are in the process of selecting an ETL tool to recommend to our client for their FDI implementation. Could someone clarify the differences between recommending Oracle Data Integrator (ODI) on Marketplace (MP) and Oracle Data Transforms? I understand that Oracle Data Transforms have recently been suggested as an…
-
FDI : Auto Insights - Playlist
Auto insights are visualizations that Oracle Analytics generates based on your dataset's measures, attributes, and relationships. You can add these generated visualizations to your workbook. The Auto Insights feature does the work of a data scientist and helps you understand and analyze your data more completely. Each auto…
-
Is it possible to insert custom text in line chart at specific time in X axis?
I'm trying to keep track of events (by adding free text) like the white ovals in this picture: Is it a thing in FDI? Thank you
-
Not able to open External Semantic model template
Hi Team, I have to work on external application and as per documentation, downloaded External Semantic model template. Whenever i am trying to open it through BI Admin Tool, getting an error- The repository is corrupted, or you don't have enough operational memory. Password which is being used to open it is Admin123. Below…
-
FAW - ADW database and Azure Data Factory connectivity
Hello All Have a situation in a project where we need to establish connectivity to FAW - ADW database from Azure Data Factory in the Azure cloud. When we provisioned the FAW - ADW instance, we provisioned with the Network option Mutual TLS (mTLS) authentication as "Required" in the ADW. This setting works perfectly fine…
-
Grand total in pivot table is not showing as expected
I created a pivot table to track expenses and selected 'Row' in the Grand Total to sum up all the rows. However, I've noticed that the Grand Total for the last column, "Transfer Pricing Service Fee," is not correct. It should be 81,103,435.62, but the current total is 79,419,921.72.
-
Customer_TRX_ID physical column in not enabled in oracle OOTB AR Transactions SA
We are trying to create a derived physical column with Customer_TRX_ID with the help of AR Transactions SA but in the OOTB subject area it is not showing up in semantic model when trying in add column step, derive physical column. Is there a way to enable by oracle? Note: Presentation column is available in OOTB SA.
-
SQL query or Table for Cost Accounting Distributions
Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organization, Cost Book. Attached screenshot below for reference. Thanks.
-
Is it possible to copy and paste multiple CoA segment values into a dashboard filter?
Some of the business users in my organisation have large lists of legal entities and cost centres they need to filter reports by. Currently, they are having to manually select each value one by one in a dashboard filter. Is there a way to copy and paste multiple values into a dashboard filter (or similar) to filter the…
-
Is there any plan to make web-based OAC Semantic Modeler available in FDI?
We are considering to use Application Merge functionality in FDI HCM to model some complex use cases on external data through OAC semantic layer, while keeping the possibility to reuse FDI HCM conformed dimensions. The documentation, demos and initial tests assume to use BI Admin Tool to develop the model, will the…
-
24.R4.P1 List of Bugs Fixed
Where can I find a list of the bugs fixed on 24.R4.P1? The "What's New in Oracle Fusion Data Intelligence" page does not have any additional documentation.
-
Security Enhancements for Talent Acquisition 24.R4
Hi All, In the Talent Acquisition subject area: Support data security for existing HCM Business Unit Data Security , HCM Legal Entity Data Security, and HCM Department Data Security roles. Support HCM View All data role. In future releases, Recruitment Job Application View All Data Role and Recruitment Job Requisition View…
-
How to use multiple different Oracle subject areas in one report?
I am currently trying to recreate a BI Publisher report that shows Sales and Gross Profit into FDI. We are pulling in fields from SCM-Sales Order, Financials-AR Transactions, SCM-Inventory Transactions, SCM-COGS and Gross Margin that are all currently working in the report. We also need to pull in supplier name and…
-
How do I add the FDI link onto our oracle cloud homepage
I am looking for the steps to add a link to our FDI instance from our Oracle Cloud homepage as shown in the screenshot below:
-
Can local users of Fusion domain can access Fusion analytics without a user in Fusion Applications.
Hi, We know that only fusion users can access Fusion analytics has its fusion domain is associated with Fusion authentication. Whether local users created in Fusion domain in OCI can access Fusion analytics or not. ? As Fusion analytics login is redirection to fusion application login page we cannot access the Fusion…
-
How can I join the SCM tables with Financial tables in Oracle Fusion ?
I'm developing a SQL report to join in Customer_po_number from DOO_HEADERS_ALL with Invoice_num from AP_INVOICES_ALL. However, there’s no direct common column between them. How can I effectively link these tables to retrieve relevant information for my report?
-
OAC instance feature limitations in FAW
What are all the feature limitations of the OAC instance that is coming along the Fusion Analytics Warehouse? Is there a document which I can refer to? I am referring to limitations such as customizations, console access etc., I would like to know what else is not supported in the OAC instance that is coming along FAW.…
-
we want to pull the login details for a particular user using Fusion Security: REST API
we want to pull the login details for a particular user using Fusion Security: Using Sign In - Sign Out Audit REST API ( Doc ID 2661308.1 ) by passingusername as parameter. using this API in postman. but getting only default result. not filtered with user any specific user. As per oracle recomaqndation, The accepted…
-
Error while applying external app, system steps and customization steps in FDI
We add few FDI Tables like DW_FACT and DW_DIM ( standard Tables). we created a custom BMM Model and Presentation Subject area. After Deploying the RPD in FDI Instance, Validation is success but merging process is getting failed . Error:- ---Started merging external application rpd--- Started external app update Updated…
-
New HCM legal employer not displayed in FDI when adding hierarchy from org hierarchy subject area
Hi, Last December, my client added another legal employer in HCM. I've checked the hierachial tree, and this legal employer has a service, business unit, and pole attached. However, when I tried to find this legal employer in FDI, I faced an issue : If I filter the legal employer i want (biogenie) and add the department…
-
Absence information in FAW is as of Absence date but not as of today
Hi Absence information in Fusion Analytics Warehouse is as of Absence date but not as of today. We observed in HCM Absence subject area (HCM-Workforce Absence Management) that all the information like location, department, organization,manager etc.. is as of the absence date and not as of current date. So if absence was…
-
Attributes of Pay Elements and GL Mapping
Hello Experts, I'm trying to get more information about every payroll elements and their attributes within the system such as whether the element is taxable, niable and/or pensionable. Can anyone point me to table/view/report that contains this information? Also, for Payroll GL mapping, can anyone point me to the…
