HCM Extracts

 

Common Entities used in HCM Extracts

Person - PER_EXT_SEC_PERSON_UE
Worker Payroll - PER_EXT_PAY_EMPLOYEES_UE
Extract Assignment Basic Information - PER_EXT_SEC_ASSIGNMENT_BASIC_UE
Assignments Range - PER_EXT_SEC_ASSIGNMENT_RANGE_UE
Extract Current and Future Persons - PER_EXT_SEC_PERSON_NOW_FUTURE_UE
Extract Current and Future Assignments - PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE


Comments

Post a Comment

Popular posts from this blog

Payroll Balance Initialization Errors

Query   SELECT pbh.batch_name ,pbh.batch_status ,pbl.LINE_SEQUENCE ,pbl.PAYROLL_RELATIONSHIP_NUMBER ,pbl.ASSIGNMENT_NUMBER ,pbl.BALANCE_NAME ,pbl.DIMENSION_NAME ,pbl.batch_line_status ,pbl.value ,LISTAGG(pml.line_text, '; ') WITHIN GROUP ( ORDER BY pbl.LINE_SEQUENCE ) "Error_list" FROM pay_bal_batch_headers pbh ,pay_bal_batch_lines pbl ,pay_message_lines pml WHERE pbh.batch_name = nvl(:Batch_Name, pbh.Batch_Name) AND pbl.batch_id = pbh.batch_id AND pbl.batch_line_status = 'E' AND pml.source_type = 'L' AND pml.source_id = pbl.batch_line_id GROUP BY pbh.batch_name ,pbh.batch_status ,pbl.LINE_SEQUENCE ,pbl.PAYROLL_RELATIONSHIP_NUMBER ,pbl.ASSIGNMENT_NUMBER ,pbl.BALANCE_NAME ,pbl.DIMENSION_NAME ,pbl.batch_line_status ,pbl.value
Read more

HCM Data Loader

 Configure HCM Data Loader Parameters Setup and Maintenance > Configure HCM Data Loader > Open task SELECT * FROM hrc_dl_parameters Role for HCM Data Loader Human Resource Integration Specialist List of all Business Objects supported by HDL Under View Business Objects in Data Exchange Types of Keys supported by HDL GUID Oracle Fusion Global Unique ID Hexadecimal Can NOT use while creating new records Source Keys Combination of two fields Source System Owner HRC_SOURCE_SYSTEM_OWNER lookup under Setup and Maintenance > Common Lookups Source System ID  Alphanumeric value Can be used while creating new records Surrogate Keys Can NOT use while creating new records System generated Unique Numeric value for that record User Keys Can be used while creating new records Part of the Business Object that they belong to e.g. JobCode|SetCode Table which stores Source, Surrogate and GUIDs HRC_INTEGRATION_KEY_MAP Update Source Keys once set Yes, using SourceKey.dat Purge HDL Staging ...
Read more