How to update the learning assignment once its created by a line manager?
In this blog you will learn how to update the learning assignment as a manager using the Learning Record object and HCM Data Loader.
Load talent profile rating for a specific employee
My Client Groups > Profiles > Profile Rating Models > create or check your profile rating model that you are going to use. Profile Types > Person > go to “Profile Talent Ratings” > click on Performance Rating > select Rating Model = Performance Rating Model (see screenshot)
How to load the date of birth of an employee using HDL
File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth|CountryOfBirth|WaiveDataProtectFlag|CategoryCode MERGE|Worker|Vision|Test_123456789|01-08-2022||0140870390|NEW HIRE_EMP|01-08-2022|06-05-1992|LK|N|PER_EIT
Load Metadata File for Job Creation using HDL
Dat File Name: Job.dat METADATA|Job|JobCode|ActiveStatus|FullPartTime|EffectiveStartDate|Name|SetCode|JobFamilyName|SourceSystemOwner|SourceSystemId MERGE|Job|ABC-JB-010-2D|A||1951/01/01|Systems Administrator|ABCSUS|Security Systems Service, Maintenance & Repair|ABC_SS_US|ABC-JB-010-2D
Load Matadata File for License & certification creation using HDL
Dat File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|ABC_Licenses_Certifications|U|103|Supervision of Aerosols
Load metadata file for License and Certification using HDL
ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|CERTIFICATION|U|103|Supervision of Aerosols
Load metadata file for goal using HDL
Dat File Name: METADATA|Goal|GoalId|GoalName|Description|StartDate|TargetCompletionDate|AssignmentId|OrganizationId|PersonId|WorkerPersonNumber|StatusCode|GoalSourceCode|AllowKeyAttrUpdateFlag|AssignedByPersonId|PublishedFlag MERGE|Goal|300000000000000|Strengthen and model a Culture of Accountability, Agility and Business Acuity and the Rewards and Consequences required to support it||2018/01/01|2018/12/31|400000000000000||100000000000000|20000000|NOT_STARTED|HR|N|500000000000000|
Load metadata file for Talent Profile using HDL
Dat File Name: TalentProfile.dat METADATA|ProfileItem|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingLevelId1|SourceSystemOwner|SourceSystemId
Load metadata file for an Area of responsibility (AOR) using HDL
Dat File Name: METADATA|AreasOfResponsibility|AsgResponsibilityId|ResponsibilityName|ResponsibilityType|StartDate|EndDate|Status|PersonId|PersonNumber|AssignmentId|AssignmentNumber|LocationCode|LocationSetCode
Load the metadata file for terminate an employee using HDL
Dat File Name: METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId
Load metadata file for Department using HDL
METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode MERGE|Organization|1951/01/01||ABC-AT-SS|ABC_SS_AT|ORG_AT_DPT_001|DEPARTMENT
Load metadata file for adjust the absence balance using HDL
Dat File Name: PersonAccrualDetail.dat METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|Value|ProcdDate|AdjustmentReason|SourceSystemId|SourceSystemOwner MERGE|PersonAccrualDetail|1000|ET1000|Annual Leave Plan|INIT|10|2022/12/31||ABR_1000|HRC_SQLLOADER
Load the metadata file for created dff in the document of record
METADATA|DocumentsOfRecord|DocumentType|DocumentTypeId|PersonNumber|FLEX:PER_DOCUMENTS_OF_RECORD_DFF|dateOfAmendedDutiesNote(PER_DOCUMENTS_OF_RECORD_DFF=GB_MEDICAL___AMENDED_DUTIES_NOTE)|SourceSystemOwner|SourceSystemId MERGE|DocumentsOfRecord|Medical - Amended Duties Note|300000000000000|1000|US_MEDICAL_AMENDED_DUTIES_NOTE|2021/12/31|HDL|Medical1
Terminating or Inactivating User Accounts after Terminations HDL
Once a user has been terminated, however, the user accounts are still active then follow the steps below to inactivate their user account using HDL. Step 1 – Get a list of all terminated employees Step 2 – Prepare the .dat file METADATA|User|PersonNumber|Suspended
Load metadata File for Job Level using HDL
METADATA|Job|Name|JobId|JobCode|ActiveStatus|ApprovalAuthority|EffectiveStartDate|SourceSystemOwner|SourceSystemId|GUID MERGE|Job|HR Specialist|0101010|ABC-KB-0799-51B|A|0|1951/01/01|ABC_SSES_US|12121212|
Load Metadata File for update employee Job and Position using HDL
Dat File Name - Worker.dat METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|ActionCode
HDL for Succession Plans
Dat File Name - SuccessionPlan.dat METADATA|SuccessionPlan|SourceSystemOwner|SourceSystemId|PlanName|PlanType|Status|AccessTypeCode|IncumbentPersonId(SourceSystemId)
HDL or Metadata File for Worker
Dat File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|ActionCode
HDL or Metadata File for upload performance rating
METADATA|ProfileItem|FLEX:HRT_PROFILE_ITEMS|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingLevelId1|typeOfRating(HRT_PROFILE_ITEMS=PERSON_PERFORMANCE_RATING)|date1(HRT_PROFILE_ITEMS=PERSON_PERFORMANCE_RATING)|ItemClob1File|SourceSystemOwner|SourceSystemId
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
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