BI Publisher
Discussion List
-
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 607 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 50 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 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 46 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 270 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 68 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 37 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 82 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 249 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 76 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 52 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 52 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 77 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 80 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 67 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 87 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 34 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM -
Agent mail trigger issueContent Hi, I have created a agent. In 'Delivery Content' tab I have given content as 'Briefing Book' with PDF format , and also configured mail ids in Recipients' tab, … -
Issues with BIP reportSummary Issues with BIP reportContent Hi, I have following issues with my BIP report: 1. How to fetch country name from a country code ? I need to print country name in …User_2025-01-31-02-27-22-166 58 views 4 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM -
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 165 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM -
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Agent Deletion errorContent Hi I am getting below error while deleting the agent , please assist on this. ThanksUser_7836 22 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r…Neha_Takkar 50 views 5 comments 2 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…User_2025-02-01-08-16-14-343 212 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM