Password Protected BIP Report Output (Part-1)

We fetch data from fusion by creating reports in required format.
But there are scenarios where we need to generate a password protected output. There is option in fusion where we can generate password protected output using BIP report which can be dynamic or static. In this article, we will see steps involved in creating Static Password output.

I have already created a sample BIP report for this article which fetches personal details of employees and default output is PDF. By default reports are not password protected.

We will follow below steps to enable the static password protected output.

1) Edit the report and follow the below navigation

Properties>Formatting>PDF Output

2) Select value as "True" for "Enable PDF Security".

3) Enter Password for field "Open document password".

4) Click on Ok and Save. Report will open as below:

5) Enter the password which have been entered in step 3 and report will open as below:

The same steps can be performed for Excel output for password.

Hopefully , this will be helpful.

Comments

Dynamic Password Protected report output (Part 2)

This post is in continuation of Password protected report output (Part 1) post where we discussed about generating the static password protected output. In this post we will go through steps to have dynamic password protected report output. This is a common requirement when a company send offer letter, payslips, appraisal letter etc in HCM. We might have also similar requirement when we send some bills to users. Let's go through the required steps to enable the password protected report output. 1) Create a SQL Data Model which should have one column password like below query have NID : Note: We can have combination of one or more than one column as password. 2) Create a report for which we have to create a RTF template. While creating the RTF template we need to setup word properties to enable the password for PDF. Please follow the navigation: File > Info > Advance Properties > Custom 3) Add the below two properties: Name Valu...

Loading External Bank Account Using HDL

There are general requirements for loading the External Bank Account for employees during the project implementation which will be used either for expenses or Payroll. Let's go through the pre-requisite and steps for loading the External bank account using HDL Pre-Requisite: There is pre-requisite to generate party id before loading the External Bank Account. 1) We need to run the " Synchronize Person Records " scheduled process by entering the details: This process should generate the Party Id for employee which have been migrated using HDL. 2) If Party Id is still not generated even after running the above process then run the " Maintain Party and Location Current Record Information " This process should generate the Party Id for employee which have been migrated using HDL. Once the Party Id is generated run Load the External Bank Account HDL file. Below is sample ExternalBankAccount.dat file: METADATA|ExternalBankAccount|BankNumber|BankName|BankBranchNumbe...

Automatic Calculation of FTE while HDL Worker Load

Full-time equivalent (FTE) is an important component when we load worker data in Oracle fusion using HCM Data Loader(HDL). F ull-time equivalent (FTE) value gets calculated by diving the assignment normal working hours by standard working hours of employee. You can refer Loading Worker object using Fusion HCM Data Loader(HDL) article to see steps to load worker. During the migration, we can either migrate the FTE using the AssignmentWorkMeasure Metadata of Worker file from the legacy system or we can request FTE to be calculated automatically. We will see how can request FTE to be calculated automatically while doing the Data Migration. We need to include the following instruction in Worker.dat file to calculate FTE automatically while loading worker. SET CALCULATE_FTE Y; Worker file will look like as below: Once this file gets loaded the FTE of employee will be automatically calculated. Please see the screenshot of employee from UI We had not pa...

SAS-FUSION

Search This Blog