Password Protect Excel Output in BI Publisher

  • Post published:February 26, 2019
  • Post Category:BI Publisher
  • Post Comments:3 Comments
  • Post last modified:May 12, 2020

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:May 12, 2020

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:2 Comments
  • Post last modified:May 12, 2020

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