Reports
Discussion List
-
Change column to NumericSummary I want to change a column to numeric so I can add formulas. How would I do so in the SQL?Code Snippet SELECT "Workforce Management - Worker Assignment Real Time"…User_2025-02-06-07-21-22-662 29 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 38 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…ndryden 58 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ…pooja yelsangikar-Oracle 158 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After …
-
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.…Valerio Curzi 38 views 5 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Canadian Payslip modificationSummary Need to determine the path in the catalog for the payslip as well as how to make a modificationContent With the COVID-19 issue, we have had to add new pay elemen…User_2025-02-04-08-51-08-912 22 views 5 comments 2 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Resume an automated Job - after PAUSINGSummary Resume an automated Job - after PAUSINGContent Resume an automated Job - after PAUSING results in: 1. immediate submission of the job 2. And also runs for all th…User_2025-02-05-22-13-16-277 144 views 1 comment 0 points Most recent by User_2025-02-05-22-13-16-277 Reporting and Analytics for HCM
-
OTBI - Line Manager cannot report on future dated joinersSummary Line Manager cannot report on future dated joinersContent We have a requirement for Line Managers to see future dated joiners and internal movers. We are using t…User_2025-02-05-05-26-04-705 58 views 12 comments 0 points Most recent by User_2025-02-05-05-26-04-705 Reporting and Analytics for HCM
-
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 33 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to lookup the position name of an employee from another analysisContent I am creating an analysis for Development goals and since it's tied to the home/primary assignment I am trying to populate the position name and department name …Mario B 16 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFSeSummary OTBI Analysis is running out with above error after 20B upgradeContent Hi All, One of the Analysis which is having below subject areas is running out in error (c…
-
Calendar event - Holiday ListSummary Calendar event - Holiday ListContent Team, Is there a way to fetch holiday list from Manage calendar event on country wise basis using OTBI report ? (Without usi…acmhari 87 views 2 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to Hide Prompt Section in Dashboard OutputSummary How to Hide Prompt Section in Dashboard Output While printing it.Content Is there a way to hide the Prompt from the Dashboard when we print the Dashboard output …Jagdish Varadraj 134 views 4 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM -
PDF Output properties in BI publisher ReportContent Hi, Is there any option to make the PDF output of the BI publisher report fit to the page? Regards, Nivya -
Editable checkbox in BIP ReportSummary Need a checkbox in report where users can check/uncheckContent Hello - We have a requirement where the BIP report should display checkboxes with options and the … -
What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_sSummary What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_soainfra.WFTASK?Content Can someone explain the relationship b…GTS Narayanen 1.6K views 7 comments 0 points Most recent by Murugesu.V Reporting and Analytics for HCM
-
Editing a copy of a report is affecting the original oneSummary Editing a copy of a report is affecting the original one.Content Hi all, Don't know how simple might be this question, but i've made a copy of a report to edit i…Pedro Teixeira 34 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Holiday Calendar - Subject AreaSummary Holiday Calendar - Subject AreaContent Hi Team, Can anyone know how to pull public Holiday calendar in OTBI report. Please share if we have any subject area for …User_4VVG2 38 views 2 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM
-
How do you find the url link of an analysisContent I am trying to direct link in a document to the url of an analysis but I can't seem to find out how to find the analysis url in HCM.Mario B 48 views 4 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM
-
CSV Format Report is not populating fileSummary CSV Format Report is not populating fileContent Hi Friends, I have created BIP Report and selected CSV format ( Tab delimited) when I run report I do see report …User_2025-02-07-19-03-14-525 38 views 8 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM
-
Personal Payment details - cannot include Person NumberSummary Target Bank Details report returning limited results when person number is includedContent Hi, I'm running a very basic query in OTBI to show the Target Bank Det…
-
Some employees are not listed in the Salary report created from "Compensation - Salary Details RealSummary The salary report is created from "Compensation - Salary Details Real Time" subject area and it does not have any filters that restrict employee information from… -
Running the delivered "Payroll Balance Report" for inactive/terminated employeesSummary Running the delivered "Payroll Balance Report" for inactive/terminated employeesContent Is it possible to run the Payroll Balance Report for inactive or terminat…Andrew_Schmitz 76 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Compare Employee Status to Last Week in OTBISummary Want to be able to show only employees with a change in status in OTBIContent Hi, I am trying to create a report that only shows me employees who have had a chan…tiffnyc 27 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Remove Borders from DashboardSummary How to remove Table border from Dashboard using OTBI analysisContent How to remove the border lines for table layout in Dashboard using OTBI analysis, i tried th…Jagdish Varadraj 30 views 6 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM
-
Bursting & Agents - Email Encryption, Password Protection etc.Content Hello Community, Is there any HCM security feature such as email encrpyption and password protection of xls file in case we want to send any sensitive informatio… -
Feedback on Useful Seeded Manager Dashboards or Reports AvailableSummary Keen to learn from others of some basic reports that might be useful for managers to self-serveContent Cornwall Council went live with Oracle HCM, for HR and Pay…Abby Cockings 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Join Transaction Data with Assignment DataSummary How do I find hire transaction completion dates for certain assignment categories?Content Hello - I am trying to create an analysis in OTBI that compares the dat…User_2025-02-08-04-27-03-855 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Performance Document data odd in analysisContent When creating any simple analysis to find out the status of the performance document assigned to employees for some reason the analysis shows blank for the perfo…