BI Publisher
Discussion List
-
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 40 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 310 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 37 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 40 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 26 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 63 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 32 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 52 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 26 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…Karen Costakes 41 views 3 comments 1 point Most recent by Karen Costakes Reporting and Analytics for HCM -
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 31 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 65 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 313 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 86 views 5 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Audit reportContent Hello Team, We have embedded the BIP report as a link for employee in Fusion HCM page,each employee can access the report in one country so, is it possible to cr…User_2025-01-30-19-06-42-738 81 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 316 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM
-
Can we create the output as .txt file in analysisSummary Can we create the output as .txt file in analysisContent i have created a analysis to fetch the assignment number for all the employees.but we need the output as…User_2025-02-05-02-11-29-794 34 views 8 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM
-
End Dated Scheduled ProcessesSummary End Dated Scheduled ProcessesContent Hi Team, We have observed some of the scheduled process got stopped in our production environment. this might be due to end …nitin Sharma 33 views 4 comments 2 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal pSummary Query/ Table information Required for FYI notification (When manager add new Goal to reportee goal plan, FYI notification get triggered)Content Hi Expert, Query/…
-
User behavior and AnalyticsSummary Is there a BI table which captures information on user behaviorsContent Our customer is looking for information on user behavior - which Fusion page is being use…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …User_2025-02-10-16-28-01-402 664 views 2 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Reporting HCM Catalog Group and Folder PermissionSummary Creating report to get the list of accounts under Catalog GroupsContent Hi All, I know that we can able to report within OBIEE Reports by creating Data Source. W…User_2025-02-04-07-19-57-588 46 views 2 comments 2 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM