All posts on BI Publisher

SQL Query to find the Position Incumbents

  • Post published:July 24, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:July 24, 2020
SQL Query to find the Position Incumbents
SQL Query to find the Position Incumbents

Do you know how to build query to find out the Position Incumbents? Position Incumbents are nothing but the employees hired into the Position. Read on to know more details.

Continue Reading SQL Query to find the Position Incumbents

SQL Query to find pending approval transactions from Workflow tables

  • Post published:June 26, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
SQL Query to find pending approval transactions from Workflow tables
SQL Query to find pending approval transactions

Have you used the approval related tables to fetch the In Progress/Approved/Withdrawn transactions? Can you do another transaction on the business object which has an in process approval? Read on to know more details.

Continue Reading SQL Query to find pending approval transactions from Workflow tables

List of functions available in per_extract_utility package

  • Post published:June 18, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 18, 2020
List of functions available in per_extract_utility package
List of functions available in per_extract_utility package

Do you know the list of available functions in per_extract_utility seeded pl/sql package? These functions can be used in sql query to avoid unnecessary joins to tables. Read on to know more details.

Continue Reading List of functions available in per_extract_utility package