BI Publisher
Discussion List
-
Need to find out the Payroll Batch Loader Element Entry input value tablesSummary Need to find out the Payroll Batch Loader Element Entry input value tablesContent Hi All, I have a requirement to generate an error report for payroll batch load…Sricharan Monigari 126 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI report to capture Workforce Modeling detailsContent Is there any subject areas to capture workforce modeling details ? I could able to find few tables related to the module but not OTBI report areas. Appreciate yo…User_2025-01-28-21-18-43-496 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Email notification for Profile ChangeSummary Email notification for Profile Change report is returning no dataContent Hi Everyone! I am customization our email notifications in R13. For that, we have enable…Alvaro Couto 76 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesSummary OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesContent Hi All, We have recently discovered that seeded Oracle reports do no…User_2025-01-29-23-59-58-976 158 views 12 comments 1 point Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
Displaying images in BI Publisher RTF TemplatesSummary Displaying images in BI Publisher RTF TemplatesContent Hi, I'm fetching employee images from PER_IMAGES to display in the report. I have provided size restrictio…Aloka Bhattacharya 68 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
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 37 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 63 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 39 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 57 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 229 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 22 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 83 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 96 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 65 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 65 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 214 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 207 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 78 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 73 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 153 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 44 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 117 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 45 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM