Load the data into the custom content section

METADATA|TalentProfile|ProfileTypeCode|PersonNumber|ProfileId|ProfileUsageCode|ProfileStatusCode|ProfileCode MERGE|TalentProfile|PERSON|020250|300000030849224|P|A|TPROF_020250


Not able to hide the delete button from a report

You have the BI administrator duty in this role which gives full access (admin-level access) to all reports. If you want the delete option to be removed even from this role then you have to go to the specific folder or specific report from which you want to remove the delete option.


Not able to assign the check-in document

Check if the required employee is eligible or not, if he/she is not eligible then batch eligibility process. You can also try the following step which adds privileges. 1. add the following privileges ORA_HRA_MANAGE_CHECK_IN_DOCUMENT ORA_HRA_VIEW_CHECK_IN_DOCUMENT


Goal Plan Overview

A Goal Plan is a method of assigning a set of Goals to numerous employees at the same time. Creating Goal plans is required to allow employees to update their progress as well as duties against their supervisors' Goals. Goal Plans are tied to performance cycles, and a performance document will retrieve Goals for evaluation purposes based on the association provided. Goal plans can be created in the system by a Talent Administrator.


Recruiting Activities for Beginners

1. Position Based Requisition Creation by Recruiter 2. Requisition Management (Job Formatting and Posting) 3. Job-Based Requisition and Duplicating a Requisition by Recruiter 4. Position-Based Requisition Creation by Hiring Manager


Learning custom notifications is not working created by alert composer

When you felt that, you have done everything correctly but still your custom notification is not working, 1. You need to check if the learner has a work email assigned or not. 2. You need to check in the Alert History whether your custom notification status has been completed or not. 3. Go to the "Run Options" and put -1 in Maximum Messages


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