HDL or Metadata File for upload talent rating
Dat File Name: TalentProfile.dat METADATA|ProfileItem|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingModelId2|RatingLevelId1|RatingLevelId2|SourceSystemOwner|SourceSystemId
List of Supported Business Object for HDL or .dat file names
Business Object - File Name Absence Case - AbsenceCase.dat Action - Actions.dat Action Reason - ActionReasons.dat Action Reason Translation - ActionReasonsTranslation.dat Action Translation - ActionsTranslation.dat
Loading Department and Department Tree using HDL or metadata file
METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|ParentDepartmentName MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|XYZ Department Tree|XYZ Tree of Departments|XYZ-IND-GG-NorthRegion|XYZ-IND-GG-NorthRegion-A&B-North
HDL or Metadata file for loading content items
Dat File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name
SQL Query to get the list of direct reports from a line manager
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
SQL Query to get the list of active schedule processes
SELECT p.* , (CASE WHEN p.state = 1 THEN 'Wait' WHEN p.state = 2 THEN 'Ready' WHEN p.state = 3 THEN 'Running' WHEN p.state = 4 THEN 'Completed' WHEN p.state = 9 THEN 'Cancelled'
List of SQL Table with their field names
Date of Birth: PER_PERSONS_ National identifier: PER_NATIONAL_IDENTIFIERS_
SQL Query to get the assignment id, period of service id, work terms assignment id
Select ASSIGNMENT_NUMBER, ASSIGNMENT_ID, PERIOD_OF_SERVICE_ID, WORK_TERMS_ASSIGNMENT_ID, ASSIGNMENT_STATUS_TYPE from per_all_assignments_f
SQL Query to get the no of employees assigned a Work Schedule Assignment Administration
SELECT DISTINCT SCHEDULE_NAME, SCHEDULE_TYPE_CODE , ASSIGNMENT_NUM FROM FUSION.ZMM_SR_SCHEDULES_VL WHERE SCHEDULE_NAME LIKE '%Provide your workschedule name here%'
HDL or Metadata file for department
Dat File Name: Organization.dat METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode|FLEX:PER_ORGANIZATION_UNIT_DFF|ExpenseAccount(PER_ORGANIZATION_UNIT_DFF=Global Data Elements)|ProjectCode(PER_ORGANIZATION_UNIT_DFF=Global Data Elements)
What is date tracking in fusion application and which tables it will affect?
Date tracking means maintaining a history of changes to personal records. Date tracking is based on two columns they are effective_start_date and effective_end_date
Performance Document is not creating for an employee after running the batch eligibility process
We have created a performance template and also run the batch eligibility process but still, a performance document is not created for an employee. But when we are checking in the Performance Document Eligibility then it is showing that the person is eligible for the particular performance document.
Performance Management Overview
Oracle Fusion Performance Management is intended to provide a point-in-time evaluation of worker performance to employees, supervisors, and company executives. Organizations can tailor the performance approach to their specific business needs. Workers and managers can immediately understand where they are in the process thanks to an industry-leading user experience.
Recruiting Processes done by Hiring Manager and Recruiter
Process 1 – Hiring Manager and Recruiters (My Team and My Client Groups) The hiring Manager creates a requisition (only provides basic details) > Recruiter will receive an email and will complete the job requisition (complete everything for the requisitions) > Recruiter will post requisitions on the career site and job portal > Recruiter will review resumes
If you are getting an error when you are clicking on cancel button on Record External Learning Experience
Solution/Workaround: Then perform the below steps 1. Search the required data role 2. Click on Edit Role 3. Go to Data Security Profiles 4. Click on Create Data Security Policy
If a course minimum headcount is not achieved then could the system will automatically cancel the course. If yes, can we set the course cancellation date certain days before the course start date?
No, the course will not be canceled automatically in the system if the headcount is not matched. However, minimum and maximum capacity functionality is at the offering level and not a course level
What are the business object we have in HR Helpdesk?
1. Service Request 2. Message 3. Channel 4. Queue
Line Manager is not updating
We need to run the required schedules process which is Synchronize Person Assignments from Position
Grade Ladder
A grade ladder combines grades into grade ladders to group grades or grades with steps in the sequence in which workers typically progress.
Absence is not showing without selecting All
Reason/Root Cause: Because the employee is having 2 absence records with the same absence type.
Categories
- All Posts
- Absence Management
- Absence Management - Issues
- Benefit Management
- Common for all modules
- Compensation Management
- Compensation Management - Issues
- Global Human Resource
- Global Human Resource - Issues
- Human Resource Helpdesk
- Oracle Learning Cloud
- Oracle Learning Cloud - Issues
- Oracle Recruiting Cloud
- Oracle Recruiting Cloud - Issues
- Talent Management
- Talent Management - Issues
- Technical Contents
- Technical Contents - Fast Formula
- Technical Contents - HDL Templates
- Technical Contents - OTBI Reports
- Technical Contents - Spreadsheet Loader
- Technical Contents - SQL Query
- Technical Contents - SQL-HDL
- Time and Labor
- Time and Labor - Issues