How to access flexfields in OTBI Subject Areas?

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…

Continue ReadingHow to access flexfields in OTBI Subject Areas?

Importance of Update Person Search Keywords Process

In this article we will look into the process to update the search keywords table which is used as search for most of the search pages in Fusion. How person keywords are updated?Why do you run the Update Person Search Keywords process?How to schedule the Update Person Search Keywords process? How person keywords are updated?Several attributes of person, employment, and…

Continue ReadingImportance of Update Person Search Keywords Process

Basics of Flexfields in Fusion HCM

In this article we will look into the basics of Flexfields, types of it and their usage. What is a Flexfield? Types of Flexfields Differences between types of FlexfieldsHow to find the flexfields available on a Business Object?List of Flexfields available for HCM  What is a Flexfield? Flexfields are placeholder fields associated with a specific business object. They’re designed for customers to…

Continue ReadingBasics of Flexfields in Fusion HCM

Enabling Audit for Business Objects in Fusion Applications

In this post we will try to understand how to use the Audit feature in Fusion Applications.- What is Audit?- How to enable audit functionality?- Privileges required in order to setup the Audit Functionality- How to use Audit Reports?- Technical Details of Audit tables What is Audit?WHO has changed WHAT and WHEN. if we get the answer for these questions,…

Continue ReadingEnabling Audit for Business Objects in Fusion Applications

Table Naming Convention in Fusion Applications

  • Post category:Others
  • Post comments:0 Comments
  • Post last modified:January 22, 2021
  • Reading time:5 mins read

We have many tables in Fusion and we need to understand their naming conventions in order to find out the right table that we need to refer to. _B these are the BASE tables. They are very important and the data is stored in the table with all validations.Ex:HR_DOCUMENT_TYPES_B _F these are date tracked tables, which occur in HR and Payroll. For these…

Continue ReadingTable Naming Convention in Fusion Applications

Using Session Variables in BI Reports to get logged in user info

  • Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:January 22, 2021
  • Reading time:2 mins read

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…

Continue ReadingUsing Session Variables in BI Reports to get logged in user info

How to modify XML tags in BI Publisher Output?

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:January 22, 2021
  • Reading time:4 mins read

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…

Continue ReadingHow to modify XML tags in BI Publisher Output?

Execute Reports from Navigator without exposing the BI Catalog

  • Post category:BI Publisher
  • Post comments:5 Comments
  • Post last modified:January 22, 2021
  • Reading time:3 mins read

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…

Continue ReadingExecute Reports from Navigator without exposing the BI Catalog

SQL to fetch 200+ rows – Direct Database Query – Obsolete

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…

Continue ReadingSQL to fetch 200+ rows – Direct Database Query – Obsolete