> 持续流程改进 > 员工入职 > Oracle HCM Onboarding > 数据模板

您的员工入职数据模板

Oracle HCM Onboarding

您的员工入职数据模板

该模板为您收集分析员工入职流程所需的关键数据提供了清晰的路线图。它概述了要跟踪的关键属性和活动，并为直接从 Oracle HCM Onboarding 提取此类信息提供了实操指南。利用此资源简化您的数据收集，并为富有洞察力的流程分析做好准备。

全面分析的推荐属性
入职旅程中需监控的关键活动
Oracle HCM Onboarding 分步数据提取指南

不熟悉事件日志？了解如何创建流程挖掘事件日志.

下载模板

员工入职属性

这些是建议包含在事件日志中的数据字段，用于对您的员工入职流程进行全面分析。

3 必填 8 推荐 11 可选

	名称	描述
	Event 时间 EventTime	指示特定入职活动或事件发生时间的日期时间戳。
描述 Event Time 捕获了任务完成或里程碑达成的精确日期和时间。此时间顺序 data 是在 Process Mining 中计算所有基于时间的指标的基础。此属性用于对 event 进行正确排序、计算活动之间的持续时间、衡量入职流程的总周期时间并识别延迟。它对于几乎所有的仪表板和 KPI 都至关重要，包括瓶颈分析和周期时间跟踪。为何重要此时间戳对于事件排序、计算持续时间以及根据时间目标衡量流程绩效至关重要。获取方式此信息通常与 Oracle HCM Onboarding 模块的事务或事件日志中的每个活动一起记录。示例 2024-05-20T10:00:00Z2024-05-21T14:35:10Z2024-05-22T09:00:00Z
	入职案例 OnboardingCase	对单个新员工入职旅程中所有事件和活动进行分组的唯一标识符。
描述入职案例是整个入职流程的核心标识符，从接受录用到完全融入。每个案例代表一位新员工的完整生命周期。在流程挖掘中，此属性对于将所有相关活动缝合到一致的端到端流程图中至关重要。它允许分析个人入职旅程的流程变体、周期时间和结果，从而全面了解不同新员工体验流程的方式。为何重要这是连接所有相关入职活动的核心标识符，使得分析每位新员工的完整流程流成为可能。获取方式此标识符通常在启动候选人旅程时在 Oracle HCM Onboarding 模块中生成。请咨询 Oracle HCM Onboarding 文档或系统管理员以确定具体字段。示例 ONB-2024-00123ONB-2024-00124ONB-2024-00125
	活动名称 ActivityName	在员工入职流程中发生的特定事件或任务的名称。
描述此属性描述了入职旅程中的单个步骤或里程碑，例如“接受邀约”、“背景调查完成”或“第一天入职培训”。这些活动构成了流程图的构建模块。分析这些活动的顺序和持续时间是流程挖掘的基础。它有助于识别瓶颈、偏离标准流程的情况以及自动化或改进的机会。理解活动流对于周期时间和流程变体相关的仪表板至关重要。为何重要此属性定义了流程中的步骤，从而实现了入职工作流、瓶颈和变体的可视化与分析。获取方式这通常源自 Oracle HCM Onboarding 模块内的事件或任务日志。它可能是一个标准化的任务名称或状态更改记录。示例已接受 Offer已发起背景调查入职前文书已完成已进行首日迎新培训
	事件结束时间 EventEndTime	具有可衡量持续时间的活动结束时的时间戳。
描述虽然 event 时间 (StartTime) 标记了开始或某个时间点 event，但 event 结束时间则标记了完成。同时具备开始和结束时间可以精确测量“背景调查”等活动的持续时长。该属性对于计算非瞬时任务的 `ProcessingTime` 或 `ActivityDuration` 至关重要。通过区分任务前的等待时间和实际执行时间，它可以实现更准确的瓶颈分析。为何重要支持精准计算活动处理时间，这对于准确识别流程瓶颈和低效环节至关重要。获取方式请查阅 Oracle HCM Onboarding 文档。这些信息可能存在于任务或 workflow 表中，通常与开始时间并列。示例 2024-05-23T11:05:00Z2024-05-24T16:20:15Z2024-05-25T10:00:00Z
	合规截止日期 ComplianceDueDate	必须完成必修培训或合规任务的截止日期。
描述此属性指定关键入职任务的目标完成日期，特别是与法律、监管或公司政策要求相关的任务。它充当合规活动的服务水平协议 (SLA)。在分析中，此日期与“必修培训完成”等活动的实际完成时间戳进行比较，以确定是否达到了合规目标。它是“按时培训完成率”KPI 和“合规遵循跟踪”仪表板的基础。为何重要此日期对于监控合规性、计算强制性任务的按时完成率以及降低企业风险至关重要。获取方式此日期通常在 Oracle HCM 的入职任务设置或旅程模板中定义，可能根据入职日期计算得出。示例 2024-06-302024-07-152024-08-30
	执行人 PerformedByUser	执行入职活动的员工或系统的用户 ID 或名称。
描述此属性标识负责完成任务的人员资源，例如 HR 专员、招聘经理或新员工本人。它还可以指示系统执行的自动化操作。分析谁执行了哪些活动有助于了解资源分配、工作量分布和自动化水平。它可以揭示延迟是否与特定团队或角色相关，并有助于识别针对性培训或流程重新设计的机会。为何重要识别每个活动的执行者，从而能够分析流程中的工作负载、资源绩效和自动化程度。获取方式此信息通常位于 Oracle HCM Onboarding 的审计线索或事件历史日志中，并与每个任务或事务相关联。示例 john.doejane.smithHCM_SYSTEM_AUTOMATION recruiter_team
	招聘经理 HiringManager	新员工经理的姓名或 ID。
描述此属性标识将负责新员工的经理。招聘经理是入职流程中的关键利益相关者。按招聘经理分析数据可以揭示不同经理参与入职流程方式的差异。例如，它可以显示哪些经理能及时完成“团队介绍”等任务，而哪些经理可能需要更多支持，从而帮助提高经理的效能和新员工的融入度。为何重要有助于分析招聘经理在入职流程中的参与度和有效性，这直接影响新员工的体验。获取方式此信息是 Oracle HCM 员工记录的核心部分，将员工与其直接经理关联起来。示例 manager_user1Emily Whitemanager_user3
	新员工所属部门 NewHireDepartment	新员工加入的部门或组织单位。
描述此属性指定新员工分配到的部门，例如“销售”、“工程”或“财务”。它是细分和比较入职流程的关键维度。通过按部门过滤或比较，分析师可以确定整个组织的入职体验或效率是否存在差异。这可以突出某些部门的最佳实践，或识别其他可能需要额外支持或流程改进的部门。这对于理解流程性能如何随业务背景而变化至关重要。为何重要允许对入职 data 进行细分，以比较组织不同部门的流程效率和体验。获取方式这是新员工职位的核心属性，存储在 Oracle HCM 的员工档案中。示例销售与市场软件工程财务人力资源
	新员工职位名称 NewHireJobTitle	新员工的正式职位名称。
描述此属性包含新员工的具体职位，例如“高级软件工程师”或“客户经理”。它为流程分析提供了另一个层级的详细信息。不同的工作职位可能有独特的入职要求，例如专门的培训或设备。按职位名称分析流程可以帮助确保这些独特需求得到有效满足，并能揭示一些模式，例如技术职位的 IT 配置时间更长。为何重要提供有关新员工职位的背景信息，以便分析入职流程是否因不同的职能或级别而异。获取方式这是新员工核心职位信息的一部分，存储在 Oracle HCM 的员工记录中。示例高级软件工程师客户执行 (AE)HR通才产品经理
	正式入职日期 OfficialStartDate	新员工的正式入职日期。
描述此属性是一个关键日期，作为入职流程中的重要里程碑。它将入职前活动与入职后的融入活动区分开来。此日期作为多项重要 KPI 的基准，包括“入职前周期时间”、“团队介绍所需时间”和“首日就绪率”。分析相对于入职日期的活动有助于评估组织是否为新员工的到来做好了充分准备，从而确保他们从第一天起就能产生效益。为何重要作为衡量入职前效率的关键里程碑，并用于评估新员工是否为入职第一天的成功做好了准备。获取方式这是 Oracle HCM Core HR 模块中新员工记录的基本字段。示例 2024-06-012024-07-152024-08-01
	活动时长 ActivityDuration	完成特定入职活动所花费的计算时间。
描述此指标代表活动的处理时间，计算为结束时间戳与开始时间戳之间的差值。如果结束时间不可用，可以估算为直到下一个活动开始的时间。活动持续时间是流程挖掘分析的基石，直接支持“活动瓶颈分析”仪表板。通过突出哪些步骤耗时最长，它使流程负责人能够将改进工作集中在对整体周期时间影响最大的领域。为何重要直接衡量每个任务花费的时间，这对于识别瓶颈和确定流程改进工作的优先级至关重要。获取方式这是一个计算指标，通过从“EventEndTime”中减去“EventTime”(StartTime) 得出。示例 25920086400604800
	HR 个人资料是否返工 IsHrProfileRework	一个标志，用于指示新员工的“HR Profile Created”活动是否发生了多次。
描述此布尔属性用于识别 HR 档案创建步骤中返工的情况。如果“已创建 HR 档案”活动或相关的更正活动在同一个入职案例中多次出现，则将其设置为 true。此属性直接支持“HR 档案返工率”KPI。返工发生率高表明存在数据质量、系统集成或用户错误等问题，所有这些都会导致入职流程的延误和低效。为何重要通过标记需要更正的 case 来帮助量化流程低效情况，指出 data 录入或流程设计中潜在的问题。获取方式这是一个计算属性，通过在流程挖掘工具中分析活动顺序以检测重复步骤而得出。示例 falsetrue
	入职旅程类型 OnboardingJourneyType	分配给新员工的入职计划或旅程的具体类型。
描述企业通常有不同的入职计划，例如“标准雇佣”、“高管”、“实习生”或“重新雇佣”。此属性根据分配的计划对入职案例进行分类。这是一个强大的分析维度，因为它允许对不同的入职计划进行直接比较。它可以帮助回答诸如“我们的高管入职流程是否比标准流程更快？”之类的问题，并且是理解流程变体的基础。为何重要按计划类型对入职 case 进行分类，从而能够直接比较不同的入职路径和体验。获取方式这将由 Oracle HCM Onboarding 中应用于新员工的具体入职检查清单或旅程模板决定。示例标准企业雇佣高管入职校招新员工内部转交
	最后数据更新 LastDataUpdate	表示此记录的 data 上次刷新或提取时间的 timestamp。
描述此属性提供最近一次数据加载的日期和时间。这是一个元数据字段，对于了解分析的时效性至关重要。用户依靠此信息来了解他们查看的仪表板和分析是否为最新。它有助于管理对数据延迟的预期，并且对于验证数据质量和刷新计划非常重要。为何重要指示 data 的新鲜度，这对于确保分析和仪表板基于当前信息至关重要。获取方式此时间戳是在数据提取和转换 (ETL) 过程中生成并添加的。示例 2024-06-10T04:00:00Z2024-06-11T04:00:00Z
	培训是否准时 IsTrainingOnTime	一个计算标志，用于指示强制性培训是否在合规截止日期前完成。
描述此布尔属性是通过将“必修培训完成”活动的时间戳与“合规截止日期”进行比较而得出的。如果培训在截止日期当天或之前完成，则为 true。这是“按时培训完成率”KPI 的核心指标。它为合规遵循提供了清晰的二元结果，便于跟踪一段时间内的绩效并识别存在违规风险的案例。为何重要提供合规遵循的清晰指标，帮助跟踪和管理与逾期必修培训相关的风险。获取方式这是一个计算属性，通过将“必修培训完成”时间戳与“合规截止日期”属性进行比较而得出。示例 truefalse
	必修培训状态 RequiredTrainingStatus	新员工必修培训任务的当前状态。
描述此属性跟踪必修培训的进度，可能的值包括“已分配”、“进行中”或“已完成”。它提供了新员工合规就绪情况的快照。此状态对于“必修培训完成率”仪表板至关重要，使 HR 和合规团队能够监控进度并在培训逾期时进行干预。它比单纯的完成事件提供了更细致的视角。为何重要提供合规培训的清晰状态，帮助监控进度并确保按时完成强制性要求。获取方式此信息可能在 Oracle Learning Cloud 模块或与 Oracle HCM 集成的类似培训模块中。示例已分配进行中已完成逾期
	总入职周期时长 TotalOnboardingCycleTime	从接受录用到完成 30 天面谈的总时长。
描述这是一个案例级指标，衡量核心入职流程的端到端时长。它被计算为第一个活动（“接受邀约”）与关键融入里程碑（“执行 30 天面谈”）之间的时间差。此属性是“平均入职周期时间”KPI 和“整体入职周期时间”仪表板的主要衡量标准。它提供了流程效率的高级摘要，是新员工产出效率提升时间的关键指标。为何重要衡量入职流程的端到端效率，直接影响新员工融入并成为高效产出成员的速度。获取方式这是一个计算指标，根据每个入职案例的“接受邀约”和“执行 30 天面谈”活动的时间戳得出。示例 345600043200002592000
	新员工所属国家 NewHireCountry	新员工所在的国家/地区。
描述此属性指定新员工的地理位置。由于不同的劳动法和文化习俗，不同国家/地区的入职流程可能会有很大差异。按国家/地区分析流程有助于识别效率和合规性方面的地区差异。此信息是在可能的情况下实现流程标准化，同时兼顾必要的本地化差异的关键。为何重要允许按地理位置对入职流程进行细分，以识别不同地区的绩效和合规性差异。获取方式这是新员工核心员工档案中地点或分配详细信息的一部分。示例美国德国印度英国
	源系统 SourceSystem	提取入职数据的原始系统。
描述此属性标识数据的来源，在此流程中通常为“Oracle HCM Onboarding”。它可以是在数据转换过程中添加的静态值。在拥有多个集成系统的环境中，此字段对于数据治理和理解事件背景至关重要。它有助于区分可能在不同平台（例如单独的第三方背景调查供应商系统）中发生的入职活动。为何重要提供有关数据来源的基本背景信息，这对于多系统环境中的数据治理和故障排除非常重要。获取方式这通常是在数据提取和转换 (ETL) 过程中添加的静态值，用于标记数据集。示例 Oracle HCM OnboardingHCM_PRODOracleCloudHCM
	背景调查状态 BackgroundCheckStatus	背景调查流程的结果或状态。
描述此属性跟踪背景调查的结果，这是入职前阶段中一个关键且通常耗时较长的步骤。状态可包括“进行中”、“通过”或“需要审核”。监控此状态对于“入职前周期时间”仪表板非常重要。背景调查的延误或问题会显著影响新员工的入职日期，跟踪此属性有助于主动识别并管理这些潜在障碍。为何重要提供对关键入职前步骤的可见性，帮助跟踪进度并识别可能影响新员工入职日期的延误。获取方式此信息可能存储在 Oracle HCM Onboarding 中，或者可能需要从集成的第三方背景调查供应商处获取。示例通过需要审核进行中未启动
	雇佣类型 EmploymentType	指示新员工的雇佣安排，例如全职、兼职或合同工。
描述此属性根据雇佣合同对新员工进行分类。不同类型的员工通常具有不同的入职路径和要求。使用此属性进行过滤可以分析特定的入职流程，例如，比较承包商与全职员工的周期时间。这有助于为不同的员工群体定制和优化入职旅程。为何重要支持对不同人员类别的入职流程进行比较，确保每条路径都经过优化且合适。获取方式这是 Oracle HCM 中员工职位或分配记录中的标准字段。示例全职兼职合同工实习生
	首日准备就绪 IsFirstDayReady	一个计算标志，用于指示基本设备是否在新员工入职日期之前送达。
描述此布尔属性是通过将“设备已交付”和其他就绪活动的完成时间戳与“正式入职日期”进行比较而得出的。如果在第一天之前满足所有前提条件，则为 true。此属性直接支持“首日就绪率”KPI。高比率表明新员工入职顺畅且积极，使他们能够立即产生效益。低比率则表明配置流程中存在需要解决的系统性问题。为何重要衡量入职前准备工作的成效，这对于新员工的生产力及其对公司的初步体验至关重要。获取方式这是一个计算属性，通过比较每个案例的“设备已交付”时间戳与“正式入职日期”属性而得出。示例 truefalse

必填推荐可选

员工入职活动

这些是在事件日志中捕获的关键流程步骤和里程碑，旨在准确发现您的入职旅程。

6 推荐 10 可选

	活动	描述
	HR 个人资料已创建	此活动标志着在核心 HR 系统中创建正式员工记录，将候选人转换为员工。这是在 Oracle HCM 中创建新人员记录时记录的基本事件。
为何重要及时创建 HR 个人资料对于开启 IT 配置和薪资设置等下游活动至关重要。此环节的延迟会对整个流程产生连锁负面影响。获取方式从 Oracle Fusion HCM 中与入职 case 关联的个人记录（PER_ALL_PEOPLE_F 表）的创建日期中捕获。捕获请使用核心 HR 人员记录表中的 CREATION_DATE 字段。事件类型 explicit
	入职前文书已完成	代表新员工成功完成并提交所有必需入职前文档的时刻。当入职旅程中与文档相关的任务被标记为完成时，将捕获此事件。
为何重要确保符合新员工入职日期的合规性和准备就绪状态。从发送到完成之间的时间可以揭示新员工响应或系统易用性方面的瓶颈。获取方式捕获 Oracle HCM 中员工入职旅程内相关文档收集任务的完成 timestamp。捕获所有必需文档任务状态更改为“已完成”的时间戳。事件类型 inferred
	已完成必修培训	标志着新员工成功完成分配的必修培训模块。此事件在课程完成后会自动记录在 Oracle Learning Cloud 中。
为何重要对于合规和审计目的至关重要。通过将此 event 的 timestamp 与截止日期进行比较，可以监控准时完成率。获取方式这是从 Oracle Learning Cloud 模块中注册记录的完成日期捕获的显式事件。捕获学习注册状态更改为“已完成”的时间戳。事件类型 explicit
	已执行 30 天回访	此活动标志着新员工与经理之间第一次正式面谈（通常在 30 天后）的完成。当经理在入职旅程中完成相应任务时，将捕获此信息。
为何重要这是一个关键里程碑，标志着初始融入阶段的结束。它通常被用作衡量整体入职周期时间和有效性的终点。获取方式捕获 Oracle HCM 中新员工入职旅程内“30 天回访”任务的完成 timestamp。捕获 30 天面谈任务被标记为“已完成”的时间戳。事件类型 inferred
	已接受 Offer	此活动标志着入职流程的正式开始，发生在候选人正式接受工作邀约时。这通常是在 Oracle Recruiting 或 Onboarding 模块中，候选人状态更新为“接受邀约”或类似状态时捕获的。
为何重要这是每个入职案例的关键起点。分析此事件到其他事件的时间可以揭示入职前及入职的总周期时间。获取方式此事件通常是根据 Oracle Recruiting Cloud 中候选人工作申请记录的状态更改推断出来的，该模块与 Onboarding 模块集成。捕获识别候选人的申请状态变更为“已接受录用”或同等状态时的 timestamp。事件类型 inferred
	背调已完成	标志着背景调查流程的结束。此事件通常在相应的入职任务被标记为完成时记录，无论是通过手动操作还是自动化集成。
为何重要此活动为后续步骤扫清了障碍，是满足合规要求的关键里程碑。从启动到完成之间的持续时间是一项关键 KPI。获取方式捕获 Oracle HCM 中分配给员工的入职旅程内“背景调查”任务的完成 timestamp。捕获背景调查任务状态更改为“已完成”或“已关闭”的时间戳。事件类型 inferred
	IT 账号配置已启动	代表为新员工创建 IT 账号流程的开始。这通常是在入职旅程中创建或触发特定的 IT 配置任务时捕获的。
为何重要此活动对于确保新员工在入职第一天拥有系统访问权限至关重要。跟踪其启动情况有助于衡量 IT 交付的效率。获取方式捕获新员工入职旅程中“IT 配置”任务的创建或启动 timestamp。捕获 IT 相关任务的创建或状态更改为“进行中”的时间戳。事件类型 inferred
	入职前文书已发送	此活动在向新员工发送所需的入职前文档（如合同和政策确认书）时发生。这通常是入职旅程中的一个自动化步骤，负责分发电子文档以供签署。
为何重要跟踪文件发送时间是衡量文档管理流程效率并识别延迟的第一步。获取方式当文档发送给新员工时，这通常是在 Oracle 入职检查清单或旅程中记录的显式事件或任务创建。捕获 “分发文档”任务的 event 日志或创建 timestamp。事件类型 explicit
	入职办理完成	代表新员工整个入职流程的正式结束。当系统中的入职旅程或案例的整体状态设置为“已完成”时，将捕获此事件。
为何重要此活动为流程提供了一个确定的终点，从而能够准确衡量总周期时间和吞吐量。获取方式根据 PER_ALLOCATED_CHECKLISTS 表中员工的整体分配旅程或清单状态变更为“已完成”来推断。捕获当流程主状态更新为“已完成”时的 timestamp。事件类型 inferred
	团队介绍已完成	代表新员工正式介绍给团队。这通常是入职检查清单上的一项软性任务，由招聘经理标记为完成。
为何重要此活动是社交融入的一个指标，对于敬业度和留存至关重要。跟踪其完成情况有助于确保经理履行这一关键职责。获取方式捕获入职旅程中“向团队介绍新员工”任务的完成 timestamp。捕获团队介绍任务状态更改为“已完成”的时间戳。事件类型 inferred
	已分配入职旅程	当 HR 管理员为新员工分配特定的入职旅程或检查清单时发生。该旅程包含了新员工及其他利益相关者必须完成的一系列任务。
为何重要这标志着系统中引导式入职流程的正式开始。对此进行分析有助于了解流程是否标准化并得以及时启动。获取方式这是在将检查清单分配给人员时，在旅程管理表 (PER_ALLOCATED_CHECKLISTS) 中捕获的显式事件。捕获管理分配的旅程或检查清单的表中记录创建的时间戳。事件类型 explicit
	已分配必修培训	此活动在为新员工分配必需的合规或基于职位的培训时发生。这通常是通过与 Oracle Learning Cloud 集成（创建注册信息的地方）来捕获的。
为何重要这是跟踪合规培训的起点。它有助于确保在入职日期后及时分配培训。获取方式此事件可以从 Oracle Learning Cloud 模块（属于 HCM 套件）中的注册创建日期捕获。捕获学习项目注册记录创建的时间戳。事件类型 explicit
	已发起背景调查	代表为新员工启动背景调查流程的时间点，通常是通过与第三方供应商集成实现的。这通常记录为新员工入职旅程或检查清单中特定任务的开始。
为何重要背景调查的持续时间是一个常见的瓶颈。跟踪其起点和终点对于识别可能推迟正式入职日期的延误至关重要。获取方式捕获 Oracle HCM 中分配给员工的入职旅程内“背景调查”任务的创建或启动 timestamp。捕获背景调查任务创建或状态更改为“进行中”的时间戳。事件类型 inferred
	已进行首日迎新培训	代表新员工第一天入职培训课程的完成。这通常是入职旅程中的一个检查清单项目，由 HR 代表或招聘经理标记为完成。
为何重要确保所有新员工都能获得一致且完整的入职培训体验。跟踪此项有助于监控入职流程的标准化程度。获取方式捕获员工入职旅程中“首日迎新”任务的完成 timestamp。捕获当入职培训任务状态更新为“已完成”时的 timestamp。事件类型 inferred
	设备已交付	标志着新员工设备已成功交付的确认。这通常是由 IT 或后勤团队成员在入职流程中手动完成“设备已交付”任务来捕获的。
为何重要这是首日就绪的关键里程碑。从“订购设备”到此活动的周期时间是 IT 和设施部门绩效的关键 KPI。获取方式捕获 Oracle HCM 中新员工入职旅程内“确认设备交付”任务的完成 timestamp。捕获设备交付确认任务的状态更改为“已完成”的时间戳。事件类型 inferred
	设备已订购	当新员工设备（如笔记本电脑或手机）的请求被正式提交时，记录此活动。这通常是入职旅程中的一项任务，完成后表示订单已下达。
为何重要及时订购设备对于确保新员工“首日就绪”至关重要。此活动有助于衡量采购流程启动的速度。获取方式捕获入职旅程中“订购设备”任务的完成 timestamp，或与采购系统的集成 event。捕获设备订购任务的状态更改为“已完成”的时间戳。事件类型 inferred

推荐可选

提取指南

如何从Oracle HCM Onboarding获取数据

步骤

导航至 Oracle Transactional Business Intelligence (OTBI)：登录您的 Oracle HCM Cloud 实例。使用导航器菜单进入“工具”，然后选择“报告和分析”。这将打开 Business Intelligence 目录。
创建新分析：在 BI 目录中，点击工具栏中的“创建”按钮，然后从下拉菜单中选择“分析”。系统将提示您选择一个专题领域。
选择专题领域：在“选择专题领域”对话框中，搜索并选择“Recruiting - Onboarding Real Time”。该专题领域包含跟踪员工入职流程所需的 data。
访问高级 SQL 编辑器：选择专题领域后，您将进入分析编辑器。不要在“标准”选项卡中拖放列，而是导航到“高级”选项卡。这允许您输入自定义逻辑 SQL 查询。
粘贴逻辑 SQL 查询：在“高级”选项卡下的 SQL 编辑器窗口中，复制并粘贴本文档“query”部分提供的完整逻辑 SQL。此查询旨在合并来自多个源的 data，以创建全面的 event 日志。
设置查询筛选器：提供的查询包含 [START_DATE] 和 [END_DATE] 等占位符。强烈建议使用分析构建器中的“筛选器”部分为这些日期创建提示。这允许用户在运行报表时指定日期范围，从而提高性能。在“Onboarding Process Details”.“Process Creation Date”列上创建筛选器，并将运算符设置为“介于”。
检查并保存分析：导航到“结果”选项卡以预览 data。确保 OnboardingCase、ActivityName 和 EventTime 等列填充正确。如果结果看起来无误，请将分析保存在合适的共享文件夹中，并赋予其描述性名称，如“Process Mining - 员工入职 event 日志”。
运行并导出报表：针对所需的日期范围执行保存的分析。报表运行完成后，使用结果页面底部的“导出”选项。
Process Mining 格式：选择以“CSV”或“XML”格式导出 data。通常因其简洁性而首选 CSV 文件。确保导出的文件标题与您的 Process Mining 工具所需的属性匹配。如果按原样使用 SQL 查询，则不需要进一步的 data 转换。

配置

专题领域：分析必须使用“Recruiting - Onboarding Real Time”专题领域。这是 Oracle HCM 中入职流程和任务 data 的主要来源。
日期范围筛选器：应用日期范围筛选器对于管理性能和 data 量至关重要。建议针对“Onboarding Process Details”.“Process Creation Date”设置 3 到 6 个月的追溯期筛选。对于业务量极大的组织，可能需要缩短该周期。
Data 安全性：报表返回的 data 受用户安全配置文件的限制。请确保运行报表的用户拥有查看不同业务单位和法人实体所有相关入职 data 的必要权限。
入职流程状态：考虑为“Onboarding Process Details”.“Process Status”添加筛选器，仅包含相关的 case，例如“已完成”、“进行中”和“待处理”。这有助于排除已取消或错误的入职流程。
前提条件：创建和运行报表的用户必须具有 BI Author 权限的角色，例如“Human Capital Management Application Administrator”或具有同等 OTBI 和所需专题领域访问权限的自定义角色。

a 查询示例 config

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Offer Accepted' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Offer"."Accepted On Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Offer"."Accepted By Person Name" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."Offer"."Accepted On Date" IS NOT NULL

UNION ALL

SELECT
    T.OnboardingCase, T.ActivityName, T.EventTime, T.EventEndTime, T.PerformedByUser, T.NewHireDepartment, T.NewHireJobTitle, T.OfficialStartDate, T.ComplianceDueDate, T.HiringManager, T.ActivityDuration
FROM (
SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    CASE 
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Background Check Initiated'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Background Check Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Pre-Employment Paperwork Sent'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Pre-Employment Paperwork Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%IT Account%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'IT Account Provisioning Initiated'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Equipment Order%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Equipment Ordered'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Equipment Delivered%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Equipment Delivered'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Orientation%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'First Day Orientation Conducted'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Mandatory Training Assigned'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Mandatory Training Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Team Introduction%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Team Introduction Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%30-Day Check-in%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN '30-Day Check-in Performed'
        ELSE NULL
    END AS ActivityName,
    CASE
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%IT Account%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        ELSE CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" AS TIMESTAMP)
    END AS EventTime,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" AS TIMESTAMP) AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Task"."Completed By Display Name" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Due Date" AS DATE) AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    TIMESTAMPDIFF(SQL_TSI_DAY, "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date", "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date") AS ActivityDuration
FROM "Recruiting - Onboarding Real Time"
) T WHERE T.ActivityName IS NOT NULL

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'HR Profile Created' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Creation Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."New Hire"."Created By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."New Hire"."Creation Date" IS NOT NULL

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Onboarding Journey Assigned' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Creation Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Created By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time"

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Onboarding Completed' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Completion Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Last Updated By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Status" = 'Completed'

FETCH FIRST 65000 ROWS ONLY

步骤

导航至 Oracle Transactional Business Intelligence (OTBI)：登录您的 Oracle HCM Cloud 实例。使用导航器菜单进入“工具”，然后选择“报告和分析”。这将打开 Business Intelligence 目录。
创建新分析：在 BI 目录中，点击工具栏中的“创建”按钮，然后从下拉菜单中选择“分析”。系统将提示您选择一个专题领域。
选择专题领域：在“选择专题领域”对话框中，搜索并选择“Recruiting - Onboarding Real Time”。该专题领域包含跟踪员工入职流程所需的 data。
访问高级 SQL 编辑器：选择专题领域后，您将进入分析编辑器。不要在“标准”选项卡中拖放列，而是导航到“高级”选项卡。这允许您输入自定义逻辑 SQL 查询。
粘贴逻辑 SQL 查询：在“高级”选项卡下的 SQL 编辑器窗口中，复制并粘贴本文档“query”部分提供的完整逻辑 SQL。此查询旨在合并来自多个源的 data，以创建全面的 event 日志。
设置查询筛选器：提供的查询包含 [START_DATE] 和 [END_DATE] 等占位符。强烈建议使用分析构建器中的“筛选器”部分为这些日期创建提示。这允许用户在运行报表时指定日期范围，从而提高性能。在“Onboarding Process Details”.“Process Creation Date”列上创建筛选器，并将运算符设置为“介于”。
检查并保存分析：导航到“结果”选项卡以预览 data。确保 OnboardingCase、ActivityName 和 EventTime 等列填充正确。如果结果看起来无误，请将分析保存在合适的共享文件夹中，并赋予其描述性名称，如“Process Mining - 员工入职 event 日志”。
运行并导出报表：针对所需的日期范围执行保存的分析。报表运行完成后，使用结果页面底部的“导出”选项。
Process Mining 格式：选择以“CSV”或“XML”格式导出 data。通常因其简洁性而首选 CSV 文件。确保导出的文件标题与您的 Process Mining 工具所需的属性匹配。如果按原样使用 SQL 查询，则不需要进一步的 data 转换。

配置

专题领域：分析必须使用“Recruiting - Onboarding Real Time”专题领域。这是 Oracle HCM 中入职流程和任务 data 的主要来源。
日期范围筛选器：应用日期范围筛选器对于管理性能和 data 量至关重要。建议针对“Onboarding Process Details”.“Process Creation Date”设置 3 到 6 个月的追溯期筛选。对于业务量极大的组织，可能需要缩短该周期。
Data 安全性：报表返回的 data 受用户安全配置文件的限制。请确保运行报表的用户拥有查看不同业务单位和法人实体所有相关入职 data 的必要权限。
入职流程状态：考虑为“Onboarding Process Details”.“Process Status”添加筛选器，仅包含相关的 case，例如“已完成”、“进行中”和“待处理”。这有助于排除已取消或错误的入职流程。
前提条件：创建和运行报表的用户必须具有 BI Author 权限的角色，例如“Human Capital Management Application Administrator”或具有同等 OTBI 和所需专题领域访问权限的自定义角色。

a 查询示例 config

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Offer Accepted' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Offer"."Accepted On Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Offer"."Accepted By Person Name" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."Offer"."Accepted On Date" IS NOT NULL

UNION ALL

SELECT
    T.OnboardingCase, T.ActivityName, T.EventTime, T.EventEndTime, T.PerformedByUser, T.NewHireDepartment, T.NewHireJobTitle, T.OfficialStartDate, T.ComplianceDueDate, T.HiringManager, T.ActivityDuration
FROM (
SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    CASE 
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Background Check Initiated'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Background Check Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Pre-Employment Paperwork Sent'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Pre-Employment Paperwork Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%IT Account%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'IT Account Provisioning Initiated'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Equipment Order%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Equipment Ordered'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Equipment Delivered%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Equipment Delivered'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Orientation%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'First Day Orientation Conducted'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN 'Mandatory Training Assigned'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Mandatory Training Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Team Introduction%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN 'Team Introduction Completed'
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%30-Day Check-in%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" IS NOT NULL THEN '30-Day Check-in Performed'
        ELSE NULL
    END AS ActivityName,
    CASE
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Background Check%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Paperwork%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Configurable Form' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%IT Account%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        WHEN "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Name" LIKE '%Training%' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Task Type" = 'Learning' AND "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" IS NOT NULL THEN CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date" AS TIMESTAMP)
        ELSE CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" AS TIMESTAMP)
    END AS EventTime,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date" AS TIMESTAMP) AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Task"."Completed By Display Name" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Task"."Due Date" AS DATE) AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    TIMESTAMPDIFF(SQL_TSI_DAY, "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Start Date", "Recruiting - Onboarding Real Time"."Onboarding Task"."Actual Completion Date") AS ActivityDuration
FROM "Recruiting - Onboarding Real Time"
) T WHERE T.ActivityName IS NOT NULL

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'HR Profile Created' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Creation Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."New Hire"."Created By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."New Hire"."Creation Date" IS NOT NULL

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Onboarding Journey Assigned' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Creation Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Created By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time"

UNION ALL

SELECT
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Onboarding Process Identifier" AS OnboardingCase,
    'Onboarding Completed' AS ActivityName,
    CAST("Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Completion Date" AS TIMESTAMP) AS EventTime,
    NULL AS EventEndTime,
    "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Last Updated By" AS PerformedByUser,
    "Recruiting - Onboarding Real Time"."New Hire"."Department Name" AS NewHireDepartment,
    "Recruiting - Onboarding Real Time"."New Hire"."Job Name" AS NewHireJobTitle,
    CAST("Recruiting - Onboarding Real Time"."New Hire"."Start Date" AS DATE) AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    "Recruiting - Onboarding Real Time"."New Hire"."Manager Name" AS HiringManager,
    NULL AS ActivityDuration
FROM "Recruiting - Onboarding Real Time" WHERE "Recruiting - Onboarding Real Time"."Onboarding Process Details"."Process Status" = 'Completed'

FETCH FIRST 65000 ROWS ONLY

步骤

导航至 BI Publisher：登录您的 Oracle Fusion Cloud HCM 实例。使用“导航器”菜单进入“工具”>“报告和分析”。点击“浏览目录”按钮打开 BI Publisher 界面。
创建新 Data 模型：在 BI Publisher 目录中，导航至自定义文件夹，例如 /Shared Folders/Custom/Process Mining。点击“新建”图标并选择“Data 模型”。
定义 SQL 查询数据集：在 Data 模型编辑器中，点击“+”图标并选择“SQL 查询”。将出现一个新对话框。为数据集起一个描述性的名称，如“OnboardingEventLog”。选择“ApplicationDB_HCM”作为 Data 源。
输入 SQL 查询：复制本文档“query”部分提供的完整 SQL 查询，并将其粘贴到 SQL 查询文本区域。
定义参数：查询使用参数 :P_START_DATE 和 :P_END_DATE 来筛选日期范围。在 Data 模型编辑器中，转到“参数”部分。创建两个名为 P_START_DATE 和 P_END_DATE 的新参数。将它们的 data 类型设置为“日期”，并提供一个用户友好的显示标签。
保存 Data 模型：检查 Data 模型设置并点击“保存”图标。将其保存在您的自定义文件夹中，并赋予描述性名称，如“入职 event 日志 Data 模型”。您可以在保存前点击“Data”选项卡并输入日期来查看示例 data。
创建新报表：返回目录。点击“新建”并选择“报表”。在“创建报表”向导中，选择“使用 Data 模型”并找到您刚刚保存的 Data 模型。
配置报表布局：在报表向导中，选择一个简单的布局。选择“表格”布局，并将所有列拖放到表格中。这可确保输出文件包含所有必要的 data。点击“完成”并将报表保存为“入职 event 日志报表”等名称。
计划报表：查看新创建的报表，点击“操作”>“计划”。这将带您进入计划配置页面。
配置作业详细信息：在“常规”选项卡中，将输出格式设置为 CSV。在“输出”选项卡中，定义传输目的地。常见选项包括发送到内容服务器 (UCM)、SFTP 服务器或电子邮件。为了实现自动摄取，通常首选 SFTP 选项。
设置计划：在“计划”选项卡中，定义提取频率。您可以将其设置为每日、每周或按其他周期运行。为计划本身设置开始和结束日期。确保为报表运行填充日期参数（P_START_DATE、P_END_DATE）。
完成并监控：提交计划作业。您可以从“作业历史记录”页面监控其执行情况。该作业生成的 CSV 文件即为最终的 event 日志，可随时上传至 ProcessMind。

配置

Data 源：查询必须配置为使用 BI Publisher 中的 ApplicationDB_HCM data 源，以访问实时事务性 HCM data。
日期范围参数：在计划报表时，使用 :P_START_DATE 和 :P_END_DATE 参数至关重要。建议针对初始分析提取 3 到 6 个月的 data，这有助于平衡 data 量与流程洞察。对于持续监控，请为前一阶段安排每日或每周提取。
组织筛选器：查询可以使用 WHERE 子句进行扩展，以按特定的业务单位、法人实体或部门进行筛选。这对于分阶段推进或将分析重点放在组织的特定部分非常有用。
性能注意事项：UNION ALL 结构合并了多个查询，可能会消耗大量资源。对于招聘量极大的组织，请将报表安排在非高峰时段运行，以尽量减少对系统性能的影响。如果性能问题明显，请考虑为关键列添加索引。
前提条件：创建 data 模型和报表的用户必须拥有具有足够权限的角色，例如“BI Administrator”或自定义 BI 角色。这包括在 BI 目录中创建对象的权限，以及通过适当的 data 安全配置文件访问底层 HCM data 的权限。

a 查询示例 sql

WITH OnboardingBase AS (
    SELECT
        pcb.person_id,
        pcb.checklist_id,
        ppnf.full_name AS new_hire_name,
        papf_mgr.full_name AS hiring_manager_name,
        paam.assignment_id,
        paam.effective_start_date AS official_start_date,
        pjt.name AS job_title,
        hout.name AS department_name
    FROM
        ORA_CHECKLISTS_B pcb
        JOIN PER_ALL_ASSIGNMENTS_M paam ON pcb.person_id = paam.person_id
        JOIN PER_PERIODS_OF_SERVICE ppos ON paam.period_of_service_id = ppos.period_of_service_id AND ppos.date_start = paam.effective_start_date
        JOIN PER_ALL_PEOPLE_F ppnf ON pcb.person_id = ppnf.person_id
        JOIN PER_ALL_ASSIGNMENTS_M paam_mgr ON paam.manager_assignment_id = paam_mgr.assignment_id
        JOIN PER_ALL_PEOPLE_F papf_mgr ON paam_mgr.person_id = papf_mgr.person_id
        JOIN PER_JOBS_F_TL pjt ON paam.job_id = pjt.job_id AND pjt.language = 'US'
        JOIN HR_ORGANIZATION_UNITS_F_TL hout ON paam.organization_id = hout.organization_id AND hout.language = 'US'
    WHERE
        pcb.checklist_category = 'ONBOARDING'
        AND paam.assignment_type IN ('E', 'C') AND paam.primary_flag = 'Y' AND paam.assignment_status_type = 'ACTIVE'
        AND SYSDATE BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
        AND SYSDATE BETWEEN paam.effective_start_date AND paam.effective_end_date
        AND SYSDATE BETWEEN papf_mgr.effective_start_date AND papf_mgr.effective_end_date
        AND SYSDATE BETWEEN pjt.effective_start_date AND pjt.effective_end_date
        AND SYSDATE BETWEEN hout.effective_start_date AND hout.effective_end_date
        AND pcb.creation_date BETWEEN TO_DATE(:P_START_DATE, 'YYYY-MM-DD') AND TO_DATE(:P_END_DATE, 'YYYY-MM-DD')
)
-- 1. Offer Accepted
SELECT
    irc_cand.candidate_id AS OnboardingCase,
    'Offer Accepted' AS ActivityName,
    irc_sub.last_update_date AS EventTime,
    NULL AS EventEndTime,
    irc_sub.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    IRC_SUBMISSIONS irc_sub
    JOIN IRC_CANDIDATES irc_cand ON irc_sub.candidate_id = irc_cand.candidate_id
    JOIN OnboardingBase ob ON irc_cand.person_id = ob.person_id
WHERE
    irc_sub.status_code = 'ORA_OFFER_ACCEPTED'

UNION ALL

-- 2. Background Check Initiated
SELECT
    ob.person_id AS OnboardingCase,
    'Background Check Initiated' AS ActivityName,
    hct.creation_date AS EventTime,
    NULL AS EventEndTime,
    hct.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    hct.target_end_date AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'Background Check%'

UNION ALL

-- 3. Background Check Completed
SELECT
    ob.person_id AS OnboardingCase,
    'Background Check Completed' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    (hct.actual_completion_date - hct.creation_date) AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'Background Check%' AND hct.status = 'COMPLETED'

UNION ALL

-- 4. Pre-Employment Paperwork Sent
SELECT
    ob.person_id AS OnboardingCase,
    'Pre-Employment Paperwork Sent' AS ActivityName,
    hct.creation_date AS EventTime,
    NULL AS EventEndTime,
    hct.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    hct.target_end_date AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_type = 'DOCUMENT'

UNION ALL

-- 5. Pre-Employment Paperwork Completed
SELECT
    ob.person_id AS OnboardingCase,
    'Pre-Employment Paperwork Completed' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    (hct.actual_completion_date - hct.creation_date) AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_type = 'DOCUMENT' AND hct.status = 'COMPLETED'

UNION ALL

-- 6. HR Profile Created
SELECT
    ob.person_id AS OnboardingCase,
    'HR Profile Created' AS ActivityName,
    ppos.creation_date AS EventTime,
    NULL AS EventEndTime,
    ppos.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    PER_PERIODS_OF_SERVICE ppos
    JOIN OnboardingBase ob ON ppos.person_id = ob.person_id
WHERE ppos.person_type_id IN (SELECT person_type_id FROM PER_PERSON_TYPES_VL WHERE system_person_type = 'EMP')

UNION ALL

-- 7. Onboarding Journey Assigned
SELECT
    ob.person_id AS OnboardingCase,
    'Onboarding Journey Assigned' AS ActivityName,
    pcb.creation_date AS EventTime,
    NULL AS EventEndTime,
    pcb.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    ORA_CHECKLISTS_B pcb
    JOIN OnboardingBase ob ON pcb.checklist_id = ob.checklist_id

UNION ALL

-- 8. IT Account Provisioning Initiated
SELECT
    ob.person_id AS OnboardingCase,
    'IT Account Provisioning Initiated' AS ActivityName,
    hct.creation_date AS EventTime,
    NULL AS EventEndTime,
    hct.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    hct.target_end_date AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'IT Account Provisioning%'

UNION ALL

-- 9. Equipment Ordered
SELECT
    ob.person_id AS OnboardingCase,
    'Equipment Ordered' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'Order Equipment%' AND hct.status = 'COMPLETED'

UNION ALL

-- 10. Equipment Delivered
SELECT
    ob.person_id AS OnboardingCase,
    'Equipment Delivered' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'Confirm Equipment Delivered%' AND hct.status = 'COMPLETED'

UNION ALL

-- 11. First Day Orientation Conducted
SELECT
    ob.person_id AS OnboardingCase,
    'First Day Orientation Conducted' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'First Day Orientation%' AND hct.status = 'COMPLETED'

UNION ALL

-- 12. Mandatory Training Assigned
SELECT
    ob.person_id AS OnboardingCase,
    'Mandatory Training Assigned' AS ActivityName,
    we.creation_date AS EventTime,
    NULL AS EventEndTime,
    we.created_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    we.due_date AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    WLF_ENROLLMENTS we
    JOIN OnboardingBase ob ON we.person_id = ob.person_id
WHERE
    we.learning_item_type = 'ORA_COURSE' AND we.enrollment_status_type_id IN (SELECT status.enrollment_status_type_id FROM WLF_LEARNING_STATUSES_VL status WHERE status.status_group = 'ACTIVE')

UNION ALL

-- 13. Mandatory Training Completed
SELECT
    ob.person_id AS OnboardingCase,
    'Mandatory Training Completed' AS ActivityName,
    we.completion_date AS EventTime,
    NULL AS EventEndTime,
    we.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    (we.completion_date - we.creation_date) AS ActivityDuration
FROM
    WLF_ENROLLMENTS we
    JOIN OnboardingBase ob ON we.person_id = ob.person_id
WHERE
    we.learning_item_type = 'ORA_COURSE' AND we.enrollment_status_type_id IN (SELECT status.enrollment_status_type_id FROM WLF_LEARNING_STATUSES_VL status WHERE status.status_group = 'COMPLETED')

UNION ALL

-- 14. Team Introduction Completed
SELECT
    ob.person_id AS OnboardingCase,
    'Team Introduction Completed' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE 'Team Introduction%' AND hct.status = 'COMPLETED'

UNION ALL

-- 15. 30-Day Check-in Performed
SELECT
    ob.person_id AS OnboardingCase,
    '30-Day Check-in Performed' AS ActivityName,
    hct.actual_completion_date AS EventTime,
    NULL AS EventEndTime,
    hct.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    NULL AS ActivityDuration
FROM
    HRC_DL_TASKS_B hct
    JOIN OnboardingBase ob ON hct.allocated_to_id = ob.person_id AND hct.checklist_id = ob.checklist_id
WHERE
    hct.task_name LIKE '30-Day Check-in%' AND hct.status = 'COMPLETED'

UNION ALL

-- 16. Onboarding Completed
SELECT
    ob.person_id AS OnboardingCase,
    'Onboarding Completed' AS ActivityName,
    pcb.last_update_date AS EventTime,
    NULL AS EventEndTime,
    pcb.last_updated_by AS PerformedByUser,
    ob.department_name AS NewHireDepartment,
    ob.job_title AS NewHireJobTitle,
    ob.official_start_date AS OfficialStartDate,
    NULL AS ComplianceDueDate,
    ob.hiring_manager_name AS HiringManager,
    (pcb.last_update_date - pcb.creation_date) AS ActivityDuration
FROM
    ORA_CHECKLISTS_B pcb
    JOIN OnboardingBase ob ON pcb.checklist_id = ob.checklist_id
WHERE
    pcb.status = 'COMPLETED'

步骤

前提条件：确保您的系统中安装了 Python 3.6 或更高版本。您还需要一个具有相应安全角色（如“Human Capital Management Integration Specialist”）的 Oracle HCM Cloud 用户帐户，以便访问必要的 REST API。
安装 Python 库：打开终端或命令提示符，安装用于发出 API 请求和处理 data 的必要 Python 库。运行命令：pip install requests pandas。
保存 Python 脚本：复制“query”部分提供的完整 Python 脚本，并将其保存为名为 extract_onboarding_log.py 的文件。
配置脚本参数：在文本编辑器中打开保存的脚本。找到文件顶部的配置部分，并将 HCM_URL、USERNAME、PASSWORD、START_DATE 和 END_DATE 的占位符替换为您特定的 Oracle HCM 环境详细信息和所需的日期范围。
识别任务名称：脚本会将 Oracle HCM 中的特定任务名称映射到标准化的活动名称。查看脚本中的 TASK_ACTIVITY_MAPPING 字典，并更新键（例如“Background Screening”、“Complete New Hire Paperwork”），以匹配您组织入职旅程中使用的确切任务名称。
执行脚本：在终端或命令提示符中使用命令 python extract_onboarding_log.py 运行脚本。脚本将开始身份验证并获取 data。
监控执行过程：脚本将在控制台打印进度消息，显示已处理的旅程数量。对于大 data 量，由于需要对 API 结果进行分页处理，此过程可能需要一些时间。
检查输出：脚本成功完成后，将在同一目录下生成一个名为 onboarding_event_log.csv 的 CSV 文件。该文件包含提取的 event 日志。
准备上传：打开 onboarding_event_log.csv 文件。验证列标题是否与所需属性匹配：OnboardingCase、ActivityName、EventTime 以及其他可选字段。该文件现在可以上传到 ProcessMind 了。

配置

API 凭据：脚本需要 Oracle HCM 用户的 USERNAME 和 PASSWORD，该用户应具有访问 /hcmRestApi/resources/11.13.18.05/onboardingJourneys 和 /hcmRestApi/resources/11.13.18.05/workers 端点的权限。
HCM URL：HCM_URL 变量必须设置为 Oracle HCM Cloud 实例的基准 URL，例如 https://[your-pod].fa.em2.oraclecloud.com。
日期范围：START_DATE 和 END_DATE 参数（格式为 'YYYY-MM-DD'）根据最后更新日期筛选入职旅程。建议从 3 到 6 个月的时间段开始，以便管理 data 量。
任务名称映射：TASK_ACTIVITY_MAPPING 字典对于正确提取活动至关重要。您必须自定义此映射，以反映您特定的 Oracle HCM Onboarding 设置中配置的任务名称。
API 分页限制：LIMIT 变量控制每次 API 调用获取的记录数。默认值 100 通常是安全的，但可以根据系统性能和 API 速率限制进行调整。
安全角色：用户帐户必须拥有授予访问“Recruiting and Candidate Experience Management”和“Person Management”功能区域权限的角色，通常由“Human Capital Management Integration Specialist”等角色涵盖。

a 查询示例 python

import requests
import pandas as pd
import json
from datetime import datetime

class=class="hl-string">"hl-comment"># --- Configuration ---
HCM_URL = class="hl-string">"https://[your-pod].fa.em2.oraclecloud.com"
USERNAME = class="hl-string">"[your_api_user]"
PASSWORD = class="hl-string">"[your_api_password]"
START_DATE = class="hl-string">"2023-01-01"
END_DATE = class="hl-string">"2023-12-31"

class=class="hl-string">"hl-comment"># --- Mappings ---
class=class="hl-string">"hl-comment"># IMPORTANT: Update the keys in this dictionary to match the exact Task Names in your Oracle HCM setup.
TASK_ACTIVITY_MAPPING = {
    class="hl-string">'Background Check': (class="hl-string">'Background Check Initiated', class="hl-string">'Background Check Completed'),
    class="hl-string">'Pre-Employment Paperwork': (class="hl-string">'Pre-Employment Paperwork Sent', class="hl-string">'Pre-Employment Paperwork Completed'),
    class="hl-string">'IT Account Provisioning': (class="hl-string">'IT Account Provisioning Initiated', None),
    class="hl-string">'Order Equipment': (class="hl-string">'Equipment Ordered', None),
    class="hl-string">'Confirm Equipment Delivery': (None, class="hl-string">'Equipment Delivered'),
    class="hl-string">'First Day Orientation': (None, class="hl-string">'First Day Orientation Conducted'),
    class="hl-string">'Assign Mandatory Training': (class="hl-string">'Mandatory Training Assigned', None),
    class="hl-string">'Complete Mandatory Training': (None, class="hl-string">'Mandatory Training Completed'),
    class="hl-string">'Introduce New Hire to Team': (None, class="hl-string">'Team Introduction Completed'),
    class="hl-string">'30-Day Manager Check-in': (None, class="hl-string">'30-Day Check-in Performed')
}

class=class="hl-string">"hl-comment"># --- Main Extraction Logic ---
def get_paginated_data(session, url, params):
    class="hl-string">"""Fetches all pages of data from a given HCM REST API endpoint."""
    all_items = []
    offset = 0
    limit = 100
    while True:
        params[class="hl-string">'offset'] = offset
        params[class="hl-string">'limit'] = limit
        try:
            response = session.get(url, params=params)
            response.raise_for_status()
            data = response.json()
            items = data.get(class="hl-string">'items', [])
            all_items.extend(items)
            if not data.get(class="hl-string">'hasMore', False):
                break
            offset += limit
        except requests.exceptions.RequestException as e:
            print(fclass="hl-string">"Error fetching data from {url}: {e}")
            break
    return all_items

def get_worker_details(session, person_id):
    class="hl-string">"""Fetches details for a single worker."""
    url = fclass="hl-string">"{HCM_URL}/hcmRestApi/resources/11.13.18.05/workers"
    params = {
        class="hl-string">'q': fclass="hl-string">'PersonId={person_id}',
        class="hl-string">'fields': class="hl-string">'CreationDate,assignments,personNumber',
        class="hl-string">'expand': class="hl-string">'assignments'
    }
    worker_data = get_paginated_data(session, url, params)
    if worker_data and worker_data[0]:
        return worker_data[0]
    return None

def main():
    class="hl-string">"""Main function to orchestrate the extraction process."""
    event_log = []
    processed_journeys = 0

    with requests.Session() as session:
        session.auth = (USERNAME, PASSWORD)

        journeys_url = fclass="hl-string">"{HCM_URL}/hcmRestApi/resources/11.13.18.05/onboardingJourneys"
        journeys_params = {
            class="hl-string">'q': fclass="hl-string">'LastUpdateDate between \'{START_DATE}\class="hl-string">' and \'{END_DATE}\class="hl-string">'',
            class="hl-string">'fields': class="hl-string">'JourneyId,PersonId,PersonNumber,CreationDate,CompletedDate,JourneyName,tasks',
            class="hl-string">'expand': class="hl-string">'tasks'
        }

        print(class="hl-string">"Fetching onboarding journeys...")
        journeys = get_paginated_data(session, journeys_url, journeys_params)
        print(fclass="hl-string">"Found {len(journeys)} journeys to process.")

        for journey in journeys:
            person_id = journey.get(class="hl-string">'PersonId')
            if not person_id:
                continue

            case_id = journey.get(class="hl-string">'PersonNumber') or person_id

            class=class="hl-string">"hl-comment"># Fetch worker details for additional attributes
            worker = get_worker_details(session, person_id)
            if not worker:
                continue
            
            assignment = worker.get(class="hl-string">'assignments', [{}])[0] if worker.get(class="hl-string">'assignments') else {}
            new_hire_dept = assignment.get(class="hl-string">'DepartmentName')
            new_hire_job = assignment.get(class="hl-string">'JobName')
            official_start_date = assignment.get(class="hl-string">'EffectiveStartDate')
            hiring_manager_id = assignment.get(class="hl-string">'ManagerId')

            class=class="hl-string">"hl-comment"># 1. HR Profile Created
            if worker.get(class="hl-string">'CreationDate'):
                event_log.append({
                    class="hl-string">'OnboardingCase': case_id,
                    class="hl-string">'ActivityName': class="hl-string">'HR Profile Created',
                    class="hl-string">'EventTime': worker[class="hl-string">'CreationDate'],
                    class="hl-string">'PerformedByUser': class="hl-string">'System',
                    class="hl-string">'NewHireDepartment': new_hire_dept,
                    class="hl-string">'NewHireJobTitle': new_hire_job,
                    class="hl-string">'OfficialStartDate': official_start_date,
                    class="hl-string">'HiringManager': hiring_manager_id
                })
            
            class=class="hl-string">"hl-comment"># 2. Offer Accepted (using start date as a proxy)
            if official_start_date:
                event_log.append({
                    class="hl-string">'OnboardingCase': case_id,
                    class="hl-string">'ActivityName': class="hl-string">'Offer Accepted',
                    class="hl-string">'EventTime': official_start_date, class=class="hl-string">"hl-comment"># Approximation, actual acceptance might be earlier
                    class="hl-string">'PerformedByUser': journey.get(class="hl-string">'PersonNumber'),
                    class="hl-string">'NewHireDepartment': new_hire_dept,
                    class="hl-string">'NewHireJobTitle': new_hire_job,
                    class="hl-string">'OfficialStartDate': official_start_date,
                    class="hl-string">'HiringManager': hiring_manager_id
                })

            class=class="hl-string">"hl-comment"># 3. Onboarding Journey Assigned
            if journey.get(class="hl-string">'CreationDate'):
                event_log.append({
                    class="hl-string">'OnboardingCase': case_id,
                    class="hl-string">'ActivityName': class="hl-string">'Onboarding Journey Assigned',
                    class="hl-string">'EventTime': journey[class="hl-string">'CreationDate'],
                    class="hl-string">'PerformedByUser': class="hl-string">'System',
                    class="hl-string">'NewHireDepartment': new_hire_dept,
                    class="hl-string">'NewHireJobTitle': new_hire_job,
                    class="hl-string">'OfficialStartDate': official_start_date,
                    class="hl-string">'HiringManager': hiring_manager_id
                })

            class=class="hl-string">"hl-comment"># 4. Process Tasks from the Journey
            tasks = journey.get(class="hl-string">'tasks', [])
            for task in tasks:
                task_name = task.get(class="hl-string">'TaskName')
                initiating_activity, completing_activity = None, None
                
                class=class="hl-string">"hl-comment"># Find a matching activity from the mapping
                for key in TASK_ACTIVITY_MAPPING:
                    if key.lower() in task_name.lower():
                        initiating_activity, completing_activity = TASK_ACTIVITY_MAPPING[key]
                        break
                
                class=class="hl-string">"hl-comment"># Create event for initiated/sent activities
                if initiating_activity and task.get(class="hl-string">'CreationDate'):
                    event_log.append({
                        class="hl-string">'OnboardingCase': case_id,
                        class="hl-string">'ActivityName': initiating_activity,
                        class="hl-string">'EventTime': task[class="hl-string">'CreationDate'],
                        class="hl-string">'PerformedByUser': task.get(class="hl-string">'PerformerName', class="hl-string">'System'),
                        class="hl-string">'NewHireDepartment': new_hire_dept,
                        class="hl-string">'NewHireJobTitle': new_hire_job,
                        class="hl-string">'OfficialStartDate': official_start_date,
                        class="hl-string">'HiringManager': hiring_manager_id,
                        class="hl-string">'ComplianceDueDate': task.get(class="hl-string">'DueDate')
                    })

                class=class="hl-string">"hl-comment"># Create event for completed activities
                if completing_activity and task.get(class="hl-string">'CompletedDate'):
                    event_log.append({
                        class="hl-string">'OnboardingCase': case_id,
                        class="hl-string">'ActivityName': completing_activity,
                        class="hl-string">'EventTime': task[class="hl-string">'CompletedDate'],
                        class="hl-string">'EventEndTime': task.get(class="hl-string">'CompletedDate'),
                        class="hl-string">'PerformedByUser': task.get(class="hl-string">'PerformerName', class="hl-string">'System'),
                        class="hl-string">'NewHireDepartment': new_hire_dept,
                        class="hl-string">'NewHireJobTitle': new_hire_job,
                        class="hl-string">'OfficialStartDate': official_start_date,
                        class="hl-string">'HiringManager': hiring_manager_id,
                        class="hl-string">'ActivityDuration': (datetime.fromisoformat(task[class="hl-string">'CompletedDate'].replace(class="hl-string">'Z', class="hl-string">'+00:00')) - datetime.fromisoformat(task[class="hl-string">'CreationDate'].replace(class="hl-string">'Z', class="hl-string">'+00:00'))).total_seconds() if task.get(class="hl-string">'CreationDate') else None
                    })

            class=class="hl-string">"hl-comment"># 5. Onboarding Completed
            if journey.get(class="hl-string">'CompletedDate'):
                event_log.append({
                    class="hl-string">'OnboardingCase': case_id,
                    class="hl-string">'ActivityName': class="hl-string">'Onboarding Completed',
                    class="hl-string">'EventTime': journey[class="hl-string">'CompletedDate'],
                    class="hl-string">'PerformedByUser': class="hl-string">'System',
                    class="hl-string">'NewHireDepartment': new_hire_dept,
                    class="hl-string">'NewHireJobTitle': new_hire_job,
                    class="hl-string">'OfficialStartDate': official_start_date,
                    class="hl-string">'HiringManager': hiring_manager_id
                })

            processed_journeys += 1
            if processed_journeys % 50 == 0:
                print(fclass="hl-string">"Processed {processed_journeys}/{len(journeys)} journeys...")

    print(fclass="hl-string">"Total events created: {len(event_log)}")

    if not event_log:
        print(class="hl-string">"No events were generated. Please check your configuration and date range.")
        return

    class=class="hl-string">"hl-comment"># Create DataFrame and save to CSV
    df = pd.DataFrame(event_log)
    df_sorted = df.sort_values(by=[class="hl-string">'OnboardingCase', class="hl-string">'EventTime'])
    df_sorted.to_csv(class="hl-string">'onboarding_event_log.csv', index=False)
    print(class="hl-string">"Extraction complete. Event log saved to onboarding_event_log.csv")

if __name__ == class="hl-string">"__main__":
    main()

您的员工入职数据模板

您的员工入职数据模板

员工入职属性

员工入职活动

提取指南

用于入职流程的 Oracle HCM OTBI 报表

步骤

配置

a 查询示例 config

用于入职数据的 Oracle HCM Extracts 工具

步骤

配置

a 查询示例 config

Oracle BI Publisher SQL 数据模型提取

步骤

配置

a 查询示例 sql

通过 Oracle HCM REST API 进行 Python 脚本提取

步骤

配置

a 查询示例 python

准备好开始了吗？

立即开始优化您的员工入职流程

您的员工入职数据模板

您的员工入职数据模板

员工入职属性

员工入职活动

提取指南

用于入职流程的 Oracle HCM OTBI 报表

步骤

配置

a 查询示例 config

用于入职数据的 Oracle HCM Extracts 工具

步骤

配置

a 查询示例 config

Oracle BI Publisher SQL 数据模型提取

步骤

配置

a 查询示例 sql

通过 Oracle HCM REST API 进行 Python 脚本提取

步骤

配置

a 查询示例 python

我们重视您的隐私

准备好开始了吗？

立即开始优化您的员工入职流程