Learning Fusion HCM Technical Skillset

  • Post published:April 30, 2020
  • Post category:Others
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
Learning Fusion HCM Technical Skillset
Learning Fusion HCM Technical Skillset

Do you want to learn Fusion HCM Tools like HCM Data Loader, HCM Extracts, PBL, Fast Formula, Security, OTBI, Personalizations, Scheduled processes? Have a look at this article.

Continue Reading Learning Fusion HCM Technical Skillset

SQL Query to fetch Supervisor Direct and Indirect reportees

  • Post published:April 30, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
SQL Query to fetch Supervisor Direct and Indirect reportees
SQL Query to fetch Supervisor Direct and Indirect reportees

In this article we will look into getting in the Direct and Indirect reportees of a Supervisor using SQL Query. We assign the Supervisor on the Employment screen and they get stored in the PER_ASSIGNMENT_SUPERVISORS_F table. We will have to join the PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. However Fusion has a scheduled…

Continue Reading SQL Query to fetch Supervisor Direct and Indirect reportees

SQL Query to fetch IP Ranges setup for LBAC

  • Post published:April 29, 2020
  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
SQL Query to fetch IP Ranges setup for LBAC
SQL Query to fetch IP Ranges setup for LBAC

Do you want to query the LBAC IP Ranges setup for LBAC using BI Publisher Report? It will be handy for the security administrator to validate and cross check the IP list.

Continue Reading SQL Query to fetch IP Ranges setup for LBAC

Creating Excel templates and troubleshooting them

  • Post published:April 29, 2020
  • Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:June 12, 2020
Creating Excel templates and troubleshooting them
Creating Excel templates and troubleshooting them

Have you created Excel templates to get the excel output? Do you know the pros and cons of excel templates? If you face any issues do you know how to troubleshoot them?

Continue Reading Creating Excel templates and troubleshooting them

Fix for BI reports generating stale/old data due to Cache options

  • Post published:April 28, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
Fix for BI reports generating stale/old data due to Cache options
Fix for BI reports generating stale/old data due to Cache options

Do you know why the BI caching is used? If you don't know the BI Caching settings, you might end up getting old/stale data. Read through this article to know the caching settings and their importance.

Continue Reading Fix for BI reports generating stale/old data due to Cache options

Limitations/issues faced with LBAC

  • Post published:April 28, 2020
  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
Limitations/issues faced with LBAC
Limitations/issues faced with LBAC

Do you know the limitations/issues faced with LBAC feature? Are you using LBAC and facing these issues too? Check out this article to get your questions clarified.

Continue Reading Limitations/issues faced with LBAC

Test/Preview/Troubleshoot eText templates

  • Post published:April 28, 2020
  • Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:July 1, 2020

Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the output? Check out this article to get your questions clarified.

Continue Reading Test/Preview/Troubleshoot eText templates

How to disable Single Sign-on or LBAC option?

  • Post published:April 27, 2020
  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
How to disable Single Sign-on or LBAC option?
How to disable Single Sign-on or LBAC option?

Do you know what is LBAC (Location Based Access Control)? Do you know how to turn it off when you run into any issues? Have a look at this article to know more details.

Continue Reading How to disable Single Sign-on or LBAC option?

Using Role Mappings and Auto-provisioning Rules

  • Post published:April 27, 2020
  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
Using Role Mappings and Auto-provisioning Rules
Using Role Mappings and Auto-provisioning Rules

Do you know what are Role Mappings, How they are configured and how the auto provisioning process works? have a look at this article to find out.

Continue Reading Using Role Mappings and Auto-provisioning Rules