Integrating with Supply Chain Business Modeler

This chapter provides an overview of the PeopleSoft Supply Chain Management integration with the Supply Chain Business Modeler and discusses how to:

Click to jump to parent topicUnderstanding the PeopleSoft Supply Chain Management Integration with the Supply Chain Business Modeler

This diagram illustrates the integration between PeopleSoft Supply Chain Management and the Supply Chain Business Modeler:

PeopleSoft Supply Chain Management Integration with Supply Chain Business Modeler

PeopleSoft Supply Chain Management integrates with the Supply Chain Business Modeler (a part of Supply Chain Planning) by passing a wide range of supply chain data to the Supply Chain Business Modeler in the form of XML documents. The data that is passed through the XML documents is not planning-model specific but rather a base representation of data that will be used by various planning models. The Supply Chain Business Modeler is a central planning data repository for the Supply Chain Planning Products (Demand Management (DM), Strategic Network Optimization (SNO), Production and Distribution Planning (PDP), Production Scheduling (PS), Production and Scheduling Process (PSP), Order Promising (OP), and Sales and Operation Planning (SOP).

Once the supply chain management data resides within the Supply Chain Business Modeler it is then used to build tactical, operational, or strategic planning models and model partitions. The model partitions are used to generate data needed for specific Supply Chain Planning products. After the Supply Chain Planning products are done with their analysis they then pass their individual information (plans) back to the Supply Chain Business Modeler.

At that point, once again PeopleSoft Supply Chain Management integrates with the Supply Chain Business Modeler by importing that planning data back into PeopleSoft Supply Chain Management and acting upon the recommendations from the planning products.

PeopleSoft Predefined XML Documents

PeopleSoft provides the following predefined XML documents for exporting data from PeopleSoft Supply Chain Management to Supply Chain Business Modeler:

XML Document

Associated Data

Configuration

Model parameters

Calendar

Calendar

Base

  • Item

  • Standard UOM (unit of measure)

  • Item UOM (unit of measure)

  • Item Group

  • Branch

  • Branch Group

  • Storage

  • Storage Requirement Set

  • Item Storage

  • Item Branch

  • Inventory Policy

Distribution

  • Lane

  • Transport Mode

  • Item Transport Mode

Supplier

  • Supplier

  • Supplier Item

Customer

Customer

Manufacturing

  • Operation

  • Produced Item

  • Produced Item BOM (bills of material)

  • Consumed Item BOM (bills of material)

  • Operation BOR (bill of resources)

  • Routing

  • Operation Set

  • Branch Operation Set

  • Temporal Relation

  • Branch Operation

  • Branch Routing

  • Resource

  • Crew

  • Machine

  • Tool

  • Consumed Item Set

  • Resource Set

Forecasts

  • Enterprise Forecast

  • Enterprise Forecast Detail

Sales Orders

  • Sales Orders

  • Sales Order Details

Sales Order History

Sales Order History

Transfer Orders

  • Transfer Order

  • Transfer Order Detail

Beginning Inventory

Beginning Inventory

Work Orders

  • Work Order

  • Work Order Routing

  • Work Order Parts List

Purchase Orders

  • Purchase Order

  • Purchase Order Detail

Safety Parameters

Safety Parameters

Inventory Safety Targets

Inventory Safety Targets

PeopleSoft provides the following predefined XML documents for import data from Supply Chain Business Modeler:

XML Document

Associated Data

Purchase Order

Information for the XML document is extracted from the Supply Chain Business Modeler. Data in this document is used to establish a picture of existing purchase orders sent to the Supply Chain Business Modeler. This picture of the existing orders will be used to populate original order data in the planning instance tables and also be used to identify orders that will be marked as canceled as a result of the optimized plan. Any order sent into the Supply Chain Business Modeler but not received back on a purchase order recommendation out of the Supply Chain Business Modeler will assumed to be canceled.

Transfer Orders

Information for the XML document is extracted from the Supply Chain Business Modeler. Data in this document is used to establish a picture of existing transfer orders sent to the Supply Chain Business Modeler. This picture of the existing orders will be used to populate original order data in the planning instance and also identify orders that will be marked as canceled as a result of the optimized plan. Any order sent into the Supply Chain Business Modeler but not received back on a net deployment out of the Supply Chain Business Modeler will assumed to be canceled.

Work Orders

Information for the XML document is extracted from the Supply Chain Business Modeler. Data in this document is used to establish a picture of existing production orders sent to the Supply Chain Business Modeler. This picture of the existing orders will be used to populate original order data in the planning instance and also identify orders that will be marked as canceled as a result of the optimized plan. Any order sent into the Supply Chain Business Modeler but not received back on either a net production requirement or a production schedule out of the Supply Chain Business Modeler will assumed to be canceled.

Enterprise Forecast

The Enterprise Forecast XML document contains forecast information that was generated by Demand Management (DM). Only inventoried items are sent to the Supply Chain Business Modeler as a part of the standard integration so it is assumed that only Inventory Item forecast will be received out of the Supply Chain Business Modeler.

Net Deployment Requirements

The Net Deployment Requirements XML document contains information about inventory transfers between two business units and represents results out of the Production and Distribution Planning (PDP). Details for net deployments may contain data for existing transfers as well as new inter unit transfer requirements.

Net Production Requirements

The Net Production Requirements XML document contains information about production requirements for an item at a given branch and represents the results out of the Production and Distribution Planning (PDP). Details for net production requirements may contain data for existing production as well as new production requirements.

Production Schedules

The Production Schedule XML document contains detailed production information including specific operations, resources, and material to use in the manufacturing process. Production schedule information can be produced by Production and Distribution Planning and production schedule information can also be produced by Production Scheduling (PS) and Production Scheduling Process (PSP). Production Schedules may contain both existing and new production.

Purchase Order Recommendations

The purchase order recommendations XML document contains information regarding purchases that need to be made based on predefined supplier/item relationships. Purchase order recommendations can be produced by Production and Distribution Planning. The information may contain both new and existing purchase orders.

See Also

Posting PeopleSoft Supply Planning Updates to the Transaction System

EnterpriseOne Demand Management 8.12 PeopleBook

EnterpriseOne Supply Chain Business Modeler 8.12 PeopleBook

EnterpriseOne Strategic Network Optimization 8.12 PeopleBook

EnterpriseOne Production & Distribution Planning 8.12 PeopleBook

EnterpriseOne Production Scheduling 8.12 PeopleBook

Click to jump to parent topicExporting Data to Supply Chain Business Modeler

This section discusses how to export data to Supply Chain Business Modeler.

Click to jump to top of pageClick to jump to parent topicPage Used to Export Data to Supply Chain Business Modeler

Page Name

Object Name

Navigation

Usage

Export data to SCBM

APS_OUT_RUN

SCM Integrations, Advanced Planning, Export data to SCBM

Initiate the Export data to SCBM - Single Application Engine process (APS_O_MAIN) or initiate the Export data to SCBM - Multi Application Engine process (APS_OUT). Both of these processes export the XML documents from PeopleSoft Supply Chain Management to the Supply Chain Business Modeler. The Export Data to SCBM - Single process runs the XML documents serially where as the Export Data to SCBM - Multi process allows for the XML documents to be generated in parallel and can take advantage of multiple CPU environments.

Click to jump to top of pageClick to jump to parent topicExporting Data to Supply Chain Business Modeler

Access the Export data to SCBM page.

Fences

Current Option

Select how you want to specify the current date. You can enter a specific date or an offset in days from the system date. Values are:

  • Date

  • Offset

Current Date

Select the current date. This field is available if you select Date as the Current Option.

Current Offset

Enter the current offset in days. This field is available if you select Offset as the Current Option.

Start

Enter the start fence in days from the current time. This value can be negative and the start fence must be less than or equal to the current time.

End

Enter the end fence in days from the current time. This value can be negative and the end fence must be greater than the current time.

History Start

Enter the history start fence in days from the current time. This value can be negative and the history start fence must be less than current time.

The system will only use the history start fence when selecting data for the Sales Order History XML Document.

Filters

Item Set ID

Select the item Set ID for the data that you would like to export to Supply Chain Business Modeler.

Include Quotes

Select this check box if you want to include quotes in the data that is passed to the Supply Chain Business Modeler.

Quote % (quote percentage)

If you select to include quotes, than enter the quote percentage to include. Quotes with an acceptance percentage equal to or greater than the value entered will be included in the data sent to the Supply Chain Business Modeler.

Reverse Quarantine Qty (reverse quarantine quantity)

Select this check box if you want to reverse the quarantine quantity from the quantity on hand that is sent to the Supply Chain Business Modeler using the Base XML document.

Global Defaults

Base Currency

Select a base currency. This currency and rate are used for formatting costs and prices into a common currency within Supply Chain Business Modeler.

Rate Type

Select a rate type. This currency and rate are used for formatting costs and prices into a common currency within Supply Chain Business Modeler.

Constrained Time Fence

Enter a constrained time fence in number of days. This value must be greater than or equal to zero. The Base XML Document uses this value to populate the constrained item fence value directly on the Item Branch attribute.

Fixed Production Fence

Enter a fixed production fence in number of days. This value must be greater than or equal to zero. The Base XML Document uses this value to populate the fixed production fence attribute on machines, crews, and tools directly.

Item Group Option

Select how you want to control formatting of the item group within Supply Chain Business Modeler. Values are:

  • Family: Item Family

  • Group: Item Group

Model Documents

Configuration, Calendar, Base, Distribution, Supplier, Customer, Manufacturing, Forecasts, Sales Orders, Sales Order History, Transfer Orders, Beginning Inventory, Work Orders, Purchase Orders, and Safety Parameters

Select the check box next to each of the different types of XML documents that you want to have created and exported to the Supply Chain Business Modeler.

Click theSelect All button to select all of the XML Documents at once.

Click theClear All button to clear the selection of any XML Documents.

Write Export Files To

Enter the output directory, folder, or URL for the exported XML Documents.

Click to jump to parent topicImporting Data From Supply Chain Business Modeler

This section discusses how to import data from Supply Chain Business Modeler.

Click to jump to top of pageClick to jump to parent topicPage Used to Import Data From Supply Chain Business Modeler

Page Name

Object Name

Navigation

Usage

Import data from SCBM

APS_IN_RUN

SCM Integrations, Advanced Planning, Import data from SCBM

Initiate the Import data from SCBM - Single Application Engine process (APS_I_MAIN) or initiate the Import data from SCBM - Multi Application Engine process (APS_IN). Both of these processes import the XML documents from the Supply Chain Business Modeler to PeopleSoft Supply Chain Management. The Import data from SCBM - Single process runs the XML documents serially where as the Import data from SCBM - Multi process allows for the XML documents to be generated in parallel and can take advantage of multiple CPU environments.

Click to jump to top of pageClick to jump to parent topicImporting Data From Supply Chain Business Modeler

Access the Import data from SCBM page.

Import data from SCBM page

Published Forecast

Select this check box if you want to want to update published forecast planning data to PeopleSoft Supply Chain Management.

Planning Instance, Planning Instance

Select this check box if you want to update a particular planning instance of planning data to PeopleSoft Supply Chain Management. Then enter the planning instance in the Planning Instance field.

Net Deployment Requirements

If you select to update by planning instance, then select this check box if you want to import net deployment requirements.

Net Production Requirements

If you select to update by planning instance, then select this check box if you want to import net production requirements.

Purchase Order Recommendations

If you select to update by planning instance, then select this check box if you want to import purchase order recommendations.

Production Schedule

If you select to update by planning instance, then select this check box if you want to import the production schedule.

Import Files From

Enter the location of the XML documents that you want to import.