Display Person Image on BI Report
Do you know how to display Employee's image on the BI Report? Images are stored as BLOB files, then how can we display them? Read on to knore more details.
All posts on BI Publisher
Fix for assertion failure error in HCM Extracts
Have you faced the error "An assertion failure was detected at location ProcReportPayAct.childRequestStatus:1" in HCM Extracts? Do you know how to resolve it in a couple of steps? Read on to know more details.
Creating Zipped PDF file output from BI Report
Do you want the output of BI Publisher in zipped format? Do you think it is possible in Fusion? Read on to know more details.
Hiding input parameters on BI report
Do you know how to hide input parameters on BI Report even though the Data Model has multiple input parameters? Read on to know more details.
Fix for SQL query time out error in BI Reports
Do you know how to resolve the SQL query time exceeds limit of 500 sec issue? Do you know the SQL pruning feature? Read on to know more.
SQL Query to fetch employee person and assignment info
Do you know what all tables are involved in creating an employee master report with personal and assignment data? Read on to know more details
SQL Query to fetch Supervisor Direct and Indirect reportees
In this article we will look into getting in the Direct and Indirect reportees of a Supervisor using SQL Query. We assign the Supervisor on the Employment screen and they get stored in the PER_ASSIGNMENT_SUPERVISORS_F table. We will have to join the PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. However Fusion has a scheduled…
Creating Excel templates and troubleshooting them
Have you created Excel templates to get the excel output? Do you know the pros and cons of excel templates? If you face any issues do you know how to troubleshoot them?
Fix for BI reports generating stale/old data due to Cache options
Do you know why the BI caching is used? If you don't know the BI Caching settings, you might end up getting old/stale data. Read through this article to know the caching settings and their importance.
Test/Preview/Troubleshoot eText templates
Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the output? Check out this article to get your questions clarified.