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
HDL – Refresh Business Objects
Refresh Business objects is a process which is used to create the HDL template for a business object with the latest supported attributes. When to run ‘Refresh Business Objects’ process: It is advised to run this process: After every upgrade After any new DFF/EFF attributes are configured for any HDL supported business objects. How to…
BIP – Extract Address Style Format Information
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…
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…
HDL – Sample file to close benefit certifications
Starting 23C, a new HDL object has been added to close any pending actions for benefits. The certification type is validated against a lookup called – BEN_ENRT_CTFN_TYP Below is a sample file to close any pending certification actions against “POC”:
HDL – Sample File to Load extended Lookup Codes
Oracle HCM makes use of extended lookups feature to support dependent lookup values. For example, while creating a VISA or Work Permit record for a Person for Singapore, the Category field is dependent upon Type of the pass chosen. The values of Category field are derived from Extended lookup. Navigate to Setup and Maintenance ->…
REST API Error – The specified operation is not supported for the invoked HTTP method
Many a times while trying to use Post method using REST API, we encounter – ” The specified operation is not supported for the invoked HTTP method. Please check the URL and the headers.” Cause of this error is incorrect header parameters/ missing header parameters while making a call to REST API. To fix the issue:…