Reports
Discussion List
-
I am trying to get te work schedules of the inactive employees via analysis reportSummary: Work Schedules - if employees are inactive, their work schedules are missing from the analysis Content (please ensure you mask any confidential information): We…Claudia Linares L 26 views 4 comments 0 points Most recent by David Vaughan-Watkins Reporting and Analytics for HCM -
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu… -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 8 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Unable to Add Home or Work Address for Internal Employee in Offer Letter TemplateHi, We are currently unable to include the Home Address or Work Address of internal employees when generating the offer letter using our offer letter template in Oracle …Narendra N 38 views 4 comments 0 points Most recent by Mohammed Hussain Reporting and Analytics for HCM
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 14.7K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 706 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…Opkey PA 3 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Recruiting, Opportunity Marketplace
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…CB Trett 256 views 12 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…Eric Geddes 452 views 6 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.7K views 21 comments 3 points Most recent by Raymund J Reporting and Analytics for HCM -
COUNT function in e-Text Template in BI Publisher with HCM extractSummary COUNT function in e-Text Template in BI Publisher with HCM extractContent I used count function in e-text template ,the count function returns no data, any thing…G Madatala 417 views 8 comments 0 points Most recent by Anupam Rana-Oracle Reporting and Analytics for HCM
-
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one …Elavarasan S 24 views 8 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 3 views 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 261 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 8 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 14 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 92 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …bwdata 70 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 4 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 18 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…Jeevan Loyal 46 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …Vishal Purohit 33 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
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…
-
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio…