Reports
Discussion List
-
Union Dues reportContent Hello, I am looking for a Union Dues report that is created in BI publisher. Please advise if anyone knows if it exists in the forum. ThanksUser_WHB5J 32 views 5 comments 0 points Most recent by User_2025-02-06-12-47-14-341 Reporting and Analytics for HCM -
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't … -
Regd tracking name change in OTBISummary Regd tracking name change in OTBIContent Hi , We have name change report where we track any changes to person name in past 7 days and display the person's detail… -
OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Summary OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Content Hi All, When we will see data in the Worker"."Previous Last Name"…User_MC37Q 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire…
-
CEO direct reportee nameSummary CEO direct reportee nameContent Hi all, We have a requirement to pull CEO direct reportee name For eg. Get the name of manager4 Employee->manager1->manager2->man…Reddykrishna Chidella-Oracle 25 views 3 comments 0 points Most recent by User_2025-02-05-06-26-19-951 Reporting and Analytics for HCM -
Zoomed Report Does Not Download to ExcelContent We have a report with several lines enabled to zoom to children. When the lines are expanded, the report will not download to Excel. With the lines collapsed, th… -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 301 views 12 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Empty spaces in RTF if there is condition not to show a sectionContent We are working on Talent Profile print and it has multiple section so we are creating an RTF template and having a condition to display section conditionally to …User_2025-02-08-10-09-54-910 356 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM -
what are the duty roles for viewing worker detailsSummary what are the duty roles for viewing worker detailsContent Hi - Already have the following duty roles added to the custom role: 1. Workforce Profile Transaction A…C.R.Balaji 53 views 4 comments 1 point Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up…CIT Shane 183 views 25 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Hide 0 data points in Line graphsSummary Is it possible to hide data that equals 0 on a line chart?Content We have a line chart with a 0 value for the latest month of actuals. Is it possible to hide thi…
-
Help BIP Report not pulling correct infoSummary We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.Content Here is the WHERE Clause with parameters. For some re…Mike Borghoff 31 views 3 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 647 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
PCMCS query generating blank fileSummary PCMCS query generating blank fileContent Hi Friends, I have created a query in PCMCS using global context to export data. However when I run the query, it shows … -
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 92 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 70 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t…
-
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…HarishVummidi 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…Bala Kasineedi 46 views 3 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 40 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
how to restrict infolet user wise?Summary how to restrict infolet user wise?Sidhartha Wadhwa 40 views 5 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ…
-
Profile Option for OTBI user settingsSummary Profile Option for OTBI user settingsContent Is there a profile option to set the default locale in OTBI? Global User settings get reset each day. It would be di…User_2025-02-05-23-02-10-916 20 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…Karishma Mungara-Oracle 92 views 5 comments 0 points Most recent by Karishma Mungara-Oracle Reporting and Analytics for ERP
-
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP