Integrating with Primavera P6

Overview

Supply Chain Planning processes ensure that demands for materials and resources are met on time. This requires close collaboration between an organization's project management system and its supply chain. Supply Chain Planning processes can bridge these two functions.

You can enable this functionality with an integration between Oracle Advanced Supply Chain Planning (the Supply Chain Planning system) and Primavera P6 (the Project Management system). A work breakdown structure is created and maintained in Primavera P6. Activities at the lowest level in the work breakdown structure represent the steps required to meet a project's deliverables. Some of these activities have associated material requirements which need to be communicated to the supply chain planning system as demands.

Other activities in the work breakdown structure can track end item deliverables manufactured in the supply chain. Demand for these end item deliverables also need to be communicated from the project plan to the supply chain planning system. Demand for end item deliverables originating from Primavera P6 should also be reconciled against sales orders for end item deliverables in the project's accounting and execution system, for example;

The supply chain planning process plans for supplies to meet the project's demands. Constraints in the supply chain as well as the hard pegged versus soft pegged nature of different items results in supplies being planned for different dates and quantities. This supply information must then be exported to the Primavera P6 project plan. This process can have the following benefits:

Modeling Projects and Activities in Primavera P6

Demands for materials originating from the Primavera P6 project plan are converted into a master demand schedule that can be used for the supply chain planning process with ASCP. For additional details on the mapping of projects, activities and material resource assignments in Primavera P6 to the demands in ASCP, refer to the Oracle VCP chapter in the Primavera Gateway Implementation and User Guide.

Reconciling Sales Order Demands with Primavera P6 Activities

ASCP collects sales orders from the Order Management system. This enables you to plan for:

The integration between ASCP and Primavera P6 makes the following assumptions about sales orders:

Master Data Synchronization Between Primavera P6 and Oracle ASCP

The integration between ASCP and Primavera P6 makes the following assumptions about master data:

Creating a Demand Schedule from the Primavera P6 Project Plan

You can create demand schedules in ASCP from projects in Primavera P6 that include any of the following:

When an integration flow is launched in Primavera Gateway, all demands that belong to the specified Demand Schedule Name are removed from the ASCP operational data store and replaced with a fresh snapshot of the demands extracted from Primavera P6.

Exporting Projects and Demands from Primavera P6 to Oracle ASCP

Primavera Gateway enables the exporting of project level demands from Primavera P6 to ASCP. When the Demand Flow business process is invoked in Primavera Gateway, projects in Primavera P6 (including activities and material resource assignments) are transformed to a set of demands. This set of demands is part of a master demand schedule that can be incorporated into an ASCP plan.

For additional mapping details between ASCP and Primavera P6 refer to the Oracle VCP Provider chapter in the Primavera Gateway Implementation and User Guide

Supply Chain Planning Process in Oracle ASCP

When the export process from Primavera P6 to ASCP is complete, create the supply chain plan in ASCP to meet the project demands as follows:

Specifying Plan Options in ASCP

To enable project level planning in ASCP, follow these steps before running a plan:

  1. Ensure that item pegging attributes are set to either soft-pegged or hard-pegged, according to functional requirements.

  2. Set the plan options Reservation Level and Hard Pegging Level, according to functional requirements.

  3. Set the MSC: Attribute Based Netting profile option to Yes.

  4. In ASCP Plan Options, specify the Master Demand schedule created by the integration process as an input demand schedule.

Exporting Supply Details from ASCP to Primavera P6

Primavera Gateway enables the exporting of supply dates and order numbers from ASCP to Primavera P6. When the Supply Flow business process is invoked in Primavera Gateway, supply details are exported from the ASCP plan and the Primavera P6 project plan is updated accordingly. The three modes of supply feedback are as follows:

For additional mapping details between ASCP and Primavera P6 refer to the Oracle VCP Provider chapter in the Primavera Gateway Implementation and User Guide.

Supply Attributes Exported from ASCP to Primavera P6

The following supply attributes are included when publishing detailed supply feedback from ASCP to Primavera P6:

Attribute Description
End_Pegged_Demand_Activity_ID The Activity ID of the end demand pegged to this supply. For non Primavera demands, this is set to NULL.
End_Pegged_Demand_Order_Number The Demand Order number of the end demand pegged to this supply.
Order_Type The order type of the supply. For example, On Hand, Work Order, Planned Order.
Order_Number The order number of the supply.
Order_Date The date on which the supply order is placed or planned to be placed. For purchase orders, this is the PO creation date.
Start_Date The date on which the supply order is to start (applies primarily to manufacturing orders).
Actual_Start_Date If a manufacturing work order has already started, this date indicates the actual start date.
Ship_Date The date on which the supply order is planned to ship (applies to Inter organization shipments).
Dock_Date The date on which a supply order arrives at the receiving dock (applies to purchase orders and inter organization shipments).
Due_Date The due date of the supply, the date on which the supply is available for use to meet demands.
Updated_Arrival_Date The arrival date for supplies as updated by Oracle Transportation management.
Item The item that is supplied.
Organization: The organization corresponding to the supply.
Quantity The quantity of the supply.
Project Number The project number to which this supply is pegged.
Task Number The task number to which this supply is pegged.