Enabling Location Based Access Control (LBAC)

  • Post category:Security
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:6 mins read

Oracle has recently introduced the Location Based Access Control as known as LBAC in Oracle HCM Cloud from 19D. By default this feature will be disabled. In this article we will look at enabling the LBAC option and the benefits of it. What is LBAC?LBAC means Location Based Access Control and it is used to control the access of the…

Continue ReadingEnabling Location Based Access Control (LBAC)

Introduction of Cloud Customer Connect Forum

  • Post category:Others
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:4 mins read

Many of you might already know about the Cloud Customer Connect and it's usage. This post is for those of you who don't know about it and how you can take advantage of it to gain knowledge and solve your issues. Why Cloud Customer Connect?Cloud Customer Connect is a forum by Oracle which is specific to Cloud products (HCM/ERP/SCM/OIC/PAAS/CX/IAAS/Students). Oracle…

Continue ReadingIntroduction of Cloud Customer Connect Forum

Importing Changes Only HCM Extract post 20A update

  • Post category:HCM Extract
  • Post comments:6 Comments
  • Post last modified:June 12, 2020
  • Reading time:2 mins read

When we migrate the HCM Extracts to other PODs, we normally export the HCM Extracts from Source instance and Import them to the Target instance. However there has been some changes from 20A which needs to be considered while importing the HCM Extracts, else the changes only functionality won't work for imported extracts. From 20A, Oracle has added an "Incremental"…

Continue ReadingImporting Changes Only HCM Extract post 20A update

Redesigning PBL to HDL Transformation Formula

  • Post category:Fast Formula
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:2 mins read

As we all know that PBL (Payroll Batch Loader) is getting decommissioned by Oracle from 20C release. Client PODs are currently on 20A and some of them are getting 20B on their TEST PODs now. So in another four months from now, the 20C would be available and with it the PBL era would end. For the new clients provisioned…

Continue ReadingRedesigning PBL to HDL Transformation Formula

List of tables which are impacted by Scheduled Processes

We normally run many Scheduled Processes in fusion. some of them to keep the users in sync, updating the search keywords, sending pending ldap requests, refresh manger hierarchy, etc to name a few. If you are really interested in finding out the underlying tables which gets impacted by these processes, you can run the below query immediately after the process…

Continue ReadingList of tables which are impacted by Scheduled Processes

How to get the Payroll Balance details in BI Report?

  • Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:June 12, 2020
  • Reading time:2 mins read

If the client has implemented Payroll, we have a common requirement to pull the balances in BI Report multiple times as part of third party integrations. Getting the Payroll Balance requires calling the balance package and providing the right inputs. Many of us get it wrong in writing the balances query and find it difficult to achieve it. Here is…

Continue ReadingHow to get the Payroll Balance details in BI Report?

Bursting attachment to Email along with html content in body

  • Post category:BI Publisher
  • Post comments:4 Comments
  • Post last modified:June 16, 2020
  • Reading time:2 mins read

Normally when we burst the BI Reports we either do the html bursting so that the content will appear in the email body or burst with an attachment so that the end user can open the pdf and view it. However if there is a requirement to combine both of them, then we can use the below bursting SQL: select…

Continue ReadingBursting attachment to Email along with html content in body

New features in HCM Extracts in 19B release

  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:3 mins read

We will look into the new features introduced in 19B for HCM Extracts. Oracle has completely revamped the User Interface for HCM Extracts. Below are the features that have been added: We can add multiple Database Items at one go by selecting the DBIs and clicking on Add button. We would get the XML tag as the DBI name. Most…

Continue ReadingNew features in HCM Extracts in 19B release

Configure GMFZT logging for an HCM Extract

  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:2 mins read

In this post we will look into setting up the GMFZT logging for HCM Extracts. This logging will show the diagnostic results of extract run in the log file, which will be internally used by the Oracle team to look into issues if we raise an SR for HCM Extract issues. We can setup the logging using the task "Manage…

Continue ReadingConfigure GMFZT logging for an HCM Extract