BI Publisher
Discussion List
-
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 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 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 73 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 73 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 80 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 29 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 55 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 155 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 18 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 49 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 208 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 80 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …AshishERPCloud 180 views 15 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc…Vibha Pandey - Oracle 72 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an… -
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 80 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…Kalyan Amaravathi 50 views 3 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM -
HCM - Business Intelligence: Using OTBI Hierarchies -- September 14, 2017, 9 a.m. PT - Submit QuestiContent Submit your questions for the HCM - Business Intelligence: Using OTBI Hierarchies session to have them answered during the live event. Post your questions by pos…Gail Langendorf-Oracle 102 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …User_2025-01-22-19-43-38-766 46 views 8 comments 0 points Most recent by Lauren Owen Reporting and Analytics for HCM