-
How to retrigger the payment process request for users in cases of failure due to connection issues
Requesting for a step-by-step process on how to retrigger the payment process request for users in cases of failure due to connection issues. e.g. The Payment file was not sent to the bank due to a down servers/inaccessible servers.
-
OTBI equivalent subject area in FAW
In FAW not able to identify equivalent subject area for OTBI : a) Budgetary Control b) Projects - Grant Management - Award Funding Real Time I have 2 queries with respect to same 1) These SA exist in FAW if so what is equivalent name in FAW 2) If we need to create to create reports on these subject area in FAW how we can…
-
Metrics report for Career Site traffic
Is there a possibility to create a report for monitoring traffic on the external career site, i.e., the people who are visiting the site but noy applying for any jobs?
-
Voluntary Retention field in FAW
Hi, I was just wondering what the calculation was for the Voluntary Retention field in FAW. It can be found under HCM - Workforce Core → Workforce Headcount Facts → Facts - Workforce Headcount. The description says "Percentage of voluntary retention of workers". In one of the Oracle provided reports, Team Effectiveness,…
-
Is there a way to get payroll_id/payroll_name associated with an employee in FAW?
I can see the setup table: dw_pay_payroll_d in FAW having payroll_id, payroll_name. But, how do we link it with person table: dw_person_d or assignment table: dw_wrkfrc_asg_f. Please suggest.
-
Linking a requisition_id to a checklist task
Candidate A has applied for Requisition A, Requisition B and Requisition C. They have been offered the job for Requisition A and been unsuccessful/still going through the recruitment process on the others. As part of the onboarding process, the candidate needs to complete a reference form, which is configured as a…
-
How to fetch the line level attachment description present as attachment text?
Using this query I am getting the attachment text: SELECT * FROM FND_DOCUMENTS_TL WHERE DESCRIPTION LIKE '%Esti%' ORDER BY CREATION_DATE DESC Now, what will the joining condition to get the details at invoice level.
-
Add Pay Group using data augmentation.
We are trying to bring the field of Pay Group through data augmentation. Can you guide me to select the source tables (see attached screenshot)? Thanks.
-
OAC Reports in Fusion-SCM Screen
Hi, We created the reports in OAC, end user want to see those reports from the Fusion SCM (Procurement)screen only. How can we achieve this.
-
This dashboard helps Procurement Managers to understand why some requisitions remain incomplete.
It displays the following information: - Count of Unfulfilled Requisition Lines - Amount of Unfulfilled Requisition -- by Requisition Business Unit -- by Purchasing Category -- by Supplier Name -- by Fiscal Year & Requisition Business Unit - Ratio of Unfulfilled Requisition Amounts - Unprocessed Average Aging Days
-
Create a new branch not enabled
Hello guys, I was wondering how it's possible to activate the create a new branch button in production environment? I'm not able to create a new subject area because the button is not active, I'm an administrator of the tool. Thanks for the support. Regards.
-
Data Variance in Configurable Account Analysis
Has anyone seen data variances in Account Analysis? I am attempting to reconcile my Configurable Account Analysis to my GL Balances and Detail transaction subject area. I continue to see variances at a high level and detail level when comparing the debits/credits. The only Subledger I am extending is Payables and that is…
-
Enabling FDI Procurement subject areas under "SCM option" when the Fusion instance only has ERP
If somebody enables Procurement from Fusion ERP side and we enable it from FAW SCM side (not FAW ERP), will procurement subject areas work?
-
FDI (FAW) Frequent Refresh feature appears twice
The option appears 2 times. do we have to enable both?
-
FDI: Filter Expression using Current User
I have the need to write a filter expression to identify the current user logged in. E.g. Email = 'Current User' Is this possible in FDI? Thanks Scott
-
How to average for a Radar Chart when using Category in FDI?
I have a dataset which consist of 6 Factors and each factor has 2 questions, the dataset will vary on how many rows for Reviewees E.g. Sometimes there will be 2 team members respond and sometimes there will 6 team members. I have written a Calculation which is SUM of Response Rating / COUNT of Response Rating (excluding…
-
How to get UNION_ID for an employee in FAW? It is not present in assignment table:dw_wrkfrc_asg_f.
Is there a way to bring UNION_ID for an employee in FAW? Not able to find a suitable PVO to bring the value through data augmentation. Please suggest.
-
Dashboard enables Procurement Managers to analyse requisitions processed under their responibilities
It displays the following information: - Count of requisitions - Amount of requisitions -- by Buyer & Fiscal Year -- by Supplier Site Country -- by Business Unit -- by Fiscal Year -- by Supplier Name & Requisition count - Fulfilled Requisition Amount - Fulfilled Cycle Time Days
-
Is there a cost report which end user can query for FAW infrastructure costs?
Is there a cost report which end user can query for FAW infrastructure costs in OCI or maybe through another way?
-
Does assigning the Procurement Manager Group in FAW consume a license in ERP?
We would like the user to view the FAW Procurement Reports and have assigned them FAW ERP Consumer. We want to assign them the Procurement Manager role so they can view the correct data however we do not want this to grant them the access in Fusion Apps as this will consume an ERP user. Will assigning the group give the…
-
Average Age Band By YOY
Hi All, We have a requirement to develop the average age band in percentage by YOY and we are using below formula and it not working as expected, Please help me if you have received similar requirement in OAC. Please refer the attached screenshot( by default it showing 100%) CASE WHEN "HCM - Workforce Core"."Facts -…
-
Column Width Lock
Trying to align multiple tables within a canvas, can manually adjust column width when building. Once any filter is applied the column width automatically adjusts to fit new values. Is there an ability to lock column width on tables?
-
"Find Partners" tool to help you research the right FDI partner for your implementation
The OA team has put together a public page/tool for users and companies to learn more about our top implementation partners for OA products and services. The "Find Partners" tool hosted in the community site can provide some guidance on product and geographic implementation coverage if you're looking for a partner that can…
-
max aggregate returning multiple rows
Hello I work in a Windows environment and I am using Oracle HCM Analysis tool to alter a benefits report to only show the latest benefit by date. I am using the 'Benefits - Enrollment Real Time' subject area. The report is to display the information per employee. The problem is I use the max function to try and restrict…
-
max aggregate function returning multiple rows when used in Analysis tool
Hello I work in a Windows environment and I am using Oracle HCM Analysis tool to alter a benefits report to only show the latest benefit by date. I am using the 'Benefits - Enrollment Real Time' subject area. The report is to display the information per employee. The problem is I use the max function to try and restrict…
-
NEW! Oracle Fusion Data Intelligence Product Roadmap Q1-2024
The new Oracle Fusion Data Intelligence Product Roadmap is available to download: https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps
-
Subject area which can be used to display the approval chain of Requisitions
Summary Subject area which can be used to display the approval chain of Requisitions Content Hi, We have a requirement where we need to display the requisitions which are in pending approval, immediate approver with whom the approval is pending and who is the next approver? Is there a subject area which we can use to build…
-
FAW: Can we perform Period Rolling on Ago functions (nested query)
Hi, We have a requirement to find Retention rate in HCM Analytics for a client. we have build up the logic for the same but for creating the necessary calculation we require to perform period rolling (summation of 12Months Value) on ago function (here value refers to previous 2Y) in Oracle Analytics Cloud Data…
-
Update FAW Notification Email within OCI
Has anyone ever received this error when attempting to update the email associated with the FAW Instance? Error Codes: The following tag namespaces / keys are not authorized or not found: 'oracle-tags' Code: RelatedResourceNotAuthorizedOrNotFound
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data in BICC
