BI Publisher
Discussion List
-
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 120 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 120 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 121 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 45 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 72 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 155 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 61 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 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 35 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 52 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 221 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 94 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 61 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 203 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 70 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 148 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