BI Publisher
Discussion List
-
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 33 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 138 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 33 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 277 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 459 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 36 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 119 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 158 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 229 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 38 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 536 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 43 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 44 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 71 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 41 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 49 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 261 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 57 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 67 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…Bhuangtran 34 views 3 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Tables to track employee activity to HCMContent Hi All, Can anyone tell us if there is a report,tables...or fields that we can use to create a report...to track if an employee has: 1) Attempted to login to HCM…User_2025-02-04-18-22-33-673 80 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788 Reporting and Analytics for HCM
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 245 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
Report to fetch Hire Dates in a letterSummary Not able to compare among three date in BI PublisherContent I have developed a BI Report to extract salary of a person. And after this developed RTF template in …User_2025-01-29-18-45-19-617 42 views 2 comments 0 points Most recent by User_2025-01-29-18-45-19-617 Reporting and Analytics for HCM
-
Payroll balance value using PAY_RUN_BALANCESContent Hi All, We have a custom payroll balance (XX_MISC_BAL) and added dimension as "Assignment Tax Unit Year to Date" and "Relationship NoCB Year to Date" as on 01-Ja…
-
How to adjust default selection in Line manager dashboardSummary Change default selection in Line manager dashboardContent In the Line Manager Dashboard by default one BU is marked. I want to change this to 'All'. I have copie…Wouter.Schaap 72 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Display on a radar graph 2 times the same gradeSummary Display same grade on the radar graphContent Dears, In the absence of the radar graph for the competencies , I am developing on BI a "home made" version. In some…User_2025-01-30-22-29-59-990 49 views 1 comment 3 points Most recent by User_2025-01-30-22-29-59-990 Reporting and Analytics for HCM
-
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 50 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
Need to schedule multiple BIP reports at onceSummary Need to schedule multiple BIP reports at onceContent Hi, I need to know if we can create sort of a job to combine all the BIP reports so that they can be schedul…User_2025-01-31-02-27-22-166 76 views 8 comments 1 point Most recent by User_2025-01-31-02-27-22-166 Reporting and Analytics for HCM