-
Delete OAC csv file before rerunning a flow/Sequence
Hi, I've been experiencing some issues with OAC and twice now, I had to delete the output .csv file generated by a flow before rerunning this flow to be able to have the right data. I'm trying to find any documentation/SR/topic related to this issue (the first time we experienced that was in august 2024). Could anyone…
-
Can report viewers (not authors) save a report in My Folders?
Can report viewers (not authors) who have read-only access to a report save the report in My Folders without the FDI admin have to perform an export and import?
-
EXCEEDS CONFIGURED MAXIMUM NUMBER OF ALLOWED OUTPUT ROWS
IHAC who is facing out error as " Exceeded configured maximum number of allowed output rows" and the i try to reproduce the issue is , report is using the Table view with Title and Narrative View, If i remove the Narrative view this error will go off. So i just want to know this is OAC classic home report which is packaged…
-
Can't move workbook to Shared folder. Can't create folder in Shared Folder
I am a member of the FAW Service Administrator, FAW Security Administrator, FAW Functional Administrator, and FAW Modeler Administrator Groups and I am an Administrator on the Fusion side however when I try to save or move a workbook to the Shared Folder it says I am not allowed. I also cannot create a folder inside of the…
-
FDI: How to hide/restrict access to "Oracle" folder under Catalog > Shared folder.
Hello We want to hide/restrict access to the "Oracle" folder in Oracle Analytics Cloud under Catalog https://us.v-cdn.net/6037859/uploads/R2NFQYHN08IB/oracle-folder-access-screenshots.docx > Shared Folder provided by oracle as standard folder after implementation. Provide us steps to hide/restrict access to users to Oracle…
-
Single Select Filter in Oracle Fusion Data Intelligence
Hi everyone, I noticed that Oracle Fusion Data Intelligence currently does not support a single select filter. Does anyone know a way to implement a standard single select filter (where the user can only select one value, e.g., one year, and needs to deselect before choosing another) or if Oracle plans to add this feature…
-
Internal FDI table for user-role assignment
Is there an FDI table with the details of user to licensed role mapping? (e.g. HCM Consumer) We found dw_user_role_data_asgnmnts_d but this only shows roles related to security assignments
-
Custom Oracle Analytics Security
We have custom ERP roles that successfully mapped to Oracle Analytics. We have also gone through and added the mapping to the custom roles that were created in Oracle Analytics. We have confirmed that our custom roles in Oracle Analytics have the appropriate data duty security roles mapped. However, zero of the Business…
-
How to subscribe to a specific workbook canvas?
Hello, I am struggling to subscribe to a specific workbook canvas and hopefully anyone can help. I want to receive through email the snapshot view of a certain canvas.
-
How to enable AI Assistant feature
Hello, I've imported new spreadsheet and created new dataset and now I'm trying to use AI Assistant in FDI, but I'm receiving this message. Is there a documentation in order to enable it? In that particular instance I also don't have access to Administration console for Fusion Data Intelligence Thank you in advance! "The…
-
FDI HCM Security - AoR still requires Augmentation?
For AoR Security, according to this blog post: https://blogs.oracle.com/analytics/post/faw-hcm-data-security-using-dept-hier-aor-attribute There are 2 augmentations required to bring additional data for AoR Department Hierarchy Security: CrmAnalyticsAM.PartiesAnalyticsAM.FndTreeVersionVO…
-
Dynamically Reference Values for the Previous Year based on User Filter Selection
Hi everyone, I am currently trying to implement a dynamic filter for a KPI card in Oracle Fusion Data Intelligence. In the below image, I have laid out an example: We have two KPI cards: “Sickness Rate (%)” – reflects the selected year from a Year filter (working as intended) “Sickness Rate Previous Year (%)” – should…
-
HCM Learning - Redundant item rating metrics
What is the difference between the "Average Learning Item Rating" and "Overall Learning Item Rating"? the calculation logic sheet shows the same formula for both. Is there a reason to pick one over the other?
-
sql query for candidate interview interviewer details
https://us.v-cdn.net/6037859/uploads/8TI3VJP42W4E/candidate-interview.sql I need the SQL query to fetch interviewer details from the interview schedule in oracle fusion recruiting I already have a query, but irc_is_schedules_b table is not storing the recent data. Attached the SQL query for the reference Can any body…
-
Change the date format to YYYY-MM-DD in BI Publisher Web Layout Editor
I am not able to change the date format to YYYY-MM-DD in BI Publisher Web Layout Editor( Currently it is showing YYYY-MM-DDTimestamp). I am getting proper backend output using the Datamodel sql query (in Format YYYY-MM-DD), but the same query in frontend report showing with timestamp.
-
Dynamic filter in FAW for Fiscal Year
Hi, I am trying to create a filter in FAW workbook that shows last 3 Fiscal Years dynamically, say FY2021, FY2022 and FY2023 and users can select/deselect the options as per their requirement. I tried to create a parameter but it only let us select one particular option as the default value whereas I want all the years to…
-
Adobe Acrobat Pdf Output Issue while downloading pdf from Report History
Able to open pdf outputs in Adobe Acrobat when i am downloading pdf from report for all the pdf's, But After Schedule from Report not able to open pdf in adobe acrobat while downloading pdf from report history only for few pdf's facing issue. Any one can you please help me
-
Is there a way to clear a database table daily before the pipeline loads?
Is there a way to clear out a database table for one of our data augmentations before running the daily pipeline load? We have a need to load in brand new data every day and we do not want to retain any cumulative records.
-
Unable to Archive BICC Files in UCM daily
Hi Team, We currently have BICC configured in our application, and daily files are being uploaded to the UCM server. The UCM server retains the last three months of BICC files. I would like to know if there is a way to archive these files daily at a specific time. Any input would be greatly appreciated. Thank you! Regards,…
-
Assistance with Costing Key Flexfields in Oracle Analytics (FDI)
Hi Experts, We are trying to export person costing details in Oracle Analytics using the HCM - Workforce Rewards - Payroll Costing subject area. However, we are unable to retrieve the Costing Key Flexfields. Could you please guide us on how to access the costing segment details in Oracle Analytics (FDI)? Please refer to…
-
How do I pull PROCESSED_FLAG from DW_REQUISITION_CF to my Requisition Subject Area in FDI
Hi Team, I have been struggling to get a simple solution to get PROCESSED_FLAG from DW_REQUISITION_CF to my Requisition Subject Area in FDI. Could you please suggest the available options? Thanks, Naga
-
ORacle Fusion BIP- financials - Unearned Amount aging calculation
In Oracle Fusion BIP, for each contract line need to implement event level bifurcation of unearned amount (Revenue amount < invoiced amount) aging calculation in FIFO sequence (here event completion date is considered) based on knock off logic. We would need event by event comparison between fully invoiced and fully…
-
user who having combined roles they cant able to see the right data. one role overtake another role.
one of the user having combination of HR Specialist view all data and Line manger. But, she only see line manager access data. I tried to create security configuration for HR Specialist and line manager after that, she can view all the data but, it affects the line manage access. Could anyone face this issue?
-
What is the minimum information necessary to update contracts
Summary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTRACTS_F.ASSIGNMENT_ID = PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_ID to get the work terms table or PER_CONTRACTS_F.ASSIGNMENT_ID =…
-
How to populate FDI with HCM data?
We have a running environment of FDI but no data on it. How to read data from HCM cloud instance? Thank you
-
Which timezone are the dates in FAW
How are the dates stored in FAW for reporting, is it fixed to UTC or are shown in local timezone? For example the Order date in Fusion is shown as per the user's timezone setting, but it is stored in UTC in the database or PVO. How is it processed in FAW, is it bought in UTC timezone or any other changes done to it?
-
FDI HCM Position Time dimension not working with date value = 11/04/2025 current date
for our position management dashboard we cout our positions by date everyday. today in production while we try to count as of 11/04/2025 the dashboard shows no data. this type of query is working for the previous dates like 10/04 or 09/04.
-
I want to show Accounts Receivable Invoice aging days by Project in FDI
I am trying to build a dashboard in FDI to show Accounts Receivable (AR) aging days and outstanding amount by project/contract etc. I am using AR Aging subject area which does not provide any information of Project or Invoice. subject area AR transactions has contracts, remaining amount and some dates but no project…
-
Making a new subject area available for reporting
We have created a new subject area in FDI. Create a branch with the appropriate steps Merge the branch into the main branch Modified the system generated security configuration so that there is a duty role assigned with read access to the subject area (we do not need row-level security on this subject area) When a user who…
-
Need to know which table stores the work summary in My maintenance work
Wanted to include the Work Order Summary column to the report ( /Supply Chain Management/Maintenance Management/Work Management/WorkOrderDetailPrintReport.xdo ) from my Maintenance Work (Red Wood). Need to know which table stores the work summary
