BI Publisher
Discussion List
-
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 466 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 118 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 160 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 251 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 37 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 563 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 41 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 42 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 72 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 40 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 48 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 262 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 58 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 33 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 79 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 242 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 39 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 71 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 48 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 48 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
-
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 71 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Publisher - Default ViewContent Hello, Whenever I create BIP report with supporting data model, report always runs in PDF view/format. How can I enforce Interactive view as a default view? Rega… -
How do you report in OBI on workers who have not created any goals?Summary Cannot work out how to bring back colleagues who have not even created a goalContent Hello everyone, One of our business requirements is to be able to report on …User_2025-02-04-13-09-16-898 63 views 2 comments 0 points Most recent by User_2025-02-04-13-09-16-898 Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 75 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 28 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM