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…
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…
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"…
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…
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…
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…
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…
Are you aware of the mandatory scheduled processes that you need to run post data loads? Do you know the list of key scheduled processes?
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…
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…
