Password Protect Excel Output in BI Publisher

  • Post published:February 26, 2019
  • Post category:BI Publisher
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
Password Protect Excel Output in BI Publisher
Password Protect Excel Output in BI Publisher

One of the missing piece in BI Publisher earlier was the password protection for Excel 2007 Output and it has been introduced in 18c update. Earlier password protection was possible for PDF output only and there have been a number of bugs and enhancements pending around the feasibility for password protection for Excel Output. And finally Oracle has worked on…

Continue Reading Password Protect Excel Output in BI Publisher

SQL Query to get Geography Information

  • Post published:February 12, 2019
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
SQL Query to get Geography Information
SQL Query to get Geography Information

In this article we will look into getting the Country, State, County, City and Zipcode information from backend tables. These queries will be handy when there is a requirement to get the Country Name, State Names etc apart from the Country Code and State Code which are present in most of the address tables. Countries:SELECT TERRITORY_CODE ,TERRITORY_SHORT_NAME ,CURRENCY_CODE ,DESCRIPTIONFROM FND_TERRITORIES_VLWHERE…

Continue Reading SQL Query to get Geography Information

Dynamic Date Parameters in BI Report

  • Post published:February 8, 2019
  • Post category:BI Publisher
  • Post comments:1 Comment
  • Post last modified:June 12, 2020
Dynamic Date Parameters in BI Report
Dynamic Date Parameters in BI Report

For most of the BI Reports we have the input parameter as "AsOfDate" alias sysdate or current date... Sometimes we also have a date range "From Date" and "To Date" to fetch transactions between those dates. And these dates need to have a default value when we open the report/schedule the report.  Want to learn Fusion Technical tools go through this…

Continue Reading Dynamic Date Parameters in BI Report

SQL Query to get Supervisor Change HDL for Assignment

SQL Query to get Supervisor Change HDL for Assignment
SQL Query to get Supervisor Change HDL for Assignment

Do you know how to create the supervisor update HDL file using SQL Query? Within a few minutes you will be able to update supervisor for a bunch of employees. Read on to know more details.

Continue Reading SQL Query to get Supervisor Change HDL for Assignment