-
Deeplinks why cant I get it to work with the record number as the Oracle SCM guide suggests
Im trying to open a work order edit screen from an OTBI report. the Oracle guides seem to suggest that the number can be used as the objKey Or in my case the work order number Trying to get it to work as follow using the WONumber column has not worked…
-
I want to drill down from FDI tabular report to a selected Purchase order number to ERP
I want to drill down from FDI tabular report to a selected Purchase order number to ERP.
-
Rehired user getting created as a duplicate user in ERP.
When a user that has been terminated is rehired, it creates a duplicate user in ERP for them with the same user ID but a different assignment number. This behavior is new and is causing issues for the import because it looks for a valid Manager and users have the original Manager assignment number instead of the new one…
-
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.
Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Article Links," and Article Status for Knowledge Articles. However, I am unable to view the data for the Knowledge Article Status column in OTBI. I've also…
-
FDI Configuration Data Management-configuration data as models, pipelines, and reports
@Krishna Prasad Kotti-Oracle @Dayne-Oracle Can anyone kindly assist me with a few responses to the queries below? That would be greatly appreciated! FDI Configuration Data Management – Key Considerations I am keen to understand how configuration data is managed within FDI, specifically related to models, pipelines, and…
-
FDI CX Analytics - Support for prompt filtering with multiselect column values
Looking forward to know if we have any support for multiselect prompt filter for the following standard usecase without adding any additional effort of having to denormalize the data into a separate table for this purpose to create an entry for each selection and use the same as subquery to filter the result. Please see…
-
I want the number of days of an absence plan.
I am creating an analysis at the request of the user, where it is required to show the calendar days that the user has, but in the thematic area of Personnel Management - Real-time absence, it does not show the calendar days of the absence plan; it only shows the absence plan, its description, and other fields. How could I…
-
How to Replace GL Account Analysis Columns with Configurable Account Analysis Columns in Workbooks
We have several workbooks with reports that use columns from GL Account Analysis, both the out of the box subject area and a custom data set. In the CAA documentation, it states : The existing visualizations and workbooks set up based on the GL Account Analysis or Account Analysis Foundations subject areas aren't…
-
Remove Parent Level Nodes from Child Hierarchy Levels
Is it possible to have Parent values in Hierarchy Tables not to show at the children levels of the node? For example, if Cost Center Code '1A' is at Level 31, It will render as a value all the way down to the lowest level of the hierarchy. This makes prompting on Hierarchy columns extremely difficult beyond having to…
-
How to create an extension for a custom subject area
We have created a new subject area called HCM - Workforce Core Limited via a Semantic Model Extension. We want to create a separate extension on the new subject area in order to add additional attributes to the new subject area. When attempting to select HCM Workforce Core Limited as my target subject area in my new…
-
Extract data from FDI to Snowflake
What are the options to extract data from FDI and load to another system or data warehouse like Snowflake ?
-
FDI Demo Video
Hi There, Does anyone have an FDI demo video that they can share? my client is asking for one, specifically for HCM
-
OTBI Time intelligence functions does not work.
We are new to Oracle, fresh implementation. I have tried to use AGO and TODATE functions to sum up and compare ITD figures etc but somehow it errors out when i run. It feels like time levels are not recognised at all. error: Formula syntax is invalid. [nQSError: 10058] A general error has occurred. (HY000) [nQSError:…
-
Transpose data from rows to columns in FDI
Hi, Is there a possibility to transpose the data from rows to columns in FDI? How to create a report that displays Previous Assignment and Current Assignment as columns instead of rows? For example, an assignment column holds all the assignments of an employee and using the assignment end date, I want to create two…
-
How to fix the discrepancies between FDI /ADW table data and Oracle ERP
We have discrepancies between FDI /ADW table data and Oracle ERP data. I am looking at project revenue and some other data and they are quite different.. It appears that ADW and FDI is not updated for some days or transactions. I have used the FDI built in dashbaord to shwo issues at high level and the document below..…
-
How to create a report with Opening,Closing,Inbound and Outbound stock?
I want to create a report like below format, but as Inbound and outbound qty change whenever a new entry hit, so i'm unable to achieve it datewise or you could say a Static record for a specific day. and same for Opening and closing balance. If someone have done this before please do let me know. Thanks in advance
-
Records inserted daily
Hi , Is there a way to find out the records inserted in FAW/ADW as part of Full/Incremental Loads?
-
Access FDI Workbooks configured under Private endpoint from Oracle APEX public network
We are currently trying to provide functionality for users to access the FDI workbooks configured at private endpoint from Oracle APEX Application configured at public endpoint. Does anyone have any steps to establish such setup?
-
Daily Loads/Incremental Loads into Oracle FDI
@Krishna Prasad Kotti-Oracle could anyone recommend the best approach or best practices for scheduling regular data reload jobs into the FDI environment? This is currently a key requirement for ERP Analytics.
-
How can we manually trigger refresh for fusion pipeline even we have scheduled refresh in place
Hello, How can we manually trigger a refresh for the Fusion pipeline? I attempted to do this by selecting 'Enterprise Resource Planning' and then choosing 'Refresh Data' for the functional area General Ledger. However, I received the error message below: "An incremental load is scheduled to run in the next few hours.…
-
Unable to download the Reusable Workbooks (FDI Artifacts) for Fusion Data Intelligence
Hi, I tried to follow this blog Reusable Workbooks (FDI Artifacts) for Fusion Data Intelligence which is pretty nicely written. But when I tried to download the dva file from oracle public reference link it gives me error.…
-
FDI pipeline Configuration Prerequisite
There are some prerequisite steps to be completed in Oracle Cloud Applications for Fusion Data Intelligence: 1.Assign Financial Categories to the Natural Accounts 2.Make the Key Flexfield Segments of your Chart of Accounts BI-Enabled 3.Create Segment Labels for Desired Segments and Map them to BI Object Names 4.Flatten and…
-
Issue with Multiple Custom Person Security Profiles in FDI Semantic Model
I'm implementing custom person security in Fusion HCM using the guidance from this blog: https://blogs.oracle.com/analytics/post/fdi-data-security-implementation-of-fusion-hcm-person-security-profile-custom-criteria-in-fdi. In my use case, I need to implement two separate custom security views for two different application…
-
Invoice Lifecycle Metric in AP subject areas
I am looking for a metric that displays the current stage of the lifecycle for each invoice in the OOTB AP subject areas. I believe that I recall something to this effect being presented previously, but I am not able to find it now. Maybe it's something that is soon to be available if it is not already available?
-
How can we integrate our company's procurement policy into Oracle so that the chatbot can assist?
Specifically, we would like to know: File Formats and Requirements: What formats (e.g., PDF, Word) and specific requirements should our procurement policy document meet when uploading to Oracle? Integration Process: What are the steps involved in uploading the procurement policy into Oracle? Are there any specific modules…
-
Demo version/Instance for FAW
Hi just wanted to know that Is there a demo version / Instance for FAW like we get Vision instance for oracle fusion for practising and showing to the client? If Yes would like to get link and credentials for same
-
I need a SQL Query to pull Hours and Wages by Day paid.
The Periodic Payroll Activity report list Wages and hours summarized by process Date and element. Staff are able to view the Run Results by person and by day in the Run results option, but they are unable to print or extract the view. I need an OTBI report where they can enter an person number and receive the detail of…
-
Identify Source System/Fusion application in Reporting Layer
Hi Team, Is there any variable or table which is capturing the URL/Name of the Fusion application which is ingesting data to ADW ? End user wants to see that information over a report. Though the Source Fusion application can be identified in OCI and a variable can be created to store that info. But if its being…
-
Standalone security and user access administration in FDI untethered from Oracle Fusion
Is it possible to administer security and user access in FDI completely standalone and not inherited through Oracle Fusion even though all transactional data for reporting within FDI needs to come from Oracle Fusion?
-
Can't load Models - Restore your models
Hi all, We are seeing this error appear in our DEV environment. We do not believe there were any changes made to security/bundles/etc.. Is there a concept of restoring subject areas in FDI
