Category 81
Discussion List
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.4K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM -
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 12 views 3 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM -
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data …supriya kadam 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
we have 3 level for performance goal categorySummary: Hi we have 3 level for performance goal category for employee need to validate sum of weights for each category not great than specific value form UDT, goal ent…Mohammed Alharbi 11 views 3 comments 0 points Most recent by Mohammed Alharbi Performance Management -
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …Nicole A. 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report to pull BPFM hierarchySummary: Could you please help in pulling the BPFM Hierarchy using OTBI Content (please ensure you mask any confidential information): Version (include the version you a…Nagarani M 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we create a dashboard using cards?Summary: Is it possible to create a visual dashboard within Oracle HCM to display key HR metrics such as headcount, billable vs. non-billable employees, attrition trends…Smruti Samruddha 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Report on if employee has viewed / downloaded DOR?Summary: Hi team, We have recently been asked if we can report on if an employee has viewed / downloaded a specific DOR and/or its attachment? I am unsure on whether or …Luke.Findex 22 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 25 views 4 comments 0 points Most recent by Ashish_Sahoo_Trinet26624 Reporting and Analytics for HCM
-
Can we set BPM expiration date for Absence Approval Tasks per absence type?Summary: In 24D, there is a new function in Absence Management called "Action on BPM Transaction Expiry," where we can configure each absence type to automatically appro…Shannon Teves 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Emergency contact OTBI analysisHi Guys i am trying to create an OTBI to show employees with emergency contacts and the contact details of them too. I have tried using the subject area 'Workforce Manag…Jeevan Loyal 11 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
Is there possibility to disable Things to Finish tile on homepage of Oracle Fusion RedwoodSummary: want to check possibility to disable Things to Finish tile which came with update on Redwood theme on homepage of Oracle Fusion for specific user. We want to di…
-
OTBI Report on Seniority Rule ValuesSummary: Can we report on the values associated with a given seniority date rule using OTBI? Content (please ensure you mask any confidential information): I'd like to c…Monique 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sign On Bonus Effective Date ReportWe have a OTBI Sign On Bonus report that runs based on hire date. I'm looking to update this report to pull based on Sign On Bonus Effective date instead. However, when …Nicole A. 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only …
-
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…TC 66 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
How can I change the default aggregation rule (such as sum) in the Default Aggregation Rule settingSummary: I need to change the default (sum) through default simple without sum and it isn't working in OTBI using the Worker Assignment Event Real Time SA. Thanks Conten…ClaudiaManea 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo…Barile Alberto 64 views 2 comments 0 points Most recent by Francisco Barrios Reporting and Analytics for HCM
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP CloudSummary: Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud Content (please ensure you mask any confidential information): I wo…
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Inaccessible columnSummary: This report is to fetch the personal contribution of an user. It is working file for everyone but one user. She is getting an error which is attached. I have tr…
-
Employees Missing in Compensation – Salary Details Real Time when using Matrix Manager FieldsSummary: Using Compensation – Salary Details Real Time , I’m experiencing an issue where employees drop from the report when matrix manager fields are added. For example…Mike Wulf 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 53 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …