SQL Query to fetch Bank, Branches and External Bank Accounts
Do you know how to extract the Banks, Bank Branches and External Bank Accounts? Read on to know more details.
All posts on BI Publisher
Deep Links and their usage in BI/OTBI Reports
Do you know how Deep Links work and what are the advantages of them? Can you use the Deep Links on BI/OTBI Reports? Read on to know more details
SQL Query to find changes within a specific timeframe
List of Functions to convert date to a different timezone and use them in SQL Query to get the required information. Read on to know more details.
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.
Deleted Data Report using Audit Functionality
Do you know that you can fetch deleted data for business objects in Fusion if Auditing is turned ON? Read on to know more details.
SQL Query to find pending approval transactions from Workflow tables
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.
Access contents of UCM file using BI Report
Do you know that you can get the contents of the text files uploaded to UCM in BI Report? Read on to know more details.
Get the info of Attachments loaded to UCM
Do you know how to get the documents information that have been uploaded to UCM using SQL Query? Read on to know more details.
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.
Auto Fit Contents in Excel output with RTF template in BIP
Do you know how to set dynamic width for columns in excel output using RTF template? This works along with keep values in same column setting. Read on to know more details.