-
How does oracle fusion ensure the report program contains instructions to extract all the expected i
Hi Oracle, How does oracle fusion ensure the report program contains instructions to extract all the expected information? Take for example the standard report "Payables Payment register". How does Oracle ensure that the report generates the correct and complete population of payments? Please point to other posts within…
-
Workforce Profiles - Person Profile Real Time
Hi everyone, I need some assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person's profile page, e.g. Language, skills, career preference, etc. It creates multiple rows and sections for one employee in my report, Which also creates an issue in…
-
Logic to find the Next Approver Name for the resignation process
We have a requirement to build a resignation report, in that we need fetch the Current approver and Next approver. We are able to get the Current approver from the table 'fa_fusion_soainfra.WFTASK' and column 'assigneesdisplayname'. But we are not able to fetch the Next approver if the resignation process approval is…
-
Report to fetch the User's actions and time spent on Oracle HCM Pages
We need adoption report/s which should cover the below basis date range, filter criteria like BU, Dept, Location, Personas (available in AOR) User time spent on pages User actions including Workflow approvals, new, modify, delete, etc. Checking Notifications
-
New Event: Global Leaders Miami!
All, Join us for an exclusive 2-day event to interact and learn with other customers and partners by sharing implementation experiences and best practices. We will have AI, Database, and Analytics leaders joining us in Miami on the 24th and 25th of January 2024. Register here:…
-
New Event: Global Leaders Miami!
All, Join us for an exclusive 2-day event to interact and learn with other customers and partners by sharing implementation experiences and best practices. We will have AI, Database, and Analytics leaders joining us in Miami on the 24th and 25th of January 2024. Register here:…
-
New Event: Global Leaders Miami!
All, Join us for an exclusive 2-day event to interact and learn with other customers and partners by sharing implementation experiences and best practices. We will have AI, Database, and Analytics leaders joining us in Miami on the 24th and 25th of January 2024. Register here:…
-
What's New in Fusion ERP Analytics 17.1
Learn about the latest updates to Oracle Fusion ERP Analytics in the updated 17.1 release. - Project Labor Cost and Revenue Analysis - Project Contract Analysis - Project Budget Revenue Variance Analysis - And much more! Let us know which new or improved features you're most excited about below.
-
What is DBI group for grade and grade step in HCM extract ?
We have a requirement that need to pull all grade and grade step into one extract. 1) I want to know what will be the DBI group to connected between grade and grade step ? 2) Generally I am using parent group as grade and child group as grade step. 3)Even I try to link grade id from parent group and grate step rate object…
-
Is There any user entity to pull grade ladder ?
1)What is user entity to fetch grade ladder details in Hcm extract ? 2)What DBI to use to connect Grade ladder and Grade step ? Goal:Create an extract with all Grade ladder and Grade step in one extract.
-
Is there any user entity to fetch Payroll Balance details?
I am trying to fetch, balance details such as balance dimensions and balance feeds. Is there any user entity which i can use to pull the data in extract? For reference i am attaching a screenshot of the required data.
-
Analyzing Usage Tracking Data in Fusion Analytics Web
Use the attached workbook to help find slow-running queries in your Fusion Analytics Web (FAW) implementation. The workbook uses the 'Common - Usage Tracking' subject area. To run, just download the attached .dva and import it into your FAW environment. The first canvas groups queries into buckets by how long it takes them…
-
What is "Midpoint Value" in FAW map color option?
Hi All, I'm creating an analysis using world map where i want to use conditional formatting, I have created that and on tabular data conditional formatting is working as expected but I am not able to apply this formatting on map. On world map after right click getting color> manage assignments... option I can see an option…
-
If you haven’t yet completed this, you can migrate custom KPIs, Cards, and Decks whenever you want.
You can migrate custom KPIs, Cards, and Decks whenever you want. Please target end of January to streamline this lossy migration. If you haven’t yet migrated your custom content, please target the end of January for moving to the new OAC-based experiences. You can run the utility whenever you want. If you haven’t run the…
-
What to do about map visualization mixing up city locations when there are duplicate city names?
I've recently been troubleshooting this map of suppliers and requisition amounts, but have encountered an issue when there are multiple cities in the US called Malone for example. As you can see, the visual has pinpointed Malone, TX in the location of Malone, New York! A lot of these discrepancies were eliminated by adding…
-
New value isn't visible in Notification
Hi Expert, I need your help. Our requirement is to add two fields in 'Request New Position' notification, 1. 'NUMBER OF OPENINGS' and 2. 'Business Justification' field. The Number of opening is already existed in data model, So I added 'Business Justification' field in data model query. 'NUMBER OF OPENINGS' is visible on…
-
Employee signature picture in report
Hello Everyone, Can anyone tell me how I can show an employee's handwritten signature in my report? Thank you.
-
'Business Justification' Value visible in data models but not in Notification
Hi Expert, I need your help. Our requirement is to add two fields in 'Request New Position' notification, 1. 'NUMBER OF OPENINGS' and 2. 'Business Justification' field. Number of opening is already existed in datamodel, I added 'Business Justification' field in datamodel query. 'NUMBER OF OPENINGS' is visible on RTF level.…
-
FAW : Payroll : Analytics Warehouse Balance Group Configuration
Hi Experts, For Payroll analytics, I understand that customers will be required to setup Balance Group in the Cloud HCM environment and FAW pipeline will only fetch balance data as per the setup present at the balance group. Can you please let us know if there is a document explaining the steps to be performed to fetch the…
-
Filter to get the earliest date in the OTBI Analysis.
Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within my analysis. It worked with a different account but once I am using 2 subject areas, it is not reflecting correctly. I used the function MIN(Date by Account Number) --using 2 subject areas --it should be like this "Activity…
-
You must provide a valid value for the Liability Distribution attribute. (AP-810667)
Creating invoices payable is prompt:You must provide a valid value for the Liability Distribution attribute. (AP-810667), How can I solve this problem?
-
Happy holidays
The Oracle Analytics community has grown so much this year! Thank you for all your work, ideas, and innovation, and we hope you enjoy these holiday wishes from your dedicated OA team :).
-
General Guidance regarding GLOBAL_PERSON_PVO
Good morning, Our Data and Analytics team has hooked up to BICC using a FiveTran connector. The PVO they are connected to is the GLOBAL_PERSON_PVO one. They are interested in grabbing demographic information regarding our employees. This PVO however only seems to contain the latest information about each person. Is there a…
-
Move Custom Datasets from Dev to Prod
Howdy! I'm just asking a simple question on the process of moving a custom dataset between environments. I see that there is the connection button, but I am confused on the settings to set for this process to go through just to move from dev to prod. Could someone please clarify or point me to documentation that explains…
-
What all are the standard reports available in Oracle Fusion HCM?
Wanted to know when an Oracle Fusion HCM is implemented, what all are the standard Oracle Fusion HCM reports available from the product? and how do i find them in Oracle Fusion?
-
Unable to retrieve data of employee transactions
Custom otbi analysis based on Bi report where we need to get employee's current and previous department and job using subject area - HCM Transaction Administration Real Time.
-
Can Key Metrics be moved from a development to a production environment?
When moving reports between environments, the key metrics do not move and cause reports with key metrics to be riddled with errors. The only way to solve those errors is to painstakingly recreate the key metrics in a new environment which would take up a lot of unnecessary time. Is there a way to export and import key…
-
Oracle Fusion Cloud ERP - Add new Business Objects to use in OIC
Hi, I am in the process of incorporating new Business Objects into Oracle Fusion ERP with the goal of leveraging its functionality in external projects using Oracle Integration Cloud (OIC). However, after reviewing the documentation available on the Developer Connect Portal, we have been unable to find clear instructions…
-
FDIP : Creating Subject Area through FDIP
In this video we discuss how users can create subject area using locode https://videohub.oracle.com/embed/secure/iframe/entryId/1_2bjsmqd2/uiConfId/35965902
-
Fusion Analytics Locode: Exclude Function
In theis video we cover Exclude function in FAW https://videohub.oracle.com/embed/secure/iframe/entryId/1_ws76wr85/uiConfId/35965902
