Saturday 4 September 2021

HDL Template for Job Requisition

HDL Template for Job Requisition 


For this use JobRequisition.dat file.

You can see step by step video to load Job Requisition data using this Link


Please find the below sample template :

METADATA|JobRequisition|RequisitionNumber|RecruitingType|JobCode|JobFamilyCode|JobFunction|NumberOfOpenings|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerId|RecruiterId|PrimaryLocationId|PrimaryWorkLocationId|OrganizationId|DepartmentName|LegalEmployerName|WorkerType|RegularOrTemporary|FullTimeOrPartTime|EducationLevel|CurrentPhaseCode|CurrentStateCode|ExternalApplyFlowCode|PositionCode|BaseLanguageCode|BusinessUnitShortCode|CandidateSelectionProcessCode

MERGE|JobRequisition|XXTEST100|ORA_EXECUTIVES|XXTEST_PM|HUMAN RESOURCES|GSE_TEACH|2|N|XXTEST100|100000610420334|100000610420436|300000186934005|300000221843104|300000047826629|XXTEST Department1|US1 Legal Entity|E|Regular|FULL_TIME|13|REQUISITION_OPEN|REQUISITION_POSTED|ORC_FACULTY|XXTEST_POS1|US|US1 Business Unit|ORC_FACULTY


METADATA|PostingDetails|StartDate|ExternalOrInternal|RequisitionNumber

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_INTERNAL|XXTEST100

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_EXTERNAL|XXTEST100


Friday 20 August 2021

HDL Template for Candidate

 For this use Candidate.dat file.

You can see step by step video to load Candidate data using this Link


Please find the below sample template :

METADATA|Candidate|CandidateNumber|CandPrefLanguageCode|StartDate|ConfirmedFlag|CountryOfBirth|DateOfBirth|RegionOfBirth|Source|SourceMedium|TownOfBirth|VisibleToCandidateFlag

MERGE|Candidate|CT123|US|2019/03/20|Y||1980/08/05||direct Source|||Y


METADATA|CandidateAddress|CandidateNumber|EffectiveStartDate|AddressLine1|AddressType|AddressLine2|Country|PostalCode|Region2|Region1|TownOrCity|EffectiveEndDate

MERGE|CandidateAddress|CT123|2019/03/20|1257 Test1|HOME|Test|US|12576|NC|Wayne|Pikeville|


METADATA|CandidatePhone|CandidateNumber|DateFrom|PhoneType|PhoneNumber|CountryCodeNumber|AreaCode|DateTo|Extension|LegislationCode|SpeedDialNumber|Validity|GUID

MERGE|CandidatePhone|CT123|2019/03/20|H1|9605804|1|262|4712/12/31||US|||


METADATA|CandidateName|EffectiveStartDate|EffectiveEndDate|CandidateNumber|NameType|LegislationCode|FirstName|LastName

MERGE|CandidateName|2019/03/20||CT123|GLOBAL|US|Amar|Test


METADATA|CandidateProfile|CandidateNumber|ContentType|ContentItem|SectionContext|DateFrom|ItemDate7|ItemNumber9|ItemText2401|CountryGeographyCode|CountryCountryCode|ProfileItemId

MERGE|CandidateProfile|CT123|DEGREE|BA - Bachelor of Arts|PERSON_DEGREE|2019/03/20|2019/03/20|||US|US|122



Monday 2 August 2021

HDL Template for Content Item

 For this use ContentItem.dat file.

You can see step by step video to load Content Item data for talent profile using this Link


Find Content Item Value set Name using below Query - 

SELECT 

a.content_value_set_id as ContentItemValueSetId, 

a.content_value_set_code, 

b.value_set_name as ContentItemValueSetName, 

value_set_description

FROM FUSION.hrt_content_tp_valuesets_b a, FUSION.hrt_content_tp_valuesets_tl b

WHERE a.content_value_set_id = b.content_value_set_id

and b.language = 'US' ;


Please find the below sample template :

METADATA|ContentItem|SourceSystemOwner|SourceSystemId|ContextName|ContentItemCode|Name|ItemDescription|DateFrom|DateTo|ContentItemValueSetName

MERGE|ContentItem|XXTEST|XXTEST_BTECH|DEGREE||BTECH|BTECH|1951/01/01||Degrees


Monday 26 July 2021

HDL Template for Talent Profile

HDL Template for Talent Profile   


For this use TalentProfile.dat file.

You can see step by step video to load Talent Profile data using this Link

Please find the below sample template :

METADATA|TalentProfile|SourceSystemOwner|SourceSystemId|Description|Summary|ProfileTypeCode|ProfileCode|ProfileStatusCode|ProfileUsageCode|PersonId

MERGE|TalentProfile|XXTEST|XXTEST_TALENT2|||PERSON|PERSON_TALENT|A|P|100000609812368


METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItem|SectionName|CountryCountryCode|DateFrom|DateTo|RatingModelCode1|RatingModelCode2|RatingModelCode3|RatingLevelCode1|RatingLevelCode2|RatingLevelCode3

MERGE|ProfileItem|XXTEST|XXTEST_TALENTPROF2|XXTEST_TALENT2|LANGUAGE|Hindi|PERSON_LANGUAGE||2021/07/26||LANGUAGE|LANGUAGE|LANGUAGE|HIGH|HIGH|HIGH


Sunday 11 July 2021

HDL Template for Legislative Data Group

  For this use LegislativeDataGroup.dat file.

You can see step by step video to load Legislative Data Group using this Link

Please find the below sample template :


METADATA|LegislativeDataGroup|Name|DefaultCurrencyCode|LegislationCode|StructureInstanceName|SourceSystemOwner|SourceSystemId

MERGE|LegislativeDataGroup|US_LDG|USD|US|US Cost Flex Instance|XXTEST|XXTEST_LDG01


Monday 28 June 2021

HDL Template for Documents Of Record

 For this use DocumentsOfRecord.dat file.

You can see step by step video to load Documents Of Record using this Link

Please find the below sample template :


METADATA|DocumentsOfRecord|SourceSystemOwner|SourceSystemId|DocumentsOfRecordId|PersonNumber|DocumentTypeId|DocumentType|Country|DocumentCode|DocumentName|DocumentNumber|DateFrom|DateTo|IssuingAuthority|IssuedDate|IssuingCountry|IssuingLocation|Comments|Publish|PublishDate|Status|VerifiedBy|VerifiedDate

MERGE|DocumentsOfRecord|XXTEST|XXTEST_DOCREC01||XXTEST2||Passport||XXTEST_DOCREC01|Passport|XXTEST2123|||||US|||||||


METADATA|DocumentAttachment|SourceSystemOwner|SourceSystemId|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|Title|URLorTextorFileName|File

MERGE|DocumentAttachment|XXTEST|XXTEST_DOCREC01|XXTEST2|Passport||XXTEST_DOCREC01|passport.png|passport.png|FILE|passport.png



Sunday 9 May 2021

Top 50 Fusion HCM Technical Questions - Part 2


 Top 50 Oracle Fusion HCM Technical Questions - Part 2



Top 50 Oracle Fusion HCM Technical Questions - Part 1 Click 


Q) Mandatory Records to Load Worker File for NEW Hire?
->  Worker , Person Name , Person Legislative Data, Assignment, Work Term.

Q) Sequence of WorkStructure Business Object While Load?
-> Work Structure Business Object loads in below sequence 
     1. Location
     2. Grade
     3. Job
     4. Orgnization
     5. Position

Q) If any Location is end dated and same location we are providing in Worker File then what will happen?
-> HDL will fail to load the data. It will give error as "You must enter a valid value for the LocationId field.

Q) Can we delete Location using HDL?
-> We can not delete Location. You can end date the that Location and make inactive.

Q) What will happen in below Scenario?
        Scenario - If we have future date changes for any worker and we tried to load the current any changes for the same worker using HDL.

-> If we tried to load the current changes then it will purge the future changes because by default 
     PURGE_FUTURE_CHANGES value set as Y.
     If you want to keep future dated changes then set PURGE_FUTURE_CHANGES N so that it will         keep future dated changes after the data load.

Q) Which Role is required to process the file using HCM Data Loader?
->  You required the Human Capital Management Integration Specialist Role (ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_INTEGRATION_SPECIALIST_JOB)

Q) How can you change the delimiter in HDL File at run time?
->  You can set delimiter in HDL File using SET FILE_DELIMITER command.

Q) "The party identified by the specified party ID does not exist" Error while loading Personal Payment Method using HDL?
-> Reason - > Party Id is not created for those Worker.

 Solution - Run Below scheduled process 
                1 - Maintain Party and Location Current Record information
                2 - Synchronize Person Records 

Q) How to create personal Payment Method incase joint account scenario?
-> Create two different personal payment method for each employee and both can be tagged to same account.
In this case primary account holder name will be displayed in UI for both methods. 


Q) Talent Profile data loaded successfully using HDL, But not able to see at front end.
->  Loaded Profile information is not able to see at front end because of two reasons
            1. Check Section Id/Section Name is correctly used
             2. Check Content Type Id/Content Type is used correctly.

Q) Load Non Workers with person type Pensioner using HDL?
-> You can use Person Type Code and System Person Type with Pensioner in WorTerm and assignment Metadata line. 


Q) Supervisor Load is failed what could be the reason and solution for the same?
-> Cause - Manager's hire date is earlier than assignments effective start date
      Solution -  Add Work Term and Assignment record which is later than Manger's hire date   along with supervisor record.

          

 

Avoid/Ignore if we have empty tag in XML.

 Ignore the Empty Tag in XML or avoid blank rows in For loop BIP Report. If we have blank row of data in For Loop in BIP Reports like in bel...