BI Publisher
Discussion List
-
BI Publisher - Prompts that update other promptsSummary Refresh Other Parameters on Change causing parameters to blankContent Hello Experts! I have a data model where we've built 8 parameters and I'm trying to make th… -
Audit Role Delegation and Revoked RolesSummary Report which audits role delegation and revoked rolesContent Hi Community, We are trying to audit the delegation of roles, and roles that have been revoked from …User_2025-01-30-20-23-15-920 77 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
“Workforce Management Person Real Time”Summary Sample delivered report that has access to subject areaContent New to BI, but need to start somewhere. I have an end user that thinks he needs access to "Workfor…User_2025-01-31-01-48-51-545 51 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
BI Analytics - Which subject area contains Pension InformationContent Hi, I am trying to Analysis report and am looking to bring in Pension information held on the workers Assignment details, is this held in a specific Subject Area… -
Report for staff eligible to performance document without goal enteredSummary Report on staff eligible to performance without goalContent Hello Does anyone has a report that would filter the eligible staff to a particular performance docum…User_2025-01-30-22-29-59-990 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add securituy in OTBI foldersSummary What is the best practices for security for OTBI folder level for all Organization.Content Under Custom folder there are sub folder as mentioned below for FIN, S…Farooq Syed, CPA, PMP, CISA 63 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
Pivot report not showing values accuratelySummary BIP Report - Table format is showing amounts correctly. But not working in pivot layoutContent Trying to display past 5 year compensation history. It works fine …User_2025-01-25-04-02-13-126 36 views 1 comment 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
BI report based on HCM extract outputSummary BI report based on HCM extract outputContent Hello experts, I have a requirement of creating a BI report based on ' HCM extract output which is set as Changes On… -
Retro Details Report is Getting ErrorSummary Retro Details Report getting oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOE…Balaganapathi Kasineedi 53 views 4 comments 2 points Most recent by Balaganapathi Kasineedi Reporting and Analytics for HCM
-
Termination Report based off Entry DateSummary Business need to create a termination report based off of entry dateContent Hello, Has anyone created a Termination Report that looks off of the termination/acti…User_2025-01-31-00-25-12-234 97 views 9 comments 1 point Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
BI Publisher - CASE WHEN returns correct value on Tree View OnlySummary CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database val… -
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 26 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM
-
Need inputs on HCM Absence Seeded Audit ReportsSummary Need inputs on HCM Absence Seeded Audit ReportsContent Hi Experts, We are looking for inputs on Seeded Absence Audit Reports, like what is the purpose of each an…Harish Kumar Kovi 54 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need SQL/Catalog for Payroll Balances Report Based on EE Relationship ITDContent Hello All, Do you have any catalog/query to fetch employee payroll balance values based on employee “Relationship Inception To Date” dimension,. OTBI report do n…Janardhana Kondaveeti 210 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Report of dependents enrolled in each planSummary Report of dependents enrolled in each planContent Hi, trying to find a report that displays the benefit plans where each dependent is enrolled. So for an employe…Craig O'Connor 72 views 5 comments 0 points Most recent by Craig O'Connor Reporting and Analytics for HCM
-
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 32 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 137 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 31 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 269 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 465 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 116 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 156 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 247 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 550 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