Reports
Discussion List
-
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…Yaniv 122 views 6 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Overall Manager Rating Bar Graph - Display All ValuesContent We've drafted a performance related analysis from the Workforce Performance - Performance Rating Real Time subject area to capture overall manager rating distrib…User_2025-01-23-23-27-03-729 47 views 4 comments 0 points Most recent by User_2025-01-23-23-27-03-729 Reporting and Analytics for HCM -
Unable to query data in PER_ACCRUAL_PLANS_B and PER_ACCRUAL_PLANS_TL tablesContent Hi All, We entered Accrual data in the application. When we tries to query in BIP side we are not getting data from the tables (PER_ACCRUAL_PLANS_B and PER_ACCRU…Visu 32 views 4 comments 0 points Most recent by User_2025-02-04-06-33-06-582 Reporting and Analytics for HCM
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 106 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Error generating document in Excel when Exporting From OTBISummary Getting an error producing document in error in excel spread sheetContent Hi All, We have had an upgrade to OTBI over the weekend and now reports we run which is…User_2025-01-29-21-02-12-466 39 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…User_MC37Q 61 views 2 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeSummary Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeContent Hello, We are hitting an issue after last weekend 18C upgrade, while …Suresh Pallapothu 44 views 4 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
IPEDS Reporting In HCM CloudSummary Identifying requirements to support IPEDS reporting for Higher Ed ClientsContent Hello- We are implementing HCM Cloud and need to comply with with federal (highe…Ellen Usilton 49 views 2 comments 0 points Most recent by Ellen Usilton Reporting and Analytics for HCM
-
BI Publisher: Can we FTP the individual bursted emails onto the Web content serverSummary BI Publisher: Can we FTP the individual bursted emails onto the Web content serverContent HI, We are aware that we can FTP or put to Web content server, a BIP re…
-
Add MTD in Employee active payroll balance reportSummary Add MTD in Employee active payroll balance reportContent We are trying to clone the Employee active payroll balance report and make few modifications in it. Alre…User_2025-01-30-17-58-41-867 44 views 1 comment 1 point Most recent by User_2025-01-28-05-27-14-688 Reporting and Analytics for HCM
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today…Susan Anderson 51 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 356 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
OTBI - Field to show max effective_start_date by action_codeSummary In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent Hi all, While working on "Workforce Managem…Pavel Kartuz 116 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…
-
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1.1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Turnover ReportSummary Looking for help creating a turnover reportContent Hi, We have set-up turnover reports but when I checked the data the report is not pulling the correct informat…User_2025-01-30-01-37-19-048 115 views 8 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM
-
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.Azfar.128 98 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 303 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need a report to get calculation card Override details along with maximum allowence for fedral andSummary we have a requirement to pull the override rate, override amount, override suplemental rate for fedaral and state from manage calculation cardsUser_2025-02-04-07-00-18-658 90 views 4 comments 1 point Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Job Requisition Current Status FieldSummary Trying to locate this fieldContent Anyone know what subject area and folder the current job req status is stored? I'm having trouble locating it.User_2025-01-28-08-47-04-905 28 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Best option to generate HR change letters in Oracle HCM CloudSummary Our HR department would like to generate letters (on demand) for employees upon data changes in HCM Cloud such as department changes, employment changes, etc. Wh…User_2025-01-30-03-25-05-093 138 views 5 comments 0 points Most recent by User_2025-01-30-03-25-05-093 Reporting and Analytics for HCM
-
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 162 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 453 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM