BI Publisher
Discussion List
-
Administartion tab is not visible on theSummary unable to see the administartion tabContent I have the Application implementation consultant role as well as HR analyst View All data role. I am still nto able t…User_2025-02-01-08-16-14-343 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Training documentation/slides for general usersSummary Training documentation/slides available for general (non-builder) user populationContent Good afternoon. Does anyone know of any "basic" OTBI/BI Publisher presen…Rich R 57 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…Rebecca Smith-27468 34 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 51 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas…Brendon Charles-24581 218 views 3 comments 1 point Most recent by Brendon Charles-24581 Reporting and Analytics for HCM -
After R13 Upgrade - Sample data are saved in xdm formatSummary After R13 Upgrade - Sample data are saved in xdm formatContent Hi, After uprading to R13, I am noticing when we try to save sample data by running a SQL in BI pu…Karthik K-Oracle 20 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the…Ivy__Valverde 78 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Security Roles - Country Role vs AoR RoleContent Hi experts - I am trying to understand how we can limit our view to reports based on the Area of Responsibility (AoR). Current State: We have a security role cal… -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…Mohit Gupta-45440 93 views 4 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB…
-
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism…Aloka Bhattacharya 60 views 4 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Not Able to Update Permission on Shared FolderSummary Not able to update Shared FolderContent Good day, We recently updated to R13 in our test environment. I was going through to add permissions on the Shared folder… -
Inability to Secure Seeded Reporting Folders in R13Summary We were informed that as part of R13 we are unable to individually secure the seeded report folderContent Has anyone found a work around for securing the seeded …Andrea Arment 60 views 5 comments 0 points Most recent by Andrea Arment Reporting and Analytics for HCM
-
Report on Active Employee count as of dateSummary I need a report that provides me an active employee (Active & LOA) as of start of each monthContent Hi, This is Shailesh. When I look at the counts from 'Workfor…User_2025-01-29-01-34-30-592 181 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 201 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM
-
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it…
-
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar…User_MC37Q 74 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to get the from email address in BurstingContent Hi All, In the bursting query for the parameter3 value we are passing "bipublisher-report@oracle.com" and able to get the email after report submitted. If we use…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Hire/Seniority DatesSummary How do I report on these dates in OTBI/BIP?Content Hi all - I know that Julian had a great post about what the individual dates are (https://cloudcustomerconnect…Prudence K 145 views 7 comments 0 points Most recent by User_2025-01-25-01-10-42-578 Reporting and Analytics for HCM
-
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 40 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C…User_MC37Q 89 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BIP BurstingSummary Image in RTF Template received as attachment in emailContent Hi, We have a requirement to have company Logo and some images in the email notification, which will…Sivakumaran Muthusamy-Oracle 113 views 4 comments 0 points Most recent by Unknown Reporting and Analytics for HCM -
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…User_MC37Q 37 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Release 13 - 50000 cell limit in BI Answers??Summary Our reports no longer can export the data they need!Content Hi all, Following our upgrade of release 13 there seems to be a limit on 50000 cells exported, we hav…Kevin M Storrie 181 views 33 comments 2 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' …Mohit Gupta-45440 119 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Possible to embed link to run a report, inside a Dashboard pageSummary Embed link to run a report, inside a Dashboard pageContent We have a request to embed a link in a Manger's Dashboard that will allow them to run a pre-built repo…
-
OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format)Summary OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format) should come up.Content Hi, I have a OTBI analysis where I ha…User_MC37Q 55 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to give incremental Sequence in a Bi ReportContent Hi, I have requirement to create position report where I need to give sequence number like 1,2,3 etc. What need to used in data model to achieve this in BI publi…User_2025-01-31-01-21-22-432 82 views 2 comments 0 points Most recent by User_2025-01-31-01-21-22-432 Reporting and Analytics for HCM