{"id":31205,"date":"2026-01-06T08:28:21","date_gmt":"2026-01-06T08:28:21","guid":{"rendered":"http:\/\/kovaion-new1.local\/oracle-bi-extract-employee-photo-using-dynamic-blob\/"},"modified":"2026-01-06T12:49:32","modified_gmt":"2026-01-06T12:49:32","slug":"oracle-bi-extract-employee-photo-using-dynamic-blob","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/oracle-bi-extract-employee-photo-using-dynamic-blob\/","title":{"rendered":"Oracle BI-Extract Employee Photo using Dynamic Blob"},"content":{"rendered":"

On a normal day for the HRBP, would not be nice for him\/her to have the Profile photo of all employees so it would be nice to communicate with them in personalized mail on inviting them for special occasions or recognize them for their brilliant efforts.<\/p>\n

But how they can extract all the Pic or documents of the employee? Via Oracle BI using Dynamic Blob.<\/p>\n

BI Publisher (Oracle Business Intelligence Publisher) is a powerful reporting tool. The one main unexplored update on BI Report includes pixel-perfect reports, interactive reports, and personalized documents. This capability empowers HRBPs to go beyond standard communication methods and establish deeper connections with employees. The combination of pixel-perfect reports, interactive elements, and personalized content elevates the quality of communication and engagement within the organization.<\/p>\n

In this blog, let us explore the scenario of generating a personalized document that is easy to use, including photos of the employees, and using the bursting feature to send them to the employees for their birthdays or anniversaries.<\/p>\n

 <\/p>\n

Here are the steps to generate a BI report for an employee profile using Dynamic Blob:<\/h3>\n

 <\/p>\n

STEP 1:<\/strong> To create a data model, Navigate Tools -> Report and Analytics.<\/p>\n

\"Report-and-Analytics\"
Fig.1: Report and Analytics<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

STEP 2:<\/strong> Click on CREATE in the Top Right corner, select \u2018Data Model\u2019, and Choose SQL Query Option.<\/p>\n

\"Creating-a-Data-model\"
Fig.2: Creating a Data Model<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

STEP 3:<\/strong> Write a SQL Query to get employee profile details from the PER_IMAGES table.<\/p>\n

\"Fetching-SQL-query\"
Fig.3: Fetching SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

STEP 4:<\/strong> When we run this SQL query, the Output will be shown as below.
\nWe must click on EXPORT to download the result in an XML File.<\/p>\n

\"Running-the-sql-query\"
Fig.4: Running the SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

STEP 5:<\/strong> Create an RTF template with the fields mentioned in SQL Query (Data Model).<\/p>\n

\"Creating-RTF-
Fig.5: Creating RTF Template For the data model<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

STEP 6:<\/strong> While creating the RTF file, Click on BI Publisher –> Sample XML –> Dialog box opens.<\/p>\n

Open the XML file downloaded by running the SQL query in STEP 4.<\/p>\n

\"Inserting-the-XML-file-to-RTF\"
Fig.6.1: Inserting the XML file to RTF<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"XML-file-insertion-successful\"
Fig.6.2: XML file insertion successful<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 7:<\/strong> Once the XML file is connected, we must add a table by using the table wizard and continue the process \u2013 select the fields to be displayed on the report.<\/p>\n

\"Preparing-the-template-with-the-fields-from-the-sql
Fig.7.1: Preparing the template with the fields from the SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Preparing-the-template-with-the-fields-from-the-sql
Fig.7.2: Preparing the template with the fields from the SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Preparing-the-template-with-the-fields-from-the-sql-query\"
Fig.7.3: Preparing the template with the fields from the SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Preparing-the-template-with-the-fields-from-the-sql-query\"
Fig.7.4: Preparing the template with the fields from the SQL query<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 8:<\/strong> Now the template is ready for the report generation.<\/p>\n

\"Template-created-for-report-generation\"
Fig.8.1: Template created for report generation<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Click on Field Browser, to give a syntax for the employee profile.<\/p>\n

 <\/p>\n

\"Inserting-syntax-for-employee-profile\"
Fig.8.2: Inserting syntax for employee profile<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 9:<\/strong> This is the last column that we want to display as an image. So, we must use a syntax called \u201cfo: instream.\u201d<\/p>\n

\"Adding-syntax-to-display-in-Image\"
Fig.9: Adding syntax to display in Image<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 10:<\/strong> Now the generated RTF layout file needs to be uploaded.<\/p>\n

\"Uploading-RTF-file\"
Fig.10: Uploading RTF file<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 11:<\/strong> While uploading the layout file, we must fill in the layout name, choose an RTF template specify the type given as \u2018RTF\u2019 template, and choose locale as \u2018English\u2019.<\/p>\n

\"Setting-up-RTF-file-type-and-file-name\"
Fig.11: Setting up RTF file type and file name<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 12:<\/strong> Once the RTF layout is uploaded, the data model needs to be linked with the report.<\/p>\n

\"
Fig.12: Linking data model with the RTF layout<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Step 13:<\/strong> Once the data model is linked, clicking on \u2018View Report\u2019 gives us the BI Report with Dynamic BLOB Image.<\/p>\n

\"Viewing-the-BI-Report-with-dynamic-BLOB-image\"
Fig.13.1: Viewing the BI Report with dynamic BLOB image<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

\"Viewing-the-BI-Report-with-dynamic-BLOB-image\"
Fig 13.2 Viewing the BI Report with dynamic BLOB image<\/strong><\/figcaption><\/figure>\n

 <\/p>\n

Bottom Line:<\/h3>\n

Oracle BI’s dynamic BLOB extraction empowers HRBPs to enhance communication, engagement, and recognition. Integrating employee profile photos into personalized documents allows for stronger connections, milestone celebrations, and improved satisfaction. This, coupled with Oracle BI Publisher’s features, transforms HR engagement by fostering appreciation and connectivity. The ability to generate personalized documents with photos and the bursting feature strengthens employee-organization bonds. This innovative approach through Oracle BI offers HRBPs new avenues to inspire, engage, and create a vibrant workplace.<\/p>\n

 <\/p>\n

Author<\/strong>: Gowri Perumal, Oracle Fusion Consultant<\/p>\n","protected":false},"excerpt":{"rendered":"

On a normal day for the HRBP, would not be nice for him\/her to have the Profile photo of all employees so it would be nice to communicate with them in personalized mail on inviting them for special occasions or recognize them for their brilliant efforts. But how they can extract all the Pic or […]<\/p>\n","protected":false},"author":1,"featured_media":24951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-31205","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=31205"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31205\/revisions"}],"predecessor-version":[{"id":31206,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31205\/revisions\/31206"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/24951"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=31205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=31205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=31205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}