Reports
Discussion List
-
I need a query which will fetch Percentage of turnover of top performing employeesSummary: I need a query which will fetch Percentage of turnover of top performing employees Content (please ensure you mask any confidential information): Version (inclu… -
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
Report for Qualification EntitlementsSummary: Hi, we have a requirement to create a report for the Qualification Entitlement details of employees. We have checked OTBI and BIP (both ANC_PER_ABS_QUAL_ENTL an…
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a… -
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I pull an open requisition report that lists each Req's AOR representative?Summary: We would like to pull a report of open requisitions that includes a column listing the req's AOR Representative of a particular type. Content (please ensure you…Cheryl Burwell 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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.5K 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 13 views 3 comments 0 points Most recent by Rini_Varghese-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 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 23 views 4 comments 0 points Most recent by Ashish_Sahoo_Trinet26624 Reporting and Analytics for HCM
-
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 61 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.1K views 5 comments 9 points Most recent by User_FCP05 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 …
-
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…Amol Patil HCM-Oracle 773 views 18 comments 0 points Most recent by Mr H 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…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 240 views 7 comments 0 points Most recent by Bisweswar Goud-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 69 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 …
-
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 210 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 11 views 3 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM
-
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Time card approval history tables in Oracle HCM CloudWhat are the table names that store approval information for Time and Labor? Looking for timecard approvers names, dates and times as well as the status of the timecard.
-
How to fetch a BIP based extract to source Approver1, Approver2 details based on Transaction SummaryThe management has requested for Approver1 and Approver2 details for all the transactions for Process name "Approve Job Requisition" within Oracle fusion. We could not f…Aashish Choyal 21 views 5 comments 0 points Most recent by Aashish Choyal Reporting and Analytics for HCM
-
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does…
-
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font … -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 54 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM