BI Publisher
Discussion List
- 
             Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 152 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 152 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             BI Publisher Report Name with Date and TimeSummary Include the Date and Time in the Output Report Name of Scheduled ReportContent Hello All, I have a report that will run as a BI scheduled report. Is there any wa…Daniel McMillian 102 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM BI Publisher Report Name with Date and TimeSummary Include the Date and Time in the Output Report Name of Scheduled ReportContent Hello All, I have a report that will run as a BI scheduled report. Is there any wa…Daniel McMillian 102 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
- 
             BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun…Alvaro Couto 40 views 4 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun…Alvaro Couto 40 views 4 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM
- 
             Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…User_2025-02-04-16-50-19-277 79 views 5 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…User_2025-02-04-16-50-19-277 79 views 5 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
- 
             Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 43 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 43 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
- 
             How to enable two bursting queries at a time in the BI report while scheduling.Summary How to enable two bursting queries at a time in the BI report while scheduling.Content Hi , I have a requirement that to send resignation alert with checklist to…User_MC37Q 194 views 5 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM How to enable two bursting queries at a time in the BI report while scheduling.Summary How to enable two bursting queries at a time in the BI report while scheduling.Content Hi , I have a requirement that to send resignation alert with checklist to…User_MC37Q 194 views 5 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
- 
             Table name for Element Frequency RulesSummary Table name for Element Frequency RulesContent Hi, Any inputs on how to pull Frequency Rules setup on Element definition? I'm trying with the below tables PAY_ELE…User_2025-02-04-13-35-15-879 94 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM Table name for Element Frequency RulesSummary Table name for Element Frequency RulesContent Hi, Any inputs on how to pull Frequency Rules setup on Element definition? I'm trying with the below tables PAY_ELE…User_2025-02-04-13-35-15-879 94 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM
- 
             Pull data from Excel file which is in content serverSummary Pull data from Excel file which is in content serverContent Hi All, I have one requirement that, one Excel file is in content server, i need to pull data from th…Sai1654 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Pull data from Excel file which is in content serverSummary Pull data from Excel file which is in content serverContent Hi All, I have one requirement that, one Excel file is in content server, i need to pull data from th…Sai1654 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Need to hide unnecessary folder for Custom Report ViewerSummary Need to hide unnecessary folder for Custom Report ViewerContent Hi, In Shared folder there exist lots of unnecessary folder related to different module. My HR us…Azfar.128 72 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM Need to hide unnecessary folder for Custom Report ViewerSummary Need to hide unnecessary folder for Custom Report ViewerContent Hi, In Shared folder there exist lots of unnecessary folder related to different module. My HR us…Azfar.128 72 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM
- 
             How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Summary How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using …User_1B10X 42 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Summary How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using …User_1B10X 42 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
- 
             BI Bursting Mail - Need to Send Mail from a Generic Mail BoxSummary BI Bursting Mail - Need to Send Mail from a Generic Mail BoxContent Dear All, We have created a Generic Mail Distribution List Say "HRServices@ABC.ae". In the BI…Christopher Jothi - HCM-Oracle 41 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM BI Bursting Mail - Need to Send Mail from a Generic Mail BoxSummary BI Bursting Mail - Need to Send Mail from a Generic Mail BoxContent Dear All, We have created a Generic Mail Distribution List Say "HRServices@ABC.ae". In the BI…Christopher Jothi - HCM-Oracle 41 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
- 
             BI Publisher reportsSummary Version ControlContent Hi Team, Can someone suggest a control version for HCM SaaS for BI Publisher reports? What are our options? Thank you, Alvaro Couto Versio…Alvaro Couto 57 views 1 comment 3 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM BI Publisher reportsSummary Version ControlContent Hi Team, Can someone suggest a control version for HCM SaaS for BI Publisher reports? What are our options? Thank you, Alvaro Couto Versio…Alvaro Couto 57 views 1 comment 3 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
- 
             Time to Run Reports to Prevent Daily DuplicatesContent Hi all - I am experiencing an issue here and need some help. I have a report that we run daily for our new hires. Each day the report contains data for that day …Prudence K 45 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM Time to Run Reports to Prevent Daily DuplicatesContent Hi all - I am experiencing an issue here and need some help. I have a report that we run daily for our new hires. Each day the report contains data for that day …Prudence K 45 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
- 
             Grade on Worker vs Grade on JobSummary We need a report that shows employees grade on worker level and grade on job levelContent I need a report like NAME | Grade (at worker level) | Grade (job level)… Grade on Worker vs Grade on JobSummary We need a report that shows employees grade on worker level and grade on job levelContent I need a report like NAME | Grade (at worker level) | Grade (job level)…
- 
             Salary by "As of Date"Summary Active and Term employee salaries during specified dateContent Hello! I am trying to capture historical data on all employees (active and inactive/terms) who wer…User_2025-02-04-13-00-33-588 67 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM Salary by "As of Date"Summary Active and Term employee salaries during specified dateContent Hello! I am trying to capture historical data on all employees (active and inactive/terms) who wer…User_2025-02-04-13-00-33-588 67 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             Display Person Image in a ReportSummary Can I display person image in OTBI or BI Publisher Report?Content Hi, There is an option to display the person image in an OTBI report or BI Publisher report? Th… Display Person Image in a ReportSummary Can I display person image in OTBI or BI Publisher Report?Content Hi, There is an option to display the person image in an OTBI report or BI Publisher report? Th…
- 
             Data Model Validation ResultSummary SQL query contains non-equi joinsContent Hi Guys, I am in 18C and I am getting the following warning message in Data Model: WARNING Dataset:LOV_Emp_Name SQL quer…Alvaro Couto 44 views 5 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM Data Model Validation ResultSummary SQL query contains non-equi joinsContent Hi Guys, I am in 18C and I am getting the following warning message in Data Model: WARNING Dataset:LOV_Emp_Name SQL quer…Alvaro Couto 44 views 5 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
- 
             Getting same answer to the question for all employees check-ins template in BI ReportContent I am making a report to get the answers to questions of check-ins templates.I am getting same answer for all employees who are in same check-ins meeting template…User_MC37Q 28 views 5 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM Getting same answer to the question for all employees check-ins template in BI ReportContent I am making a report to get the answers to questions of check-ins templates.I am getting same answer for all employees who are in same check-ins meeting template…User_MC37Q 28 views 5 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
- 
             Business User created OTBI Analyses - GovernanceSummary Business User created OTBI Analyses - GovernanceContent My reporting team is creating a strategy to allow (non-technical) biz users to develop and promote analys… Business User created OTBI Analyses - GovernanceSummary Business User created OTBI Analyses - GovernanceContent My reporting team is creating a strategy to allow (non-technical) biz users to develop and promote analys…
- 
             Any one tried Calling SOAP web-services to submit and download BIP ReportSummary Any one tried Calling SOAP web-services to submit and download BIP ReportContent We are trying submit and download the BIP reports using Webservices. As per orac…User_2025-01-28-00-10-14-788 65 views 5 comments 1 point Most recent by User_2025-01-28-00-10-14-788 Reporting and Analytics for HCM Any one tried Calling SOAP web-services to submit and download BIP ReportSummary Any one tried Calling SOAP web-services to submit and download BIP ReportContent We are trying submit and download the BIP reports using Webservices. As per orac…User_2025-01-28-00-10-14-788 65 views 5 comments 1 point Most recent by User_2025-01-28-00-10-14-788 Reporting and Analytics for HCM
- 
             Reporting Questions (HCM data)Summary Reporting Questions (HCM data)Content Have 2 reporting related questions: 1. Which reporting tool (OTBI or BI Publisher) do you train your business users on? The…Rich R 111 views 11 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Reporting Questions (HCM data)Summary Reporting Questions (HCM data)Content Have 2 reporting related questions: 1. Which reporting tool (OTBI or BI Publisher) do you train your business users on? The…Rich R 111 views 11 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
            Integration or Report ScheduleSummary Integration or Report ScheduleContent Hi experts, please provide steps for canceling schedule of hcm extract integrations. And how do we check weather if BI Publ…Thiru Ch 71 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Need to add running parameter into report output i.g ExcelSummary Hi Foks , We have requierment to add running parameter into report output, we don't how to do that BI analytics reportUser_2025-02-01-07-17-18-414 42 views 5 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM Need to add running parameter into report output i.g ExcelSummary Hi Foks , We have requierment to add running parameter into report output, we don't how to do that BI analytics reportUser_2025-02-01-07-17-18-414 42 views 5 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
- 
             Need inputs to zip the output file to be placed in UCM Server through BIPContent Hi All, We can place the output file in UCM server through BIP. While placing the file in UCM server, can we zip the file? If yes, Please share sample Bursting c… Need inputs to zip the output file to be placed in UCM Server through BIPContent Hi All, We can place the output file in UCM server through BIP. While placing the file in UCM server, can we zip the file? If yes, Please share sample Bursting c…
- 
             Table name for department history of employeeSummary Table name for department history of employeeContent Hi All, May i know the any other table name which tracks the department history of employee except per_all_a…nitin Sharma 88 views 1 comment 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM Table name for department history of employeeSummary Table name for department history of employeeContent Hi All, May i know the any other table name which tracks the department history of employee except per_all_a…nitin Sharma 88 views 1 comment 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM
- 
             Subject Area for Employee roleSummary Subject Area which Employee role has access, and employees can see their LE and LOCContent Subject Area which Employee role has access, and employees can see the…User_2025-01-30-23-59-27-880 63 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Subject Area for Employee roleSummary Subject Area which Employee role has access, and employees can see their LE and LOCContent Subject Area which Employee role has access, and employees can see the…User_2025-01-30-23-59-27-880 63 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Note to Self: Fixing timeout errors in BIPSummary Solution to BIP timeout errors from Support Document 2307631.1Content Bit of a noddy one, but this is really just a note to myself as I occasionally encounter th… Note to Self: Fixing timeout errors in BIPSummary Solution to BIP timeout errors from Support Document 2307631.1Content Bit of a noddy one, but this is really just a note to myself as I occasionally encounter th…
- 
             Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at sSummary Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at some point with the latest legal employer infoContent Hi, Has …User_2025-01-30-21-52-52-008 99 views 2 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at sSummary Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at some point with the latest legal employer infoContent Hi, Has …User_2025-01-30-21-52-52-008 99 views 2 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
- 
             R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 722 views 7 comments 9 points Most recent by User720640-Oracle Reporting and Analytics for HCM R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 722 views 7 comments 9 points Most recent by User720640-Oracle Reporting and Analytics for HCM
- 
             Outputting Dates (no timestamp) to Excel and keeping date formatSummary Outputting Dates (no timestamp) to Excel and keeping date formatContent Good afternoon. In our BIP reports, we have been removing the timestamp portion from date…Rich R 95 views 1 comment 1 point Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM Outputting Dates (no timestamp) to Excel and keeping date formatSummary Outputting Dates (no timestamp) to Excel and keeping date formatContent Good afternoon. In our BIP reports, we have been removing the timestamp portion from date…Rich R 95 views 1 comment 1 point Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM