BI Publisher
Discussion List
-
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 35 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 61 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 348 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 111 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 80 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 378 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 33 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 32 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 724 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 44 views 2 comments 2 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…User_2025-12-05-01-24-53-219 17 views 2 comments 0 points Most recent by User_2025-12-05-01-24-53-219 Reporting and Analytics for HCM
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna Chidella-Oracle 53 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 39 views 3 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1.1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM
-
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 155 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 282 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Restrict access to Reports and Subject areaContent Good day, everyone! Could you please tell me if there is an option to restrict access to reports based on roles? I also wondering if is possible to restrict acce…Kristina Serikova 41 views 2 comments 2 points Most recent by Kristina Serikova Reporting and Analytics for HCM -
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 109 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM