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 – Query to Extract Business Object Attributes List
HDL – Query to Extract Business Object Attributes List If you’ve ever worked with HCM Data Loader (HDL), you’ll know how useful the Business Objects reference page is in the UI — it shows you the Name, METADATA Attribute, Data Type, Key Type, Required, Lookup, and Description for every attribute of a business object (see…
BIP – Query to extract Fast Formulas used in HCM Extracts
Use the below query to extract list of “Extract Rule Type” fast formulas used in Oracle HCM Extracts:
HDL – Person EFF Information loaded using HDL is not visible in UI
Many a times, even after loading Person EFF information successfully, using HCM Data loader, the information is not available in UI. In such cases, please make sure that following fields are passed correctly: InformationType – Name of extra information type e.g. ‘XYZ Medical History’ EFF_CATEGORY_CODE – EFF Category Context. For example, for person EIT, the…
BIP – Report Cannot Be Rendered Error
When designing BIP reports, sometimes the developer is encountered with “Report Cannot Be Rendered Error”. There can be various reasons of this error. The main reason behind this error is incorrect configuration. To resolve this issue for excel templates, make sure that there are no invalid references under Name Manager. Navigate to Formulas -> Name…
HDL – Sample file to upload Department DFF attributes
Sample file to upload/update/correct DFF values on department using User Keys:
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…