BIP – Extract list of counties for GB
Below SQL can be used to extract list counties configured for GB in HCM:
SELECT *
FROM fusion.hz_geographies hg
WHERE hg.geography_type = 'COUNTY'
AND country_code= 'GB'
ORDER BY geography_nameSimilar Posts
Configuration – Employee Location on Location Details page
Starting 22A, Oracle introduced a new field called “Employee Location”. https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/ghr/releases/22A/22A-hr-wn.htm#F21144 Any locations for which the value of the field will be selected as “Yes”, will be only available to be used in Manage Employment screen. This is a great feature to segregate locations which can be used on employee assignments vs locations which are…
- Configuration | HDL | Reports
BIP – Query to get Configure HCM Data Loader parameters
Configure HCM Data Loader is a task that is used to define the HCM Data Loader parameters. The parameters are broadly divided into following categories:- Availability, Diagnostic, File Definition, Performance and Scheduling Default. These are the default settings which are applied to any HCM Data Load. You can override some of these parameters at the…
Reports (BIP) – Customizing a standard BIP report
Many a times, consultants are required to modify the standard BIP reports. This is very much applicable in case of workflow notifications which are based on BIP reports. Both data model as well report can be customized to include/exclude any additional fields. Follow the below steps: Login to your pod using below url: https://xxzzaa.fa.bb.oraclecloud.com/xmlpserver/ (note…
BIP – Query to find legal entity registration number
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…
HDL – Source values for Candidate HDL
When loading Candidate data using HDL, the values of Source attributes (Source and Source Medium) are required. These values are configured in UI using task ‘Manage Candidate Dimension Source Names’. Use below SQL to get the values:
BIP – Configure SFTP using private key for Authentication
In this article, we will see how to setup an SFTP server which will use private key for authentication. First step is to obtain the private key. Once you have the key, login into Oracle Fusion Application Analytics and click on Administration link on the right top side: Click ‘Manage BI Publisher’ under BI Publisher…