BI Publisher
Discussion List
-
Benefits OTBI Analysis with Effective Date Parameter Not workingSummary Benefits OTBI Analysis with Effective Date Parameter Not workingContent Team, I have a Benefits enrollment details OTBI analysis which is working fine without pr…User_2025-02-01-03-43-13-079 51 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
BI report Job and OTBI agent scheduleContent Hi All, We have already many BI job report scheduled daily basis with attachment (maximum 10MB per attachment), similarly for OTBI agent as well. The email would…User_2025-01-30-19-06-42-738 50 views 1 comment 1 point Most recent by Mohammed Khan-82529 Reporting and Analytics for HCM
-
Multi-selection parameter is not working for more than 1000 LOVsContent Hi All, I am using position name as parameter in my BI report. Syntax for using multi-selection parameter is- POS.NAME IN (:P_POSITION) OR 'All' IN (:P_POSITION …User_2025-02-06-14-37-05-233 77 views 8 comments 1 point Most recent by MaartenDIF Reporting and Analytics for HCM
-
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My… -
OTBI Dashboard Analysis Links to a BI ReportSummary OTBI Analysis opens a BI Report Passing the Person NumberContent On our dashboard, we have a summary report built from an analysis (table format). When the user …Shelly Feyerherm 56 views 6 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Recruiting Module - OTBI/BI ReportSummary Recruiting Module - OTBI/BI ReportContent Hi Team, I'm new to Recruiting Module I would like to fetch following attributes from either OTBI/ BI Report. Please he…Mahendra 91 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BI Publisher Report filter with multiple criteriaSummary Needing to add multiple criteria to an OTBI report filter e.g. multiple business unitsContent When adding a filter to a report created in OTBI I need to add mult…Chris Ross-Smith 108 views 6 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Union Field in Employee screenSummary Union Field in Employee screenContent Hello All , Can you please let us know where we can find "UNION" in which Oracle table. NAvigation is :- My Client Groups >…Lucky Sharma 39 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report with Employee names in the 9 Box instead of countContent We are trying to build a OTBI report that can show employee names in the 9Box instead of counts/ performance tiles. Attaching picture for reference. Is this poss…User_2025-02-10-08-27-16-805 39 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
How to Include an url in the BI Publisher Bursting Email BodySummary How to Include an url in the BI Publisher Bursting Email BodyContent I have a link which needs be sent to the recipients going through the busting email. Here is… -
Function FILTER requires at least one measure column in its first argument.Summary Function FILTER requires at least one measure column in its first argument.Content I would like to use the filter function on a non numeric column but I run into…User_2025-02-10-08-27-16-805 320 views 4 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n…Dean Soto 36 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Individual compensation plans subject areasContent Hello experts, I should create a payroll report in order to extract for each employee Individual Compensation Plans information. As a result, I need the followin…Valerio Curzi 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, VijayUser_2025-02-07-19-03-14-525 33 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 29 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, ReddykrishnaReddykrishna Chidella-Oracle 62 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…Rogelio H 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t…SantoshKumarBhairi 9 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Passing parameter from Dashboard Prompt to BI ReportSummary Passing parameter from Dashboard Prompt to BI ReportContent Hi, I know we can pass parameter from Dashboard Prompt to Analysis. I wonder if we can do it from Das…
-
How to Remove the HTML tag from the goal comments in BI ReportSummary How to Remove the HTML tag from the goal comments in BI ReportContent Hi Expert, How to Remove the HTML tag from the goal comments in BI Report Note: OTBI Report…User_2025-02-05-01-04-36-989 51 views 2 comments 1 point Most recent by User_2025-01-25-01-10-42-578 Reporting and Analytics for HCM
-
Why, using a RFT template it merge cells on Excel outcomeContent Hello, I did an RFT template for one report, and once I download the outcome in Excel it merge the cells. See screenshot. Do you know why?Nicola Petri 24 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Displaying an uploaded document stored as a blob in a BI Publisher report?Content We have a report request to display attachments that are uploaded by employees in a BI Publisher report. The uploaded attachments are stored as a blob and the ta… -
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, VisuVisu 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pivot tableContent I have created a pivot table for recognition against the business unit. I am trying to get a percentage of the number of employees who received a recognition aga…User_2025-02-06-11-18-47-896 36 views 4 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
First "Approved" Position RecordSummary SQLContent Hey guys. I'm trying to extract the first approved record's effective start date of all my active positions. I tried to use this in order to extract t…BenZionP 5 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
View Report Based On Legislative Data GroupSummary View BI Report Output Based On LDGContent Hi All, We have custom BI report which is using seeded data model to query. We would like to view report data based on …Ganesh Kokkula 33 views 2 comments 0 points Most recent by Ganesh Kokkula Reporting and Analytics for HCM -
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…User_2025-02-07-19-03-14-525 64 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 342 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.). Content Data model is based on the query pr… -
ETEXT Sort not working on two columnsSummary Sorting on two columns is not working for EtextContent I have a need to sort my ETEXT output using two columns. Per Oracle documentation, I should be able to use…Joe Roberts-Oracle 101 views 5 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM