BI Publisher
Discussion List
-
Manager HiearchySummary Manager HiearchyContent Trying to get the Manager Hiearchy using CONNECT BY PRIOR on PER_ASSIGNMENT_SUPERVISORS_F. Noticed that there are flattened manager hiera…VijayaBaskar Ranganathan 116 views 4 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Tell us how you use OTBI to inform our future product directionContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 47 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report: Need help with Dependent parameter LOVSummary BI Report: Need help with Dependent parameter LOVContent Hi, I have a BI Report where there are 2 parameters: 1) Review Period: 2) Period_Month_Or_Week 1) Review…User_MC37Q 64 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Issue in "Workforce Performance - Performance Rating Real Time" Post Rel 13Summary Post Release 13 IssueContent Hi All, Attaching a report for performance tracking created on the "Workforce Performance - Performance Rating Real Time"(subject ar…User_2025-01-30-00-14-06-021 86 views 6 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
report show "no results" for specific roleSummary cant see results for person profile reportsContent hi, we created 2 reports from subject area "Workforce profiles: person profile real time" both report are work…User_2025-01-30-04-14-21-127 73 views 5 comments 1 point Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM -
Adding Custom ColumnsSummary Adding Custom ColumnsContent Is it possible to add custom columns or custom logic to the existing subject area. If so, please share more detailsVijayaBaskar Ranganathan 58 views 4 comments 0 points Most recent by Mark_Daynes Reporting and Analytics for HCM -
Custom Subject AreaSummary Custom Subject AreaContent Is it possible to create custom subject area with the custom columns. If so, please share more detailsVijayaBaskar Ranganathan 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Reports: Condition Region around tables are not working in RTFSummary BI Reports: Condition Region around tables are not working in RTFContent Hi, To explain in detail: We have a data model which has a parent and a child group. G_G…User_MC37Q 40 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsSummary OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsContent Hi All, The data in OOTB Statutory Deduction Register Report (Loc: /Shared Folder…User_2025-07-18-02-05-33-261 45 views 1 comment 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM -
BIP RTF Template - conditional display of textSummary BIP RTF Template - conditional display of textContent Hello, We are using BI Publisher to send emails to new hires (data model, bursting, RTF Template) I have a …User_2025-01-23-21-24-21-434 280 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Dependent Parameter in BI Data Model does not work as expected.Summary Dependent Parameter in BI Data Model does not work as expected.Content Hi, Dependent Parameter in BI Data Model does not work as expected. The 2nd parameter's va… -
Summation of worker category in OTBI ReportSummary Summation of worker category in OTBI ReportContent Hi Experts, I need a help. I have an OTBI report where I display the workers in each department, their job & w…Aloka Bhattacharya 54 views 15 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException&Summary Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException: FO processing stopped at 128MB memory usage; Large table in page …Aloka Bhattacharya 113 views 4 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Position Action Reason field is not showing in the Workforce Management - Position Real Time SubjectSummary Position Action Reason field is not showing in the Workforce Management - Position Real Time Subject AreaContent Hi All, I am trying to include position action r…Vijaya Kumar Komari 41 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM -
Fact FTE is not extracting correct data based on BU and Contract TypeSummary Fact FTE count value is repeating for every contract type base on BU but it should show FTE different value for each contract typeContent Hi All, I tried to crea…Vijaya Kumar Komari 23 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM -
HCM SchedulesSummary Schedules are not showing active days & hours for departmentsContent Hi guys, I've been trying to create an OTBI analysis that will show person's department shif…Pavel Kartuz 221 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM -
Need to know the table storing the approver details in Person Management page, Oracle Fusion HCMSummary Need to know the table storing the approver details in Person Management page, Oracle Fusion HCMContent Hi, We have a requirement where we need to send transfer …User_MC37Q 62 views 6 comments 0 points Most recent by Riaz Ahmed Mohammed Sait - Oracle-Oracle Reporting and Analytics for HCM -
Email Workflow Notifications - Task status not working properlySummary Email Workflow Notifications - Task status not working properly in customized email notification TemplateContent We have a requirement where we need to trigger e…Vijay Koyeda 64 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themSummary Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themContent Hi, I'm new to OTBI. I have a requirement to display the Column …Aloka Bhattacharya 431 views 13 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Email Workflow Notifications - action buttons links not workingSummary When configuring Workflow Notifications subtemplate the action buttons and links at bottom are not workingContent Hi everyone, We are trying to configure Workflo…Pavel Kartuz 111 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Schedule Report JobSummary Adding Output destination typeContent I need to add a destination type like FTP and Web folder. Can someone let me know how to add values for it ? Also I need kn…User_2025-01-28-21-18-43-496 79 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM -
Returning the most recent dateSummary Want to return only the most recent dateContent I have an analysis that I am doing in BI and trying to return just one record per person, with the date as the fi…Deb Luisi 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I create a BI report, which shows the list of users who are locked into the system.Summary I want to create a BI report, which shows all the users whose ID is locked into the system. They are Active users but not suspended.Content Can anyone tell me th…User_2025-01-29-18-45-01-148 103 views 5 comments 1 point Most recent by User_2025-02-01-06-21-55-603 Reporting and Analytics for HCM -
Compliance ReportingSummary Does HCM come with EEO-1 and Vets-100a Reports?Content Does HCM come with EEO-1 and Vets-100a Reports? I can't seem to find any, but it would surprise me if they…User_2025-01-23-21-30-59-936 74 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Need help in excel templateSummary Need help in excel templateContent Hi All, I'm facing issue when I try to paste the xsl code into a cell in the excel template. Let me brief about my requirement…User_DZMJW 55 views 2 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM -
Running a Report from the UI(Scheduled Processes)Summary Running a Report from the UI(Scheduled Processes)Content Hello All, In Oracle Apps we could register the report created and give access to a particular set of us…User_2025-01-31-20-01-00-954 67 views 6 comments 0 points Most recent by User_2025-01-31-20-01-00-954 Reporting and Analytics for HCM -
BI publisher - share report links after R13 upgradeSummary issue with the links of the BIP report after R!#Content hi all, after upgrade our env to R13 - all are dashboards which contains BIP report (which we were used t…User_2025-01-30-04-14-21-127 44 views 1 comment 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM -
BIP for DepartmentSummary Is it possible to report on Department Level 2?Content Hi all - we need to report on the Department Level 2 (Sub-Business Unit/Sub-Exec Area). I see how it can b…Prudence K 124 views 5 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM -
Actions and Action ReasonsContent Is there a report to get complete list of Actions and Action Reasons? Thank you! -
how to fetch previous and current value for global transfer action?Content Hi, we are not able to find solution to action 'global transfer' (when changing Legal entity) to see in one report the old and new value- related to the fact new…Gal Shani 123 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM