您的生产计划数据模板
Oracle制造云
您的生产计划数据模板
此模板全面介绍如何收集分析生产计划流程所需的数据，包括应收集的关键属性、应跟踪的核心活动，以及从源系统提取这些信息的实用指导。使用此资源简化数据准备工作，开启您的流程挖掘之旅。
- 建议收集的属性
- 需要跟踪的核心活动
- 实用提取指南
刚接触事件日志？了解 如何创建流程挖掘事件日志.
生产计划属性
以下是建议纳入事件日志的数据字段，用于全面分析生产计划并深入了解运营情况。
5 必需 6 建议 9 可选
| 名称 | 说明 | ||
|---|---|---|---|
| 事件时间戳 EventTimestamp | 具体活动或事件发生的准确日期和时间。 | ||
| 说明 该属性记录流程中每项活动的时间戳，为理解事件顺序和衡量事件间持续时间提供必要的时间背景。 在流程分析中，该时间戳对于计算周期时间、等待时间和整体流程时长至关重要。它支持绩效监控、瓶颈识别，以及分析流程时序如何影响计划执行率等结果。 为什么重要 该时间戳对于所有基于时间的流程挖掘分析都至关重要，包括计算时长、发现瓶颈，以及构建符合实际时间顺序的流程图。 获取位置 此信息通常与Oracle Manufacturing Cloud的事务表或日志表中的事件或状态数据一起存储，通常表现为创建日期或最后更新日期。 示例 2023-10-26T08:00:00Z2023-10-26T14:30:15Z2023-11-05T10:11:45Z | |||
| 活动名称 ActivityName | 生产计划流程中发生的具体事件或任务的名称。 | ||
| 说明 该属性描述生产订单生命周期中的具体步骤或里程碑，例如“Work Order Created”“Materials Issued”或“Production Started”。每项活动都代表流程中的一个独立节点。 流程挖掘利用这些信息构建流程图，展示所有活动的顺序和频率。分析活动是理解流程、识别步骤之间瓶颈以及衡量各阶段耗时的基础。 为什么重要 活动名称是流程挖掘的核心要求，因为它定义流程图中的步骤，并支持流程路径的可视化与分析。 获取位置 通常根据Oracle Manufacturing Cloud中的事件日志、交易状态或用于跟踪工单生命周期的特定事件数据表生成。 示例 工单已创建工单已发布物料已发放生产已开始工单已完成 | |||
| 生产订单 ProductionOrderNumber | 生产订单的唯一标识符，是Production Planning流程的主要案例标识符。 | ||
| 说明 Production Order编号可唯一标识生产特定数量产品的请求。它是连接所有相关计划、排程、执行和关闭活动的核心案例标识符。 在流程挖掘中，按该编号对事件进行分组分析，可以完整查看生产生命周期。您可以跟踪每个订单的处理过程、衡量周期时间、识别常见路径，并定位与标准流程的偏差。 为什么重要 这是连接所有相关生产事件的关键案例标识符，可对每个订单的完整生产计划和执行流程开展全面分析。 获取位置 该标识符是Oracle Manufacturing Cloud的核心元素，通常位于工单抬头和交易数据表中。请查阅WIP_ENTITIES或类似的工单数据表。 示例 WO-2024-00123PROD-58974M450001852 | |||
| 数据最后更新时间 LastDataUpdateTimestamp | 表示该事件数据上次从源系统刷新或提取时间的时间戳。 | ||
| 说明 该属性记录从源系统最近一次提取数据的日期和时间。它是一个元数据字段，用于反映待分析数据集的新鲜度。 了解分析结果的时效性至关重要。该信息可以帮助您了解流程数据的当前程度，确保决策基于数据时效明确的数据。 为什么重要 透明呈现数据的新鲜度，帮助您了解分析所依据的数据截至何时，以及预计何时进行下一次数据更新。 获取位置 该值通常在数据提取、转换和加载（ETL）过程中生成并写入数据集。 示例 2024-01-15T02:00:00Z2024-01-16T02:00:00Z2024-01-17T02:00:00Z | |||
| 源系统 SourceSystemIdentifier | 提取生产计划数据的系统。 | ||
| 说明 该属性用于标识源信息系统，例如Oracle Manufacturing Cloud。在需要整合多个系统数据以全面了解流程的环境中，这一属性尤其有用。 分析时，您可以根据数据来源筛选流程数据，从而比较不同系统中的流程，或仅保留特定来源的数据进行针对性分析。 为什么重要 它提供了有关数据来源的重要背景信息，对于多系统环境中的数据治理、验证和分析十分重要。 获取位置 该值通常是静态值（“Oracle Manufacturing Cloud”），在数据提取、转换和加载（ETL）过程中添加。 示例 Oracle制造云Oracle Fusion Cloud SCMOMC_PROD_INSTANCE_1 | |||
| 产品代码 ProductCode | 正在生产的产品的唯一标识符。 | ||
| 说明 该属性用于指定生产订单对应的物料或产品，是细分和分析生产流程的重要维度。 借助产品代码，分析人员可以比较不同产品的生产流程，从而回答“哪些产品的周期时间最长？”或“某些产品系列是否存在特有的流程偏差？”等问题。它是Production Performance Throughput仪表板的关键属性。 为什么重要 支持按产品细分流程分析，揭示特定产品的瓶颈、延迟或低效环节。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息通常存储在工单明细中，并通过WIP_DISCRETE_JOBS等表关联至物料主数据表。 示例 FG-1001-AAS-5432-BLUERAW-987-C | |||
| 工单状态 WorkOrderStatus | 事件发生时生产订单的当前状态。 | ||
| 说明 该属性反映生产订单所处的状态，例如“未发布”“已发布”“暂停”“已完成”或“已取消”。状态可以直观呈现订单所处的生命周期阶段。 按工单状态分析流程，有助于了解订单在不同状态之间的分布情况。您还可以借此识别长时间停留在某一状态的订单，或仅筛选已完成或进行中的订单进行分析。 为什么重要 清晰呈现订单进度和结果，支持分析流程瓶颈、延迟和完成率。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能位于WIP_DISCRETE_JOBS等工单头表中，并与状态列关联。 示例 已发布已完成暂停已取消 | |||
| 生产工厂 ProductionPlant | 执行生产订单的制造设施或工厂。 | ||
| 说明 该属性表示负责生产的实际地点或组织单位，是比较不同地点流程绩效的重要维度。 按生产工厂分析，可以进行基准比较，并识别特定地点的最佳实践或系统性问题。Resource Utilization Bottlenecks和Production Performance Throughput等仪表板会使用该属性了解各地点的具体绩效。 为什么重要 支持比较不同制造地点的流程效率和绩效，突出区域性瓶颈或最佳实践。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息通常属于工单定义的一部分，常称为组织或库存组织。 示例 地点A－上海工厂001－奥斯汀德国工厂 | |||
| 计划员 Planner | 负责管理生产订单的用户或计划员。 | ||
| 说明 该属性用于标识负责监督生产订单计划和执行的员工或角色，可以是姓名、ID或计划组。 按计划员分析流程，有助于了解工作量分配，并识别与流程延迟或高效执行相关的计划员或团队。它是Delay Root Cause & Activity Impact仪表板的重要属性，可用于发现与绩效相关的人为因素。 为什么重要 帮助识别个人计划员或团队对流程绩效的影响，从而支持针对性培训和工作量平衡。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能存储在工单头表或相关分配表中。 示例 John SmithPlannerGroup_AUSER12345 | |||
| 计划开始日期 PlannedStartDate | 计划开始生产该订单的日期。 | ||
| 说明 该属性包含计划阶段为生产订单设定的目标开始日期，是衡量实际绩效的基准。 该日期对于Production Order Release On-Time Rate KPI至关重要，需要与实际发布时间戳进行比较。它有助于评估计划和排程流程的有效性，并识别提前或延迟开始的情况。 为什么重要 这是衡量生产开始阶段计划执行情况和准时绩效的重要基准。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能位于工单排程表或主工单头表中。 示例 2023-11-01T08:00:00Z2023-11-15T09:00:00Z2023-12-01T00:00:00Z | |||
| 计划结束日期 PlannedEndDate | 计划完成该订单生产的日期。 | ||
| 说明 该属性包含生产订单的目标完成日期，是生产团队计划达成的截止时间。 该日期对于计算Production Schedule Adherence Rate KPI至关重要，该KPI会将计划日期与实际完成时间戳进行比较。它有助于量化生产目标的达成情况，也是Production Schedule Adherence仪表板的主要指标。 为什么重要 作为衡量准时完成情况和整体生产计划执行情况的主要基准。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能位于工单排程表或主工单头表中，例如WIP_DISCRETE_JOBS。 示例 2023-11-10T17:00:00Z2023-11-20T17:00:00Z2023-12-10T17:00:00Z | |||
| 事件结束时间 EventEndTime | 特定活动或事件完成的准确日期和时间。 | ||
| 说明 该属性记录具有持续时间的活动的完成时间戳，与StartTime共同定义活动的具体时间范围。 同时具备开始和结束时间时，可以准确计算每项活动的实际处理时间。与根据下一事件的开始时间推断时长相比，这种方式更精确，因为它能够区分等待时间。 为什么重要 支持精确计算活动处理时间，并将其与活动之间的等待时间区分开来。 获取位置 该信息可能位于同时记录操作开始和结束时间的事件日志或事务表中。 示例 2023-10-26T08:05:10Z2023-10-26T15:00:00Z2023-11-05T10:11:55Z | |||
| 完成数量 CompletedQuantity | 实际成功生产并完成的产品数量。 | ||
| 说明 该属性记录生产订单完成所有操作后的最终产量。由于报废、良率损失或超额生产等因素，该数量可能与计划数量不同。 这是“计划数量与实际数量偏差”KPI使用的“实际”值，对于分析生产效率、良率以及计划产量与实际产量之间差异的原因至关重要。 为什么重要 衡量生产流程的实际产出，为良率、效率和计划准确性分析提供重要依据。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息通常存储在WIP_DISCRETE_JOBS等工单表中，字段名为“QUANTITY_COMPLETED”。 示例 9849501255 | |||
| 总周期时间 TotalCycleTime | 生产订单从创建到完成的总时长。 | ||
| 说明 该属性是一个计算指标，表示每个生产订单从第一个事件（例如“工单已创建”）到最后一个事件（例如“工单已完成”）经过的总时间。 这是衡量整体流程绩效的主要KPI，也是End-to-End Production Lead Time仪表板的核心指标。它提供了效率的高层视图，并帮助跟踪一段时间内的改进情况。 为什么重要 这是衡量每个订单端到端生产流程效率的关键绩效指标。 获取位置 源系统不提供该属性。它在数据转换过程中计算得出，方法是按案例用最大时间戳减去最小时间戳。 示例 10天4小时3周2天15.5天 | |||
| 按时发布状态 ReleaseOnTimeStatus | 表示订单按时、提前或延迟发布的计算状态。 | ||
| 说明 该属性通过比较“计划开始日期”和“工单已发布”活动的实际时间戳计算得出，专门反映流程初始发布步骤的执行情况。 该状态直接支持Production Order Release On-Time Rate KPI及相关仪表板，帮助定位生产执行周期最开始阶段发生的延迟。 为什么重要 帮助专门识别和分析将工单发布到生产现场这一关键步骤中的延迟。 获取位置 该属性在数据转换过程中计算得出，方法是将“PlannedStartDate”属性与发布事件的时间戳进行比较。 示例 按时延迟提前 | |||
| 物料可用性 MaterialAvailabilityStatus | 表示生产订单所需物料是否可用。 | ||
| 说明 该属性显示物料可用性状态，通常包括“可用”“短缺”或“部分可用”。系统会将库存水平与订单物料清单进行比对，以确定该状态。 它是Material Shortage Impact Analysis仪表板及相关KPI的关键属性。分析该属性有助于量化物料短缺对生产开始时间和整体周期时间的影响。 为什么重要 直接衡量物料短缺对生产计划的影响，而物料短缺是造成重大延迟的常见原因。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能不是直接字段，而是通过检查工单的组件可用性计算得出。 示例 可用短缺部分可用 | |||
| 生产优先级 ProductionPriority | 表示生产订单紧急程度或优先级的代码或值。 | ||
| 说明 该属性为生产订单分配优先级，例如“高”“中”或“低”。当资源受限时，它可以帮助排程人员和生产团队确定工作优先顺序。 在Delay Root Cause & Activity Impact仪表板中，您可以将优先级作为维度，分析高优先级订单是否确实处理得更快，或同样存在延迟，从而评估优先级机制的有效性。 为什么重要 帮助分析优先级机制是否有效，以及高优先级订单是否比低优先级订单处理得更快。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息可能是工单头表中的标准字段或自定义字段。 示例 高中低19 | |||
| 生产线 ProductionLine | 工厂内分配给该工单的具体装配线或生产线。 | ||
| 说明 该属性用于标识负责执行生产订单的具体设备或工作中心组。与生产工厂相比，它提供了更细粒度的信息。 在Resource Utilization Bottlenecks仪表板中，该属性用于定位特定生产线或工作中心相关的延迟，帮助识别产能约束，并在更细的层级优化资源分配。 为什么重要 支持在具体生产线或工作中心层面细致分析资源利用率并识别瓶颈。 获取位置 请参阅Oracle Manufacturing Cloud文档。该信息通常位于工单工艺路线或操作明细中。 示例 LINE_01_PACKAGINGASSEMBLY_CELL_3BCNC_MACHINE_5 | |||
| 计划执行状态 ScheduleAdherenceStatus | 表示订单按时、提前或延迟完成的计算状态。 | ||
| 说明 该属性通过比较“计划结束日期”和“工单已完成”活动的实际时间戳计算得出，为计划执行情况提供清晰的分类结果。 该状态是Production Schedule Adherence仪表板及其KPI的基础。您可以据此快速筛选所有延迟订单，并调查延迟的根本原因。 为什么重要 提供清晰简洁的准时绩效指标，便于识别和分析未能按期完成的订单。 获取位置 该属性在数据转换过程中计算得出，方法是将“PlannedEndDate”属性与完成事件的时间戳进行比较。 示例 按时延迟提前 | |||
| 计划数量 PlannedQuantity | 订单计划生产的产品数量。 | ||
| 说明 该属性表示特定生产订单的目标产量，在计划阶段根据需求和产能设定。 该值是“计划数量与实际数量偏差”KPI的关键输入，需要与实际产量进行比较。分析该指标有助于评估计划准确性、良率和报废水平。 为什么重要 为评估产量准确性、良率和报废情况提供数量基准，对产能和物料计划至关重要。 获取位置 请参阅Oracle Manufacturing Cloud文档。这是WIP_DISCRETE_JOBS等工单表中的标准字段，通常命名为“START_QUANTITY”或类似名称。 示例 10050001250 | |||
必需 建议 可选
生产计划活动
以下是建议在事件日志中记录的关键流程步骤和里程碑，用于准确发现流程并识别瓶颈。
5 建议 8 可选
| 活动 | 说明 | ||
|---|---|---|---|
| 工单已关闭 | 这是生产完成后的最终行政步骤，用于结算全部成本、计算并过账差异。从财务和物流角度看，该步骤会正式关闭订单。 | ||
| 为什么重要 “Completed”到“Closed”之间的时间，可以揭示财务结账或成本核算流程中的低效环节，也为整个工单生命周期提供明确终点。 获取位置 这是在运行期末结账流程，或用户手动将工单状态变更为“Closed”时捕获的显式事件。工单中通常会存储关闭日期时间戳。 采集 从工单状态设置为“Closed”时的时间戳中获取。 事件类型 explicit | |||
| 工单已创建 | 该活动表示在Oracle Manufacturing Cloud中创建生产订单，也称为工单。它是制造特定数量产品的正式指令，通常由主生产计划或销售订单生成。 | ||
| 为什么重要 作为生产流程的起点，该活动对于衡量整体周期时间和分析从需求到生产信号的延迟至关重要。它有助于识别生产需求需要多长时间才能正式转化为行动。 获取位置 这是从创建工单的交易记录中捕获的显式事件。它对应制造执行数据表（例如WIP_DISCRETE_JOBS或类似数据表）中工单记录的创建时间戳。 采集 从Work Order实体的创建日期中获取。 事件类型 explicit | |||
| 工单已发布 | 表示生产订单正式发布到车间，并授权开始制造活动。该事件会使订单及其相关文件（如领料单和工艺路线单）可供生产人员使用。 | ||
| 为什么重要 这是区分计划阶段与执行阶段的关键里程碑。订单发布延迟是生产计划延期的常见原因，因此必须重点监控。 获取位置 这是用户或系统流程将工单状态变更为“Released”时捕获的显式事件。工单抬头中通常会记录具体的发布日期时间戳。 采集 从工单记录中的“Released Date”时间戳获取。 事件类型 explicit | |||
| 工单已完成 | 该活动表示成品的最终数量已完成制造，并已计入生产订单。该事件标志着该订单的全部生产活动结束。 | ||
| 为什么重要 作为主要的成功终点，该活动对于计算端到端生产周期时间，以及根据计划完成日期衡量计划执行情况至关重要，也是绩效分析的基础。 获取位置 这是由完工交易触发的显式事件，表示成品已入库。系统会记录工单完成日期，或将工单状态变更为“Completed”。 采集 从最终完工交易时间戳，或工单状态变更为“Complete”的日期中获取。 事件类型 explicit | |||
| 生产已开始 | 该活动标志着生产订单第一道制造工序的开始，即产品在车间正式开始进行实体加工。 | ||
| 为什么重要 这一里程碑对于衡量实际生产周期时间以及计划启动日期的执行情况至关重要。它有助于区分生产前延迟与制造执行阶段的延迟。 获取位置 这可以是来自车间交易的显式事件，例如操作员在第一道工序上报工。也可以根据订单发布后第一笔人工交易或物料消耗的时间戳推断。 采集 从针对工单工序记录的第一笔“move”或“completion”交易中获取。 事件类型 explicit | |||
| 工单已取消 | 该活动表示取消此前已创建且可能已经发布的生产订单。这是一条异常路径，会停止该订单后续的所有工作。 | ||
| 为什么重要 跟踪取消事件对于了解流程异常至关重要。分析取消原因，可以揭示需求预测、计划准确性或工程变更方面的问题。 获取位置 这是用户将工单状态变更为“Canceled”时触发的显式事件。系统会记录该状态变更的时间戳。 采集 从工单状态变更为“Canceled”时的时间戳中获取。 事件类型 explicit | |||
| 工单已批准 | 该活动表示生产订单已由计划员或经理审核并批准。在订单发布到车间之前，通常必须完成审批，尤其是高价值或复杂产品的订单。 | ||
| 为什么重要 分析创建到审批之间的时间，有助于识别生产前行政流程中的瓶颈。审批周期过长，可能显著延迟制造启动。 获取位置 这通常是根据工单状态变化推断出的事件，例如状态从“Unapproved”变为“Approved”。Oracle通常使用状态字段管理工单等事务对象的生命周期。 采集 根据工单状态从未审批状态变为已审批或可发布状态推断。 事件类型 inferred | |||
| 工序已完成 | 表示工单生产路线中某个单独步骤或工序已完成。一个生产订单通常会包含多个“Operation Completed”事件，每道制造工序对应一个事件。 | ||
| 为什么重要 分析连续工序完成之间的时间，可以细致了解生产流程，识别瓶颈工序，并计算特定阶段的在制品时间。 获取位置 这是通过车间move或completion交易捕获的显式事件。操作员记录某道工序的完成数量后，系统会生成带时间戳的交易记录。 采集 从工单特定工序的完成交易中获取。 事件类型 explicit | |||
| 已分析生产绩效 | 表示生产订单完成后的绩效分析，将实际结果与计划目标进行对比，可能包括成本、物料使用量和计划执行情况的审核。 | ||
| 为什么重要 该活动对于了解持续改进闭环的有效性至关重要。衡量绩效分析所需时间，可以反映企业从生产偏差中学习并采取响应措施的速度。 获取位置 这是一个计算得出的事件，因为它属于业务流程，而非系统交易。该事件可以根据偏差报告生成日期或绩效备注字段更新时间推断，但具体方式高度依赖本地流程。 采集 通过检测相关偏差报告的创建，或绩效管理系统中的状态更新来推导。 事件类型 calculated | |||
| 已执行质量检验 | 表示在制造工序期间或完成后执行的质量控制检查，包括测量、目视检查或其他测试，以确保产品符合规格要求。 | ||
| 为什么重要 该活动能够反映质量管理流程。分析检查频率、持续时间及结果（通过或不通过），有助于识别质量相关瓶颈或反复出现的问题。 获取位置 这是在Oracle Quality Management模块中捕获的显式事件。检查结果会记录在质量收集计划中，并与生产订单或特定工序关联。 采集 从与工单关联的质量收集结果数据表记录中获取。 事件类型 explicit | |||
| 已检查物料可用性 | 表示系统已检查生产订单所需全部组件的可用性。该步骤通常在订单创建后自动执行，也可能由计划员手动触发。 | ||
| 为什么重要 跟踪该活动有助于分析物料短缺造成的延迟，将计划问题与执行问题区分开来，也是了解供应链绩效对生产启动时间影响的关键。 获取位置 这可能是根据工单状态或组件需求清单状态变化推断出的事件。例如，状态从“Awaiting Components”变为“Components Available”，或物料状态字段被填充，都可能表示该事件发生。 采集 根据与工单关联的物料可用性状态字段变化推断。 事件类型 inferred | |||
| 物料已发放 | 该活动表示将组件物料从库存发放至指定生产订单的交易。它说明所需原材料或子装配件已完成拣选并移至生产线。 | ||
| 为什么重要 跟踪物料发放有助于分析仓储和物流运营效率，也能在生产开始前确认物料是否实际到位，比初始检查更准确地反映物料可用性。 获取位置 这是库存模块中记录的显式物料交易事件，并与工单关联。每笔交易都包含时间戳及所发放组件的详细信息。 采集 从与工单ID关联的物料交易记录（例如WIP组件发放记录）中获取。 事件类型 explicit | |||
| 生产计划已调整 | 当已发布生产订单的关键参数发生变化时，就会发生该活动，例如所需数量或计划完成日期被修改。这表示生产执行所依据的原始计划发生了偏差。 | ||
| 为什么重要 频繁调整通常表明计划或执行流程不稳定。跟踪这些事件有助于量化计划变更程度，并识别需求波动或生产问题等根因。 获取位置 这是可以从工单记录的审计轨迹或变更日志中捕获的显式事件。Oracle Cloud通常会跟踪关键字段的变更，包括变更人和变更时间。 采集 从工单实体的审计日志或变更历史数据表中获取。 事件类型 explicit | |||
建议 可选
提取指南
如何从Oracle Manufacturing Cloud获取数据
步骤
- 进入Oracle BI Publisher：使用具有BI Author或Administrator权限的用户登录Oracle Fusion Cloud实例。通过Navigator菜单进入Tools > Reports and Analytics，然后点击“Browse Catalog”打开BI Publisher目录。
- 创建新的数据模型：在BI Publisher目录中进入合适的文件夹，例如Shared Folders > Custom。点击“New”下拉菜单，选择“Data Model”。
- 定义新的数据集：在Data Model编辑器中，点击“Data Sets”旁的“+”图标，选择“SQL Query”。
- 配置数据集：在“New Data Set”对话框中输入描述性名称，例如“Production_Planning_Event_Log”。在“Data Source”中选择Oracle Fusion应用数据库，通常名称为“ApplicationDB_FSCM”或类似名称。
- 输入SQL查询：复制本文档“query”部分提供的完整SQL查询，并粘贴到“SQL Query”文本区域。
- 定义查询参数：查询使用参数
:p_start_date和:p_end_date筛选日期范围。粘贴查询后，这些参数会显示在参数区域。将每个参数的“Data Type”设为“Date”，并填写易于理解的“Display Label”，例如“Start Date”。如有需要，也可以设置默认值。 - 查看并验证数据：在Data Model编辑器中点击“Data”选项卡。输入开始日期和结束日期参数的值，然后点击“View”执行查询并查看提取数据样例。确认列和行均按预期显示。
- 保存数据模型：确认数据预览无误后，点击“Save”图标。为数据模型命名，例如“ProductionPlanningExtraction.xdm”，并将其保存到指定的自定义文件夹。
- 创建用于导出的报告：要导出完整数据集，必须将此数据模型关联到报告。在已保存的数据模型中点击“Create Report”。按照向导创建简单的表格报告布局，无需复杂格式设置。
- 运行并导出报告：保存新建的报告。打开报告，使用所需日期参数运行。报告生成后，使用“Export”功能将输出保存为CSV文件。该CSV文件即为可上传的事件日志。
配置
- 数据源：查询必须在Oracle Fusion应用数据库上运行，该数据库通常名为
ApplicationDB_FSCM。确保配置的用户拥有查询中涉及的所有制造、库存和人员表的读取权限。 - 日期范围参数：查询包含两个必填参数
:p_start_date和:p_end_date，用于筛选数据。建议按3至6个月分批提取，以保持良好性能并控制文件大小。 - 关键筛选条件：如需进一步缩小数据范围并提升性能，可在
base_data公用表表达式中添加WHERE子句。常见筛选条件包括：IODV.ORGANIZATION_CODE IN ('[Your Plant Code 1]', '[Your Plant Code 2]')，用于选择指定生产工厂。WDJ.WORK_ORDER_TYPE IN ('Standard', '[Your Custom Type]')，用于选择指定类型的生产订单。
- 性能注意事项：这是一个包含多个
UNION ALL分支的复杂查询。对于大型制造运营，该查询可能消耗较多资源。建议在业务低峰期安排提取，以尽量减少对系统性能的影响。 - 前置条件：创建并运行数据模型的用户需要Oracle BI Publisher角色，例如
BI Author。底层数据源用户需要对WIP_DISCRETE_JOBS、WIP_OPERATIONS、INV_MATERIAL_TXNS、QA_RESULTS、INV_ORGANIZATION_DEFINITIONS_V、EGP_SYSTEM_ITEMS_B、PER_USERS和PER_PERSON_NAMES_F表拥有明确的读取权限。
a 示例查询 sql
WITH base_data AS (
SELECT
WDJ.WORK_ORDER_NUMBER,
WDJ.STATUS_TYPE,
(SELECT STATUS_NAME FROM WIP_WORK_ORDER_STATUSES_VL WHERE STATUS_TYPE = WDJ.STATUS_TYPE) AS WORK_ORDER_STATUS_NAME,
ESI.ITEM_NUMBER AS PRODUCT_CODE,
IODV.ORGANIZATION_CODE AS PRODUCTION_PLANT,
PPNF.DISPLAY_NAME AS PLANNER,
WDJ.SCHEDULED_START_DATE,
WDJ.SCHEDULED_COMPLETION_DATE,
WDJ.CREATION_DATE,
WDJ.DATE_RELEASED,
WDJ.ACTUAL_COMPLETION_DATE,
WDJ.DATE_CLOSED,
WDJ.LAST_UPDATE_DATE,
WDJ.WIP_ENTITY_ID
FROM
WIP_DISCRETE_JOBS WDJ
JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON WDJ.ORGANIZATION_ID = IODV.ORGANIZATION_ID
JOIN EGP_SYSTEM_ITEMS_B ESI ON WDJ.PRIMARY_ITEM_ID = ESI.INVENTORY_ITEM_ID AND WDJ.ORGANIZATION_ID = ESI.ORGANIZATION_ID
LEFT JOIN PER_USERS PU ON WDJ.CREATED_BY = PU.USERNAME
LEFT JOIN PER_PERSON_NAMES_F PPNF ON PU.PERSON_ID = PPNF.PERSON_ID AND PPNF.NAME_TYPE = 'GLOBAL' AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
WHERE
WDJ.CREATION_DATE BETWEEN TO_DATE(:p_start_date, 'YYYY-MM-DD') AND TO_DATE(:p_end_date, 'YYYY-MM-DD')
)
-- 1. Work Order Created
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Created' AS "ActivityName",
BD.CREATION_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
UNION ALL
-- 2. Material Availability Checked (Inferred)
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Material Availability Checked' AS "ActivityName",
BD.CREATION_DATE + interval '1' minute AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
UNION ALL
-- 3. Work Order Approved (Inferred)
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Approved' AS "ActivityName",
BD.DATE_RELEASED - interval '1' minute AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.DATE_RELEASED IS NOT NULL
UNION ALL
-- 4. Work Order Released
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Released' AS "ActivityName",
BD.DATE_RELEASED AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.DATE_RELEASED IS NOT NULL
UNION ALL
-- 5. Materials Issued
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Materials Issued' AS "ActivityName",
IMT.TRANSACTION_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
INV_MATERIAL_TXNS IMT
JOIN base_data BD ON IMT.TRANSACTION_SOURCE_ID = BD.WIP_ENTITY_ID
WHERE
IMT.TRANSACTION_SOURCE_TYPE_ID = 5 -- WIP Transaction Source Type
AND IMT.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) -- Issue, Backflush, Sub-assy Return
AND IMT.TRANSACTION_TYPE_ID IN (35, 43) -- WIP Issue, Assembly Completion
UNION ALL
-- 6. Production Started
SELECT
OPS.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Production Started' AS "ActivityName",
OPS.FIRST_OP_START_DATE AS "EventTimestamp",
OPS.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
OPS.PRODUCT_CODE AS "ProductCode",
OPS.PRODUCTION_PLANT AS "ProductionPlant",
OPS.PLANNER AS "Planner",
OPS.SCHEDULED_START_DATE AS "PlannedStartDate",
OPS.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM (
SELECT
BD.WORK_ORDER_NUMBER,
MIN(WO.ACTUAL_START_DATE) AS FIRST_OP_START_DATE,
BD.WORK_ORDER_STATUS_NAME,
BD.PRODUCT_CODE,
BD.PRODUCTION_PLANT,
BD.PLANNER,
BD.SCHEDULED_START_DATE,
BD.SCHEDULED_COMPLETION_DATE
FROM
WIP_OPERATIONS WO
JOIN base_data BD ON WO.WIP_ENTITY_ID = BD.WIP_ENTITY_ID
WHERE
WO.ACTUAL_START_DATE IS NOT NULL
GROUP BY
BD.WORK_ORDER_NUMBER, BD.WORK_ORDER_STATUS_NAME, BD.PRODUCT_CODE, BD.PRODUCTION_PLANT, BD.PLANNER, BD.SCHEDULED_START_DATE, BD.SCHEDULED_COMPLETION_DATE
) OPS
UNION ALL
-- 7. Operation Completed
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Operation Completed' AS "ActivityName",
WO.ACTUAL_COMPLETION_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
WIP_OPERATIONS WO
JOIN base_data BD ON WO.WIP_ENTITY_ID = BD.WIP_ENTITY_ID
WHERE
WO.ACTUAL_COMPLETION_DATE IS NOT NULL
UNION ALL
-- 8. Production Plan Adjusted
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Production Plan Adjusted' AS "ActivityName",
BD.LAST_UPDATE_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.DATE_RELEASED IS NOT NULL
AND BD.STATUS_TYPE NOT IN (7, 12) -- Not Canceled or Closed
AND BD.LAST_UPDATE_DATE > (BD.DATE_RELEASED + interval '1' hour)
AND BD.LAST_UPDATE_DATE < NVL(BD.ACTUAL_COMPLETION_DATE, SYSDATE)
UNION ALL
-- 9. Quality Inspection Performed
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Quality Inspection Performed' AS "ActivityName",
QR.CREATION_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
QA_RESULTS QR
JOIN base_data BD ON QR.WIP_ENTITY_ID = BD.WIP_ENTITY_ID
WHERE
QR.WIP_ENTITY_ID IS NOT NULL
UNION ALL
-- 10. Work Order Completed
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Completed' AS "ActivityName",
BD.ACTUAL_COMPLETION_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.ACTUAL_COMPLETION_DATE IS NOT NULL
UNION ALL
-- 11. Production Performance Analyzed (Inferred)
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Production Performance Analyzed' AS "ActivityName",
BD.DATE_CLOSED + interval '1' day AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.DATE_CLOSED IS NOT NULL
UNION ALL
-- 12. Work Order Closed
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Closed' AS "ActivityName",
BD.DATE_CLOSED AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.DATE_CLOSED IS NOT NULL
UNION ALL
-- 13. Work Order Canceled
SELECT
BD.WORK_ORDER_NUMBER AS "ProductionOrderNumber",
'Work Order Canceled' AS "ActivityName",
BD.LAST_UPDATE_DATE AS "EventTimestamp",
BD.WORK_ORDER_STATUS_NAME AS "WorkOrderStatus",
BD.PRODUCT_CODE AS "ProductCode",
BD.PRODUCTION_PLANT AS "ProductionPlant",
BD.PLANNER AS "Planner",
BD.SCHEDULED_START_DATE AS "PlannedStartDate",
BD.SCHEDULED_COMPLETION_DATE AS "PlannedEndDate",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp"
FROM
base_data BD
WHERE
BD.STATUS_TYPE = 7步骤
- 进入Oracle Transactional Business Intelligence（OTBI）：登录Oracle Manufacturing Cloud实例。通过Navigator菜单进入Tools，然后选择Reports and Analytics。点击“Browse Catalog”打开Business Intelligence目录。
- 创建新的分析：在OTBI目录中点击工具栏的“New”，选择“Analysis”。系统会提示您选择Subject Area。
- 选择Subject Area：从可用Subject Area列表中选择“Manufacturing - Work Order Performance Real Time”。该Subject Area包含有关工单及其状态的核心信息。
- 定义分析条件：分析编辑器包含两个主要选项卡：“Criteria”和“Results”。您将在“Criteria”选项卡中构建事件日志逻辑。
- 为第一个活动添加列：在左侧“Subject Areas”窗格中，将所需列拖放到“Selected Columns”区域。先从“Work Order Created”活动开始。例如，添加“Work Order Details”.“Work Order Number”、Activity Name公式、“Work Order Details”.“Creation Date”时间戳，以及其他所需属性。
- 为Activity Name创建自定义公式：点击“Selected Columns”标题旁的“Add a new calculated measure”图标。在公式框中输入活动文本，例如
'Work Order Created'。将列命名为“ActivityName”等名称。 - 使用UNION ALL合并所有活动：要创建包含所有所需活动的单一事件日志，必须合并多个查询。在“Criteria”选项卡中，找到“Combine results based on a set operation”图标，该图标通常位于“Selected Columns”区域右下方，形似两个重叠的圆。选择“Union All”，并为下一个活动添加新的条件块，例如“Work Order Released”。
- 对所有活动重复操作：针对全部13个所需活动重复步骤5至7。每个活动都要创建新的条件块，并使用“Union All”合并。确保为每个活动的时间戳选择正确的日期字段，例如“Release Date”、“Actual Completion Date”或“Closed Date”。部分活动还需要按“Work Order Status Name”筛选。
- 应用全局筛选条件：设置所有UNION块后，进入“Filters”区域，添加筛选条件以限制数据范围。必须按“Work Order Creation Date”或“Last Update Date”筛选日期范围，例如最近6个月。同时按“Organization Name”筛选，以选择正确的生产工厂。
- 查看并设置结果格式：切换到“Results”选项卡预览数据。确认所有列均已显示且名称正确。如有需要，可拖放列调整顺序。
- 导出事件日志：分析完成且结果确认无误后，点击页面底部的“Export”链接，选择“CSV File”格式。
- 准备上传：打开下载的CSV文件，确认列标题符合所需属性，例如
ProductionOrderNumber、ActivityName、EventTimestamp等。确保时间戳格式一致。完成后即可将文件上传到流程挖掘工具。
配置
- Subject Area：“Manufacturing - Work Order Performance Real Time”是此次提取使用的主要Subject Area。如需详细的物料或质量数据，可能需要使用“Manufacturing - Material Usage Real Time”或“Quality Management - Inspection Results Real Time”单独创建分析，再合并结果。
- 日期范围筛选：必须应用日期范围筛选，以控制数据量。在“Work Order Details”.“Creation Date”或“Work Order Details”.“Last Update Date”上创建筛选条件，提取最近3至6个月等时间段的数据。
- 组织筛选：始终按“Organization Details”.“Organization Name”或“Organization Code”筛选，将数据限制在正在分析的具体生产工厂或业务单元内。
- 工单状态筛选：为减少噪声，可从整个分析中排除某些工单状态，例如草稿或模拟订单。可通过“Work Order Status”.“Work Order Status Name”上的全局筛选条件实现。
- 前置条件：运行分析的用户必须拥有适当的角色和权限，通常需要“Manufacturing Engineer”或自定义BI角色，才能访问“Manufacturing - Work Order Performance Real Time”Subject Area。
a 示例查询 sql
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Created' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Created By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Material Availability Checked' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Update Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" = 'Unreleased' AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Approved' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Release Date" - INTERVAL '1' MINUTE AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Release Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Released' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Release Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Release Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Materials Issued' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Start Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Start Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Production Started' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Start Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Start Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Operation Completed' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Operation Details"."Actual Completion Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Operation Details"."Actual Completion Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Production Plan Adjusted' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Update Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Update Date" > "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Release Date" AND "Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" IN ('Released', 'On Hold') AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Quality Inspection Performed' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Operation Details"."Actual Completion Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Operation Details"."Actual Completion Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Completed' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Completion Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Actual Completion Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Production Performance Analyzed' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Closed Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Closed Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Closed' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Closed Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Closed Date" IS NOT NULL AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'
UNION ALL
SELECT
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Work Order Number" AS "ProductionOrderNumber",
'Work Order Canceled' AS "ActivityName",
CAST("Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Update Date" AS TIMESTAMP) AS "EventTimestamp",
'Oracle Manufacturing Cloud' AS "SourceSystemIdentifier",
CURRENT_TIMESTAMP AS "LastDataUpdateTimestamp",
"Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" AS "WorkOrderStatus",
"Manufacturing - Work Order Performance Real Time"."Item"."Item Number" AS "ProductCode",
"Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Name" AS "ProductionPlant",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Last Updated By" AS "Planner",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Start Date" AS "PlannedStartDate",
"Manufacturing - Work Order Performance Real Time"."Work Order Details"."Planned Completion Date" AS "PlannedEndDate"
FROM "Manufacturing - Work Order Performance Real Time"
WHERE "Manufacturing - Work Order Performance Real Time"."Work Order Status"."Work Order Status Name" = 'Canceled' AND "Manufacturing - Work Order Performance Real Time"."Work Order Details"."Creation Date" >= TIMESTAMP '[start_date]' AND "Manufacturing - Work Order Performance Real Time"."Organization Details"."Organization Code" = '[Your Organization Code]'优化Oracle生产计划，从今天开始
数日内将周期时间缩短30%，提升效率。
开始免费试用
无需信用卡，几分钟即可完成设置。