Oracle Fusion HCM Essentials

 Absence SELECT 'METADATA' || CHR (124) || 'PersonAbsenceEntry' || CHR (124) || 'PerAbsenceEntryId' || CHR (124) || 'AbsenceType' || CHR (124) || 'AbsenceTypeId' || CHR (124) || 'AbsenceStatus' || CHR (124) || 'ApprovalStatus' || CHR (124) || 'AssignmentNumber' || CHR (124) || 'AssignmentId' || CHR (124) || 'EmployerId' || CHR (124) || 'PersonNumber' || CHR (124) || 'PersonId' || CHR (124) || 'StartDate' || CHR (124) || 'StartTime' || CHR (124) || 'StartDateDuration' || CHR (124) || 'EndDate' || CHR (124) || 'EndTime' || CHR (124) || 'EndDateDuration' || CHR (124) || 'AbsenceReasonId' || CHR (124) || 'SubmittedDate' || CHR (124) || 'PlannedEndDate' || CHR (124) || 'NotificationDate' || CHR (124) || 'ConfirmedDate' || CHR (124) || 'SourceSystemId' || CHR (124) || 'SourceSystemOwner' AS DATA...

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

  System Person Types Predefined by Oracle Cannot be created, edited or deleted Employee, Applicant, Contingent Worker, Nonworker User Person Types Customizable by Organization Can be created, edited and deleted Associate, Intern

  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

Error Stats SELECT     ucm_content_id,     data_set_id,     data_set_name,     imported_status,     loaded_status,     import_lines_success_count,     import_lines_error_count,     import_lines_total_count,     import_success_count,     import_error_count,     loaded_count,     error_count,     request_id FROM     hrc_dl_data_sets WHERE     ucm_content_id in (:p_content_id) Error Lines in HDL format SELECT * FROM ( SELECT err.orderby , err.err_location , err.message_type , err.msg_text , err.data_set_name , err.data_file_name , err.ucm_content_id , DECODE(NVL(:P_ENABLE_TRACE,’N’),’Y’,err.stack_trace,NULL) STACK_TRACE , err.ui_user_key , SUBSTR(err.metadata,10,INSTR(err.metadata,’|’,1,2)-INSTR(err.metadata,’|’,1,1)-1) BusinessObject , SUBSTR(err.file_line,INSTR(err.file_line,’|’,-1,1)+1,LENGTH(err.file_line)-INSTR(err.file_line,’|’,-1,1)) S...