-
Report for Mobile and Web browser Usage
We would like to suggest a seeded report that can provide information on the usage of the Oracle Fusion Application based on the source it has been accessed with. This information would allow the HR to have an idea on how many users are using the Oracle Fusion Application from their Smart phones, Tablets and Web Browsers.…
-
FDI - Last Data Load Info on the Reports
Can we have last data load/update date and time displayed on FAW/FDI reports?
-
Include PO Distributions DFFs in Procurement SA
Please provide the ability to choose descriptive flexfields from the DFF - Purchase Order Distributions under the Descriptive Flexfield (DFF) folder in the Purchasing - Purchase Orders subject area in FDI.
-
Data lineage between FAW and FA
Team, It would be great if we can have a data lineage between FAW OAX_USER tables to the PVO's in the FA. We are trying to unify OAX_USER table with history data migrated from on-premises DWH. It's difficult to manually identify the tables and columns. Data lineage can help in identifying the source tables of PVO. Thanks,…
-
Connection to Alteryx Data Source
We are an Oracle Fusion customer. We are deploying FDI. Some of our data comes from non Fusion sources. One such source is a consolidation of the invoices from all of our customers. It arrives to us as an Alteryx Extract. As there is no connector to an Alteryx Data Source, we have to move the data into portable format to…
-
Generate Data Upload Profile from sample of data
We are deploying Oracle Fusion with FDI. Some of our data is sourced outside of Fusion. We have started using SFTP as a data source. In FDI We have to create a spreadsheet of the metadata and locate it in a folder with the same name as the table to be created. In the data workshop in Oracle Apex, the system sample's the…
-
File loading in FDI using SFTP Connector
Currently, only one file can be loaded using single data augmentation in FDI with the SFTP Connector. However, in real-time scenarios for initial loads, it is possible to have multiple files of the same structure. Therefore, it should be possible to load these files using the same data augmentation, which is not currently…
-
Audit Framework for Data Load from SFTP
We are using SFTP data source. When the data is loaded, there is no log of any failures, As an data steward I should be able to verify that all the rows in my source files have loaded into the target database table. I should be able to see the reason for rejection. I should be able to run the data load in verification mode…
-
Automating agents
Need a solution to 2 problems: 1. In which table in Database is the agents information (last run time, next run time, successful/failed, etc.) stored? 2. We are required to disable the agent after first successful run for the day(condition=TRUE). Then it has to be automatically enabled later on next day. Please let us know…
-
Dual UOM feature in SCM Analytics
Fusion SCM has a feature for Dual UOM use. For PO line, it can have different UOMs and their corresponding quantity values. In such scenarios, the 1st UOM and Quantity columns will be for shipping/delivery usage, while the 2nd UOM and its corresponding quantity are used for payment. This dual UOM feature was implemented in…
-
Incremental and Full load Timings
Hi Team, I want to refresh my warehouse after each 4 hours and to achieve that I tried to check the Full load and Incremental load timings & Processed rows count etc details but i am not able to find those for FDI. I have already checked the Common Subject Area and the DW_WH_REFRESH_SUMMARY table, It's not holding the Job…
-
Moved: Need guidance on Security setup for ADW
This discussion has been moved.
-
Consolidated Validity / Integrity Reporting
As a systems administrator, I should be able to confirm that all of the validation report have run in the previous night and that no validation issues have been reported. I should be able to see this on a single report. If a validation issue is reported, I should be able to review the validation status of the previous day,…
-
Need PVO for fusion table PER_ALLOCATED_TASKS
This is a base table that we believe should exist as a table extract PVO. Current method to extract using BIP is limited given the number of transactions that requires partitioning of data and is not sustainable if a full extraction is required.
-
Security View of Drill Down Reports
Recently we are rolling out the security to our organization and are testing views right now with the end user. For our last test we were trying to see if we can have the drill down reports in a separate folder that can be only accessed through data actions and not through a folder via the catalog. Whenever I removed the…
-
Fixed Asset Employee Name and Employee Number missing from ERP Offering
We implemented ERP offering in FDI and are looking for a subject area that contains the Employee Name and Employee Number fields in FDI. Upon checking, we found these columns as part of ERP->Data Lineage Documentations as part of "Financials - Assets Transactions” and "Financials - Assets Analysis” subject area. ie. SELECT…
-
Profile Item being created for an Employee while accessing for the first time
The Oracle Profile Management Team has updated that a profile item is automatically generated for the Career Preference and Work Preference sections when accessed for the first time in DB. Subsequently, the same record requires editing as per the FA design. This intended behavior in FA is affecting the FAW dashboard by…
-
Add DW_WRKFRC_ASG_F.PAY_SYSTEM_STATUS to the HCM subject areas
The ADW table DW_WRKFRC_ASG_F already has this column (PAY_SYSTEM_STATUS) but it cannot be added to the semantic model. The "Add column" semantic model action does not include this column, We opened a SR and found out that it is not part of the RPD physical layer and this requires an enhancement request/idea lab. This…
-
Support Segments in GL Chart of Accounts which are based on Fusion Table-validated Value set
Account: NOVAMEDIA B.V. As per, GL Segment Value of GL Account Shows ~No Value~ If That Segment Value Is Based on a Table-Validated Value Set “If the segment value of Chart of Account is based on a table validated value set, then the Value, Name, and description attributes of that GL Segment show ~No Value~ instead of the…
-
Audit capabilities to track who made changes to reports in FAW/FDI
Currently in FDI system there are no audit capabilities to track who made changes to reports, although we can see the last modified by manually checking the properties of the report. The requirement is to run an audit report which should provide information about list of users who has modified the reports.
-
Subject Area for absence records, case and absence documents
Organization Name Bolton Council Description Absences of absence records, absence cases and associated documents to be available in a subject area to allow us to build a report that would show a complete picture of an absence or multiple absences for a given employee. This would prevent the current maintenance stand alone…
-
FAW Ability to change the date the tenure band uses for calculations(E.g. enterprise seniority date)
We're getting feedback from customers who want the flexibility to change the date the tenure band uses for calculations. Most prefer using the enterprise seniority date for anniversaries and other purposes. Could we enable a feature that lets customers set this date based on their preference? It would greatly improve their…
-
Manager Email Address Column Required in FAW Talent Acquisition and Workforce Core Subject Area
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): MAYO Description (Required):Manager Email Address Column Required in FAW Talent Acquisition and Workforce Core Subject Area Use Case and Business Need (Required): Manager Email Address Column…
-
Governing Fusion Analytics Warehouse Security based on Fusion HCM AORs assignment
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): FTV Business Services LLC (FTV Business Services LLC) Description (Required): Fortive has created security based on AORs in the HCM fusion environment and it needs to be passed from HCM Fusion…
-
Add GL Segment and PO Line Description to the Subject Area Procurement - Receipt Accounting
As a Financial and Procurement analyst I will be able to report and analyze on the the Receipt Accounting transactions (incl. PO Line description) at several levels of the GL Segments Hierarchy. In the current version of the Subject Area Procurement - Receipt Accounting the GL Segments are not available. The PO Line…
-
Add GL Segments to the Subject Area SCM - Cost Accounting
As a Financial and SCM analyst I will be able to report and analyze on the value of the inflow and outflow transactions of Inventory at several levels of the Item Hierarchy and GL Segment Hierarchy. In the current version of the Subject Area SCM - Cost Accounting the GL Segments are not available. Ans in Configurable…
-
Trailing Year, Quarter, and Period Numbers in HCM
Trailing year numbers are a great way of making reports dynamic. PPM and ERP both have their own versions of Trailing Year Numbers, it would be very handy if HCM subject areas had the same. Organization: Baylor University
-
Average Time To Fill metric for Recruiting Subject Areas - Target: 20C
Description There is no way to accurately determine the time it takes to fill or complete the job requisition lifecycle. Only metric available is Average Time since creation (which grows daily as the end date is current date) At 20A - Recruiters were given the ability to put a job requisition into suspension. This should…
-
Talent review template name column subject area for otbi
Hi, We are in need of assistance to locate the OTBI subject area for the following columns: Talent Review Template name Selected Population Employee Name Selected Population Employee Job Your help in finding the corresponding columns and OTBI subject area would be greatly appreciated. Thank you for your support.
-
Create One Single Login Screen for FDI
Currently when logging into FDI we have to go through two separate login screens to access the application. The first screen is for IDCS login and the second is for Oracle Cloud applications cloud sign in to access SSO. We would like to combine the two screens to create one single Login screen where both users with and…
