Learning Initiatives

A learning initiative is a continuous assignment. In contrast to a learning assignment, which is only applicable once, a learning initiative can be created and defined once, and additional assignments in a series can be generated with or without an end date. Using an analysis report


Can we create the sub-status type in HR Helpdesk?

Yes, you can create sub-status types in HR Helpdesk in Oracle Fusion HCM. You can create a sub-status type by following these steps: Go to Setup and Maintenance. Search for Manage Service Request Status Values. Click on Manage Service Request Status Values. Select the Parent Status. Click on Create Status. Enter the Status Name, Status Short Name, and Active. Click on Save and Close.


Document Type approval is set as auto approve but still showing the message that Approval in progress

I have investigated and found that this is not related to only document records, it is happing for all approval where we have configured the conditions. When the approval is set to Auto Approve, an approval task is in progress status. So, there is a delay between submitting the transaction to completing the transaction. Hence users see that message displayed.


Core HR Approval Processes

Approvals provide the ability to require signoff by other people, such as a manager or representative before transactions are submitted to the database. Oracle Global HR has the following Human Capital Management approval transactions:


Not able to delete the withdrawn absence record

My Client Groups - Absence - Configure Absence Batch Parameter - Additional Attributes - Withdrawn Record Deletion - Enable for administrator


Rolling Backward Term

- Calculate absence entitlements based on the total duration of absent time taken for a specific time period that precedes the absence start date.


Get the number of days excluding weekends using SQL

SELECT COUNT(*) FROM ( SELECT TRUNC(SYSDATE,'MM') + LEVEL - 1 AS day FROM dual CONNECT BY LEVEL <= ADD_MONTHS(TRUNC(SYSDATE,'MM'),1) - TRUNC(SYSDATE,'MM')


What is the difference between OTBI Reports and BI Reports?

OTBI Reports BI Reports It is standard reports It is custom reports It is providing security  It is not providing security It is no more advantages Using the Bi reports so many advantages Ex. Data logic, Layout, Translation.


Update termination action and action reasons for terminated employees?

Update Action and Action Reason for a terminated employee, use Worker.dat file, WorkTerms and Assignment. METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|PersonId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|ReasonCode MERGE|WorkTerms|300000020344247|300000020344240|300000020344238|2018/05/10|4712/12/31|1|Y|INVOLUNTARY_TERMINATION|DISMISSAL


SQL to find the manager and their direct reportees

select papf_Reportee.person_number, to_char(pasf.EFFECTIVE_START_DATE,'yyyy/dd/mm') start_dt_spr from per_all_people_f papf, per_All_assignments_m paam, PER_ASSIGNMENT_SUPERVISORS_F pasf,


OTBI Report for Person Number, First Name, Last Name, WorkTermAssignment Id, Assignment id, period of service

Subject Area: Workforce Management - Worker Assignment Real Time Go to the Worker folder - Person Number - First Name


Legacy Learning Item

METADATA|LegacyLearningItem|Title|LearningItemNumber|EffectiveStartDate|EffectiveEndDate|OwnedByPersonNumber|SourceType|SourceInfo MERGE|LegacyLearningItem|Legacy Test|Legacy Test_101|1951/01/01||2002|FUSION_HCM_LEARNING|LegacyLearningSystemSourceInfo


Difference between FBL & HDL loaders?

FBL (File Based Loader)                                       We can support 21 business objects                  FBL, we need to follow the sequence order       FBL will not support the extra information        FBL will not upload to the document of record    Only it allows GUID keys for FBL


Not able to reorder the date in the custom content section

The client was using an Accomplishment content section with their custom field without any seeded field. So whenever they add any data in the content section the system automatically shows the last update date without any sequencing


Succession Management Overview

You can build succession plans for replacing important individuals using succession management. Succession plans identify individuals who are ready now or who can learn the skills needed for occupations and positions that are not currently open. Succession planning can help you manage candidate development and guarantee a smooth handover.


Not able to replace the content

If activity sequencing is enabled, follow these steps to replace content: Assume there is an existing activity with Content A, which is currently being used. Develop new content with updated information, and label it as


Learning Evaluation and Assessment

Assessments are exams you include in an offering to gauge how well students have understood the information. Learners receive assessments in the form of a questionnaire.


Is HDL support for data migration in HR Helpdesk?

HDL is not a specific tool for HR helpdesk functionality, you could potentially use it to migrate and manage certain types of data that are relevant to HR helpdesk processes. For instance, you could use HDL to import employee data such as names, contact information, job roles, departments, and other...


Saved the record during hiring process and not able to find it

Suppose: when we are doing the hire an employee process and by mistake, we have clicked on the Save and Close button instead of Submit then you will be able to find the record in the bell notification.