BI Publisher
Discussion List
-
Pivot report not showing values accuratelySummary BIP Report - Table format is showing amounts correctly. But not working in pivot layoutContent Trying to display past 5 year compensation history. It works fine …User_2025-01-25-04-02-13-126 43 views 1 comment 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
BI report based on HCM extract outputSummary BI report based on HCM extract outputContent Hello experts, I have a requirement of creating a BI report based on ' HCM extract output which is set as Changes On… -
Retro Details Report is Getting ErrorSummary Retro Details Report getting oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOE…Balaganapathi Kasineedi 61 views 4 comments 2 points Most recent by Balaganapathi Kasineedi Reporting and Analytics for HCM
-
Termination Report based off Entry DateSummary Business need to create a termination report based off of entry dateContent Hello, Has anyone created a Termination Report that looks off of the termination/acti…User_2025-01-31-00-25-12-234 107 views 9 comments 1 point Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
BI Publisher - CASE WHEN returns correct value on Tree View OnlySummary CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database val… -
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 38 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM
-
Need inputs on HCM Absence Seeded Audit ReportsSummary Need inputs on HCM Absence Seeded Audit ReportsContent Hi Experts, We are looking for inputs on Seeded Absence Audit Reports, like what is the purpose of each an…Harish Kumar Kovi 60 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need SQL/Catalog for Payroll Balances Report Based on EE Relationship ITDContent Hello All, Do you have any catalog/query to fetch employee payroll balance values based on employee “Relationship Inception To Date” dimension,. OTBI report do n…Janardhana Kondaveeti 219 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Report of dependents enrolled in each planSummary Report of dependents enrolled in each planContent Hi, trying to find a report that displays the benefit plans where each dependent is enrolled. So for an employe…Craig O'Connor 79 views 5 comments 0 points Most recent by Craig O'Connor Reporting and Analytics for HCM
-
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily …Prudence K 34 views 2 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 141 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
Historic data of role assignmentsSummary Historic data of role assignmentsContent Hello Does anyone know if it is possible to return the history of a role being assigned to a user? For example User A ha…
-
Failed notification messages on providing a wrong email addressContent Hi All, We are developing one BIP report where we have utilized the bursting option to send an email to employees based on certain changes. Currently, we are sen…Amrit 35 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
Need BI SQL to fetch previous row assignment and salary details of employeesSummary I need to fetch previous row details based on latest row effective end dateContent In My BI Report, if i passed effective end date as a parameter , then employee…User_6U8NQ 289 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher Export LimitContent We recently created a BI Publisher report based on a Data Model. The Data Model was created based on a BI Analysis. When trying to schedule the report with an ou…User_2025-01-23-23-27-03-729 492 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sub Folder for Requisition field in Workforce ModellingContent Hi Guys, I'm creating a proof of concept for the reporting that can be done out of the workforce modelling area and can't seem to locate the field 'Requisition'.…Ivy__Valverde 38 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
column information for PAY_ACTION_INFORMATIONSummary PAY_ACTION_INFORMATION Developer DFF Columns detailsContent I am looking for details on action_information1...300 columns in pay_aciton_information. what data is…Rakesh Lathiya 2018 133 views 2 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM
-
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e…User_2025-01-28-08-17-22-037 166 views 2 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Query to get Report run History in Fusion HCMSummary Query to get Report run History in Fusion HCMContent Hi All, Is there any possibility to get the details of a report's run History in Fusion HCM? I want to know …SuryaMuralidharan 313 views 8 comments 2 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT LEAVE CASES.Summary BI Report to achieve SANDWICH ABSENT LEAVE CASES.Content Please Kindly Help us to achieve these scenarios in BI Reports. Here below are the two scenarios, We are…Ravikanth Rao Thota 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report Jobs Not Saving Notification PreferencesSummary The scheduled BI Publisher report jobs are not sending notifications. The notifcations are used to confirm report completion or failure.Content Hi, We will be us…
-
BIP SQL Query for Previous Assignment Information, Updated Assignment Information, Previous Person ISummary BIP SQL Query for Previous Assignment Information Updated Assignment Information Previous Person Information Updated Person Information Previous Bank Information…User_2025-02-01-06-07-07-886 621 views 4 comments 0 points Most recent by User_2025-02-01-06-07-07-886 Reporting and Analytics for HCM
-
A general error has occurred. Please have your System Administrator look at the log for more detailSummary State: HY000. Code: 27046. [nQSError: 27046] Inaccessible column: "Human Capital Management - Approval Notification Archive Real Time"."Time - Approval Initiated…Murugavel 52 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
EHS:Multiple Participants on Single IncidentSummary EHS:Multiple Participants on Single IncidentContent Hi Team, For a single incident we are having multiple participant. So I want to know some joining condition w…Nidhi Chhajed 45 views 1 comment 0 points Most recent by Glen Walton-Oracle Reporting and Analytics for HCM
-
List of employees that are LINE MANAGERSSummary List of employees that are LINE MANAGERSContent Employee Details that are Line Managers Hello Community, Could anyone share a sample report which will list down …Prosenjit Manna 76 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Error Password Protecting Excel Templates in BIPSummary Trying to password protect BIP reports that were built using the excel add in, but incorrect file type is showing up.Content Hi all, I'm having some issues with …User_2025-01-31-00-25-12-234 48 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Display dates in Hebrew language in BI Publisher RTFSummary How to display dates in hebrew in dd.monthname.yyyy format in BIP RTF TemplateContent Hi All, I want to display date in hebrew language in the format dd.Month.yy…SuryaMuralidharan 51 views 3 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
SQL query fetching Duplicate rows for terminated employees with pending worker recordsSummary SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent I created a SQL BI Publisher report to fetch all active employees a…User_2025-01-30-21-52-52-008 273 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
PDF/A output is not working as expected in BI Publisher reportSummary How to set PDF/A output for a BI Publisher report in HCMContent Hi All, I want to set output type of a BI Publisher report as PDF/A as my intention is not to let…SuryaMuralidharan 62 views 1 comment 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
How to trigger the sending of a report with an action typeSummary Is it possible to trigger the sending of a report with the performing of an action?Content Hi, Is it possible to trigger the sending of a report with the perform…Silvia Guido 71 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM