-
-
HDL – Sample file to load Talent Profile data
In the enhanced profiles (Profile V2), for bulk upload, one has to use TalentProfile.dat file as earlier. However while loading profile items against a profile, a new attribute SectionId should be provided. SectionId is based on the content item being used. Check the below post on how to get section id: https://fusionhcmconsulting.com/2021/02/hdl-query-to-find-sectionid-for-talent-profile-item-load/ Below is the…
-
Reports (BIP) – Query to get learning outcomes
Oracle Learning Cloud supports to define learning outcomes against each course as shown in below fig: For reporting and integration purposes, there is a need to extract the learning outcomes assigned against each course. Learning outcomes are stored as profile relationship against each course. Below query can be used to extract the asked data:
-
Lookups – Mass Upload Lookup Types
Lookups are commonly used across modules in SaaS. Sometimes, the number of lookups is so much that it takes lot of time and effort to create them manually in the application. Oracle SaaS supports bulk upload of both lookup types and lookup codes. In this post, we will see how to make use of file…
-
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 ->…
-
Reports (BIP) – Query to find module type and key
While defining Common Lookups or value sets, you need to provide module value. Each module has an associated module type, module key and product code associated with it. For example: These details are stored in backed in a table – FND_APPL_TAXONOMY. Use the below query to find module type, module key etc for a module:
-
Lookups – Mass Upload Lookup Values
Lookups are used commonly to meet different requirements. Many a times, lookup values easily go past hundred values, in such case adding the values one by one into the lookup is very tedious and error prone job. There is no HDL support to bulk upload the lookup values. However, a file based solution is available…
-
Data Masking – Mask Salary Data in lower environment
There is a common requirement to mask salary data post P2T refreshes. This should be done in order to hide the actual salaries information as salary is a very sensitive information. Use the below query to generate data in HDL format in a test environment immediately after P2T refresh. The below query generate a random…
-
-