Most of the customers want to know the list of users who logged in to Fusion Applications and want to encourage other employees too to use the Fusion system. For this, the customer needs to generate a report with the list of users who have logged in within a period of time like last 30days or on specific date or…
In this article we will see how to access the Flexfields in OTBI subject areas. If you are new to flexfields then check this article to get basics of flexfields Flexfields Introduction When we create flex field segments, there is an option to have them enabled in BI, if we enable that check box, then the segments can be accessed in…
If you have a requirement to fetch the flattened organization hierarchy tree you can use the SQL in this article to get the information.
Session variables are used frequently in BI Publisher when the reports are being exposed to employees to add data security on top of the existing query. We need to write query to pull only the logged in user information and for this we will use the session variable. Apart from this user, there are many other session variables and we…
There could be scenarios where in the client needs the report output in XML format and that XML file will be sent to some third-party vendor and it will be imported to their legacy systems for other processing. And the vendor might expect the XML file with some pre-defined tags for the attributes for them to process the files and…
In most of the cases, Employees will not have access to Reports and Analytics to access the reports. However if there is a requirement to create a report and provide access to employees, giving access to Reports and Analytics might expose other reports or seeded reports too, hence it is not a wise decision to provide access to BI Catalog.We…
This article is obsolete now as Oracle removed Direct Database Query option. Please check out the alternative to run adhoc queries. https://fusionhcmknowledgebase.com/2020/09/sql-developer-like-tool-for-oracle-cloud-for-free/ When we create a Data Model using SQL Query, the max number of rows that we can fetch using the Data Model is only 200 rows unless we create a layout, tag it to data model and run…
For every implementation, there would be functional consultant who looks into the security and their job is to create a security matrix with all users list and their roles mapped on to a sheet. It would be tough to create this sheet manually when there are 1000's of employees and it doesn't make any sense to do it manually.In order…
How to add hyperlink to email body message using bi publisher bursting? Have a look at this article to know more information.
