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_name
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_name
In Oracle Learning Cloud, a specialization can be created as a combination of multiple sections with each section comprising of multiple courses. A learning admin can setup the specialization by navigating to My Client Groups -> Learning -> Learning Catalog -> Specializations: Example: Use the below query to get the above details:
Default Assignment Rules like Validity Period, Expiration, Renewal Options, Renewal Period etc are maintained at the course level in Oracle Learning Cloud. These details are stored in the backend table ‘WLF_ASSIGNMENT_RULES’. The query from below post can be joined with WLF_ASSIGNMENT_RULES using ASSIGNMENT_RULE_ID column: https://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-assignee-details-for-a-course/?amp and warf.ASSIGNMENT_RULE_ID = war.ASSIGNMENT_RULE_ID And you will get the required output.