-
Non-Suppliers with Payment Requests are being excluded when Supplier attribute is added.
FAW Enhancement Request Details - The issue is that when there is no supplier ID the inner join is eliminating necessary data regardless of there being a supplier or not. Customer looking for data where ID is null (supplier). - Summary : Planning to include Null values in the Reporting. We are in the process of requesting…
-
Increase log retention period to 30 Days.
We have extensive reports developed in FAW and due to our size of data, reports fail or timeout. But we cannot compare the logs to find out how long a reports were taking a month ago. After an issue is logged by the business, analysis and triage takes more than 2 or 3 weeks and we are not able to really find the root cause…
-
Need to customize Seeded Data Model
Hey, Currently there is a requirement to customize the seeded 'Asset Cost and Reserve Report'. We can achieve this customization by simple addition of 2 fields to the seeded DataModel but since the DataModel uses packages, triggers and flexfields I am unable to replicate the DM and add the needed fields to it. Instead I…
-
Adding PO Change History Information to either Procurement - PO or Configurable Acct Analysis
Currently in FAW, there is no ability to track when a Purchase Order (PO) gets changed in the system. We would like to the Change Order on the PO and the amount change. In FAW, there's way to add this information in via the Semantic Model Extension nor Data Augmentation.
-
Ability to generate Explain Plan for queries using out of the box FAW or data augmentation tables
We are not able to generate Explain Plan for queries using out of the box FAW or data augmentation tables, it says insufficient privileges. This makes it difficult to troubleshoot performance issues of SQLs using these tables. There are no issues in generating explain plan if query uses only custom tables.
-
BICC Extract PVO
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): Need PVOs to extract fields for the below mentioned tables : PJB_BILING_CONTROLS PJF_RATE_OVERRIDES Use Case and Business Need (Required): Business needs to…
-
Need PVO for fusion table RCV_TRANSACTIONS
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.
-
Approval history needed for Expense , AP , AR ,PO modules
Tried to build FAW reports with approval history , but approval information is not there for any of the module.Hence requesting to add approval related subjet areas for all modules
-
Need deep link for Manage Project Costs
We have built a very nice project budget and cost report, but we would like the costs to be drillable into the Manage Project costs screen via a deep link. Based on my research and posts on CCC that is not currently possible. See this and this. It appears that while there is a way to link to the manage project costs page,…
-
FAW: to replicate a filter from Oracle BI Answer that use ‘contains any’ operator into OAC
Hi, we have this version FAW 23.R4. Customer has old system using /analytics prompts and analysis. When the prompt is passed it is filtering the data that contains clob or bclob data . In classic home this is based on contain any fitler with presentation variables. Customer migrated to faw and using oac dv and using…
-
FAW comment functionality : a good beginning but we need more (column of free text, export...)
We are aware of the current FAW functionality that allows us to add a small text section outside of the workbook and to link this commentary to any line of the workbook, it is a good beginning but a limited functionality : the comment can not be exported, and when the workbook evolves, comments encounter difficulties to…
-
Integrate Narrative Reporting and/or Commentary Fields to FAW Dashboards
Goal is to use FAW dashboards for executive review meetings, which requires integration with the Narrative Reporting application and/or commentary sections. I do not see this on the FAW roadmap, but it would be great to see if this is part of the intended usage in the near future.
-
Feature to review Request History for Incremental loads
Currently the Request History shows only Full Load history. Similar to that it will be great to have the Request History populated for Incremental loads as well. It will give the customer to monitor the status of the incremental loads. Also provide customer to take proactive action by alerting appropriate team if there is…
-
there is no extract pvo available to get the PartyPEOPartyName field, can you please add it?
we are currently grabbing the sponsor’s name from the PartyPEOPartyName column in the FscmTopModelAM_GmsSetupAM_SponsorPVO, that column is not however in FscmTopModelAM.PrjExtractAM.GmsBiccExtractAM.AwardPersonnelExtractPVO and we are looking for an extract pvo that would contain it so we can join to it and pull that data.…
-
Moved: Report to identify terminated employees in Oracle workflow
This discussion has been moved.
-
Increase the data capacity/volume for Data Validation
Currently Internal Operations advised to use a shorter time period/date range to make different subject areas work (complete) in Common - Data Validation. This will not only make things hard to validate but keeping track of what filters are being used. Their is no visibility or insight to know this in the Common - Data…
-
Lineage between FA and FAW
It would be great to have a lineage between FA and FAW. We need the list of view objects used by the FAW Data pipelines in populating the FAW tables. This will help us in investigation if there is any data issue and also if we want to extend the FAW data model. For example, I am looking for the view object source for FAW…
-
FAW -Full Reload Schedule – Option to Choose Time
Use case: Create accounting completes at 12:30 am. Any back dated payments applied against invoices are all accounted and full load get the correct updated statuses. Request: FAW to provide an option to kick start the full load on specific time. Currently it takes default pipelines settings time.
-
FAW Schedule Refresh – Functional Area level
Use cases: Cost Processer completes at 2:30 AM PST. Need to get latest cost data to Data warehouse. Request: Enable Schedule option at all Functional areas level on specific time in a day/week/month Note: There are very few functional areas are currently enabled for frequent refresh
-
Moved: Journal Batch/Header Identifier Mismatch in Warehouse Values to Actual Source Values
This discussion has been moved.
-
New flag field which uses the Federal Ethnicity code to classify race and ethnicity categories
This new attribute would follow the IPEDS standard reporting guidelines to condense and clarify race and ethnicity data. If an individual selects 'I am Hispanic or Latino' then 'Hispanic' shows up in this field no matter what else is marked off. If an individual selects more than one race then 'Two or more races' is what…
-
FAW Schedule Refresh - Applications level
Use cases: Our FA – Create accounting program completes at 12:30 AM PST. Need to get latest accounted data to Datawarehouse. Cost Processer completes at 2:30 AM PST. Need to get latest cost data to Datawarehouse. Request: FAW should have an option at application level to schedule ERP (Finance) /SCM application Loads to…
-
FAW Service Administrator VIEW only access Customer Role.
Hi Team, One of the customer is looking for below as per their business need. "FAW Service Administrator" view only access group that gives to access users and their groups. We would like to create a group that gives view only access to the functionality of "FAW Service Administrator". Customer : DePaul University Regards,…
-
Archiving transactions from Friday of a previous week that correspond to Monday
Social Security Archiver - The law says the hires can be reported -1 working days In the Social Security File only future hiring movements appear one calendar day later, however, the law establishes that they must be working days. In Mexico, Article 715 of the Federal Labor Law confirms that "Working days are all days of…
-
Moved: Make Serial Number DFF's available in OTBI
This discussion has been moved.
-
Requesting an enhancement on Full Reload Warehouse completion confirmation on frontend FAW app
In current version we are not able to track the Full Reload Warehouse completion from FAW application frontend. This is required by the client for auditing purpose. While checking in the backend table we are able to see the functional area reload but we are not sure whether it is a full reload or an incremental reload. The…
-
Moved: CCC - How to track email in Oracle Cloud Fusion?
This discussion has been moved.
-
In FAW being able to export Table visual to Excel format (.xlsx)
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): KPN B.V. Description (Required): At the moment there is only PDF and CSV export possibility in FAW. We want additional option: export to Excel. Use Case and Business Need (Required): Excel is…
-
Custom BICC PVO Creation in Fusion
Need the flexibility of creating Custom PVOs for the tables which the standard PVOs are not available. Business wants these in order to extract fields through BICC to help with the data extraction.
-
Sort FAW Subject Area folders/facts in alphabetical order
It would be much better visually and more natural to operate FAW Subject Area folders, and facts in the folder, sorted by name. Order By may be permanently embedder into Subject Area or somehow added to UI, e.g. be a part of left "Data" pane functionality, right click on the folder, pop-up asking to sort…
