BIP – Query to Extract Position FTE values
When position hierarchy is enabled in Cloud HCM, Manage Positions UI shows some dynamically populated fields along with Parent position. For example: Use the below query to extract above details:
-
-
BIP – Query to extract fast formula details
Below query will extract all the custom fast formulas along with the name of formula and formula type. To extract list of fast formulas used in HCM Extracts, run below query:
-
HDL – Delete custom Action Reason Usages using HDL
Actions and Action Reasons are very important part of any Cloud HCM implementation. Oracle provides a large number of actions and action reasons out of the box. But if needed additional actions and action reasons can be created from UI as well as using HDL. Each action is tied with an action type. Please note…
-
Value Set – Table Value set to get list of employees
While extending the DFF attributes for additional functionality, one of the common requirements is to get the list of workers in the system. For this purpose a table based value set can be defined and attached to the DFF attribute. FROM Clause per_all_people_f papf, per_person_names_f ppnf Value Attributes Table Alias *Value Column Name papf.person_number…
-
-
HDL – Sample File to Load Succession Plan
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.
-
HCM Extract – Using Multiple values in Parameter
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.
-
-
BIP – Query to extract File details loaded through File Import and Export
Use below query to extract files loaded through Tools -> File Import and Export along with UCM Content ID and the account used:
-
Configuration | HDL | Reports
BIP – Query to get Configure HCM Data Loader parameters
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…
-
BIP – Specialization Details
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:
-
HDL – Updating Work Day Information at Department Level
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
-
HDL – Inactivating Worker Unions
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…
-
-
BIP – Query to get position profile details
Query to extract only the profile data:
-
BIP – Query to get Community Member details in OLC
Use the below query to get the details of Community in Learning:
-
BIP – Query to get Default Assignment Rules of the Course
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.
-
HDL – Loading CoverArt File at Course Level
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…