BI Publisher
Discussion List
-
Original Hire Date and Grade ReportContent Hi, I am looking to report on original hire date, grade and time in a grade. Could anybody please help on this? Thank you!MohammadAfghanul Khair 46 views 5 comments 2 points Most recent by Jessie Jones Reporting and Analytics for HCM -
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it … -
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p…
-
user unable to see reports in a folderSummary user unable to see reports in a folderContent User is not able to see reports in any folder. Even in My Folders. It is just blank. Could see only folder structur…Anuradha T 211 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
List of Succession Plan for a personContent Hi all, I am trying to get a list of all succession plan where an employee is active. Thank you!MohammadAfghanul Khair 28 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to Unarchive .xdrz filesContent Hello, We have some .xdrz files that we've found on customer connect, but receive the attached error when unarchiving them. Is it still possible to unarchive the…User_2025-01-31-00-25-12-234 45 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Server Message Block(SMB) protocol in BI ServerSummary SMB protocol to connect to Active Directory serverContent Hi All, We would like to send a CVS report from our HCM BI Server to AD server. Our AD team has asked u…Alvaro Couto 18 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM -
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 615 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
SQL query time out error in BI ReportsSummary Getting SQL query time out error in BI ReportsContent Hi Experts, We are getting SQL query time out error in BI Reports. have made changes Query Time out to 1000…User_2025-02-06-19-27-47-357 107 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Connecting Worker Assignment and Comp Salary work areasSummary Connecting Worker Assignment and Comp Salary work areasContent Hi ALL, I'm need fields from "Workforce Management - Worker Assignment Event Real Time" ."Assignme…User_2025-02-07-19-03-14-525 23 views 7 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Opening Excel Template from BISummary Opening Excel TemplateContent Hi ALL, Earlier developer in my company developed BI report using Excel Template. If I want to modify that template how can I extra…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Tips for improving performance of an AnalysesSummary Tips for improving performance of an AnalysesContent Hi, We have parameters - Person number and Learning Type, but the report takes forever to give the output. I…Manoj.Gupta 51 views 1 comment 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Splitting BI Report in multiple TabsSummary Splitting BI Report in multiple TabsContent Hi ALL, I want to split BI Report based on Person_type in Excel's 2 tabs. Employee will be in first tab and Others wi…User_2025-02-07-19-03-14-525 143 views 11 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Custome Talent Profile Printing Sections that Employees Don't Have AccessContent We have created custom Skills and Qualification Print. First we have taken a copy of delivered RTF template and a copy of delivered data model and have created a…Misbahul Khair 27 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We…Suganthi Srinivasan 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon…Mahendra 166 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fusion Table to get % compatibility on Career PlanningSummary Fusion Table to get % compatibility on Career PlanningContent Hi Gurus, Is anyone knows if there is a SQL table we can use to get the Percent compatibility under…Haydee C Mercado 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report to fetch List of Scheduled Processes in Oracle HCM CloudSummary BI Report to fetch List of Scheduled Processes in Oracle HCM CloudContent As most of us might be aware by now that we cannot accommodate custom code (pl/sql prog…AshishERPCloud 137 views 1 comment 9 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cost Center Manager SQLSummary I require the table/link for the cost center manager fieldContent Hi I am currently creating a report that requires the cost center manager field for a departmen…User_2025-02-06-00-21-58-611 54 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
BI Publisher Report not workingSummary Absence ReportContent Hi, One of our BI Publisher repots has stopped working, it hasn't been touched since last month when it successfully ran. Could it be that …User_2025-02-05-22-44-35-842 73 views 15 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Checklist Configurable Form ReportingSummary Pulling data from configurable form in checklistContent What is the best way to pull dff's that make up the configurable form within a checklist? After the 19B r…Shelly Feyerherm 370 views 7 comments 3 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 103 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
OTBI : non-Fusion data sourceSummary Adding non-Fusion data source connection is not supported and will be deprecated in a future release.Content Got this message on the Admin page for data sources.…User_2025-02-05-23-02-10-916 35 views 10 comments 1 point Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM
-
Question in the behavior of scheduled BI jobs.Summary How the scheduled BI jobs will behave during the Oracle monthly and Quarterly maintenanceContent During the Oracle monthly patch or Quarterly updates, how the sc…GTS Narayanen 28 views 2 comments 0 points Most recent by GTS Narayanen Reporting and Analytics for HCM
-
Report on Benefit Elections during enrollment periodSummary report on those who select an option before enrollment is completeContent Is there a way we can report on newly hired employees who have selected a certain benef…Shelly Feyerherm 63 views 4 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM
-
Need to find the Owner of the BI ReportSummary Need to find the Owner of the BI ReportContent I need to know the owner(who has created) the report for almost 85 reports.is there an easy way to do that. Or do …User_2025-02-05-02-11-29-794 29 views 5 comments 0 points Most recent by User_2025-02-05-02-11-29-794 Reporting and Analytics for HCM
-
Time Card Cost Center in OTBIContent I'm trying to fetch All Approved Time Cards where the Employee hours are charged to a different cost center than the employee home cost center in OTBI. Which Sub…Nithin Channa 33 views 2 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM
-
Excel Template maximum row issueSummary Excel template maximum row issueContent Hi Team , We have created Excel template for one of our report but the number of lines getting exceeded 65536 , so the ou…User_2025-02-05-04-35-46-440 36 views 6 comments 0 points Most recent by User_2025-02-05-04-35-46-440 Reporting and Analytics for HCM
-
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path …