You can make use of HCM Data Loader to upload Succession Plans (Incumbent, Job and Position Types). Use the below sample file to load Succession Plans: Once the data is loaded, you can run the query to check loaded plans in HRM_PLANS table.
There is a frequent requirement of using a parameter in HCM Extracts which can accept multiple comma separated values. For example, in Worker Extract, we need to have a Parameter called PER_NUMBER which should accept multiple comma separated values. To split the input values, we can use REGEXP_SUBSTR function.
Use below query to extract files loaded through Tools -> File Import and Export along with UCM Content ID and the account used:
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…
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:
Organization.dat can be used to upload work day information at department level. METADATA|OrgInformation|OrgInformationContext|SequenceNumber|FLEX:PER_ORGANIZATION_INFORMATION_EFF|EFF_CATEGORY_CODE|EffectiveStartDate|EffectiveEndDate|OrganizationName|ClassificationName|_STD_WORKING_HOURS(PER_ORGANIZATION_INFORMATION_EFF=PER_WORK_DAY_INFO)|_STD_WORKING_HOURS_FREQUENCY(PER_ORGANIZATION_INFORMATION_EFF=PER_WORK_DAY_INFO)|_STD_WORKING_HOURS_FREQUENCY_Display(PER_ORGANIZATION_INFORMATION_EFF=PER_WORK_DAY_INFO)|_WORK_END_TIME(PER_ORGANIZATION_INFORMATION_EFF=PER_WORK_DAY_INFO)|_WORK_START_TIME(PER_ORGANIZATION_INFORMATION_EFF=PER_WORK_DAY_INFO)|OrganizationIdMERGE|OrgInformation|PER_WORK_DAY_INFO|1|PER_WORK_DAY_INFO|DEPARTMENT|1951/01/01||XYZ Markets|Department|40|W||18:00|09:00|5000000026311 Please verify the updated information from UI: Validate Version – 21A
HCM Data Loader can be used to bulk upload worker unions. In Cloud HCM, Worker Unions are just another type of Organization. You can run below query to find different Organization Types and their codes: https://fusionhcmconsulting.com/2021/01/reports-bip-organization-classifications-in-fusion/ Below is the sample file to inactivate a worker union: METADATA|Organization|OrganizationId|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|ClassificationName|InternalAddressLine|ActionReasonCode|LocationSetId|LocationCode|LocationSetCode|EstablishmentId|EstablishmentName|GUID|SourceSystemOwner|SourceSystemIdMERGE|Organization||1951/01/01|2021/05/12|Test WU2|ORA_PER_UNION||||||||||FUSION|300000217254520MERGE|Organization||2021/05/13|4712/12/31|Test WU2|ORA_PER_UNION||||||||||FUSION|300000217254520 METADATA|OrgUnitClassification|OrgUnitClassificationId|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)|OrganizationName|ClassificationCode|ClassificationName|CategoryCode|SetCode|Status|LegislationCode|GUID|SourceSystemOwner|SourceSystemIdMERGE|OrgUnitClassification||1951/01/01|2021/05/12|300000217254520|Test WU2|ORA_PER_UNION||||A|IN||FUSION|300000217254521MERGE|OrgUnitClassification||2021/05/13|4712/12/31|300000217254520|Test WU2|ORA_PER_UNION||||I|IN||FUSION|300000217254521 The file makes…
Query to extract only the profile data:
Use the below query to get the details of Community in Learning:
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.
While creating the Courses in Oracle Learning Cloud, there is a capability to load CoverArt for each course. If no cover art is loaded, the learner is presented with a blue strip film. HCM Data Loaders provides an option to bulk upload the CoverArt file for multiple courses at one go. All the cover art…
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…
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 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…
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 ->…
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 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…
