BIP – Query to find legal entity registration number in fusion – MSPL Home › Fusion HCM › Reports › Overview In Oracle Fusion HCM, each Legal Entity is assigned a registration number that uniquely identifies it within a Payroll Statutory Unit. This registration number is stored at the establishment level and linked via the…
In Oracle Fusion HCM, a business unit can be linked to either a common reference data set or a specific one. When associated with a specific reference data set, the business unit gains access to departments defined within that set, as well as those available in the common reference data set. The SQL query provided…
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
I have designed below query to extract the schedule of a BIP submitted jobs which is not available directly. Replace the job name attribute with your job name or run it for all:
There is a common requirement to send encrypted output files to UCM server as part of outbound integrations in Fusion HCM. By default, FA_UCM_PROVISIONED is delivered as ‘Content Server’. But the delivered content server, doesn’t have the encryption enabled and there is no option to enable encryption on the delivered content server. So, the solution…
Below SQL query below shows how a job name can be pulled for a worker’s manager. The SQL can be easily modified to include further employment related attributes for worker’s line manager.
Alert composer a very powerful and useful tool to configure and sent notifications to the users. However, it is very important for business to know the list of receipients for each message. I have tried to built a query to get these details. From alert history, one can find the emails triggered but it doesn’t…
List of all job families not associated with a Job:
With the security concerns regarding access to Oracle HCM applications, I have seen many customers asking for a way to restrict access to a particular DEV/TEST environment having unmasked data. One option in such scenario’s is to keep only the admin user accounts active in the particular environment and deactivate all other user accounts. This…
Use below SQL to get benefits relationship name and status for a worker:
Many a times when the reports are delivering the content to UCM server, we get below error: In this case look at the password for account used to connect to UCM server. If the password is reset make sure it is updated at the UCM connection as well.
You use “Manage Address Formats” task from Setup and Maintenance to define the address style for a particular country. Oracle provides a lot of address format for various countries out of the box. You have the capaibility to customize the address formats as per customer requirement. For example, you can search for all available address…
There can multiple grades assigned as Valid grade at Position level or Job level. However, there is no direct way to end date the valid grades in bulk. You can end date a valid grade from responsive UI. But it will be a lot of manual effort. You can search for Position and then navigate…
You can attach multiple adjustment reasons on accrual plan level. You can create any new custom adjustment reasons and add them in a lookup – ANC_ABS_PLAN_OTHER_REASONS. Once the reason is added in the lookup, you can navigate to Absence Plans. You can choose the newly added lookup code under “Enteries and Balances” tab. Once the…
Learning admin can attachments on offering level for different roles – Admin/ Employee etc. In case, you need to extract the attachment details for an offering, below BIP can be used: Output:
While defining absences, schedule hierarchy start point can be defined to tell the system from where to pick the working days for a person. Once the values are defined, you can use below query to validate if setup has been defined correctly:
Once a worker record is terminated, it is expected that the associated user account will get inactive. However, it depends upon the configuration on Enterprise Level and auto provisioning rules setup. If there is even on role assigned to user name, the user account will not get terminated in HCM. To help the business to…
