PeopleSoft Manufacturing Implementation

PeopleSoft Setup Manager enables you to generate a list of setup tasks for the organization based on the features that you are implementing. The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables, and links to the corresponding documentation.

PeopleSoft Manufacturing also provides component interfaces to help you load data from the existing system into PeopleSoft Manufacturing tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.

This table lists all of the components that have component interfaces:

Component

Component Interface

Reference

Item Groups

INV_ITEM_GROUPS_CI

See Setting Definitions for Item Control Values.

Ultimate Use Code

SUT_USE_CI

See Defining Additional Common Information.

Item Load from Excel

IN_MST_ITM_XLS

See Using the Excel-to-Component-Interface Utility.

Sales and Use Tax Authorities

TAX_AUTHORITY_CI

See Defining Sales and Use Tax Authorities and Codes.

Sales and Use Tax Codes

TAX_CODE_CI

See Defining Sales and Use Tax Authorities and Codes.

Distribution Type

CM_DISTR_TYPE_CI

See Distribution Type Page.

Automatic Serial Numbers

AUTO_SERIAL_NUM_CI

See Defining Items at the SetID Level

Transfer Attributes

UNIT_TRANSFER_DEF_CI

See Understanding Stock Transfers Between Business Units

Transfer Attributes Defaults

TRANS_UNIT_INV_CI

See Understanding Stock Transfers Between Business Units

Production Conversion Codes

CE_CONCODE_CI

See Understanding the Manufacturing Standard Cost Foundation

Costing Conversion Overhead Rates

CE_CONV_OH_RATE_CI

See Understanding the Manufacturing Standard Cost Foundation

Conversion Rates

CE_CONV_RATE_CI

See Understanding the Manufacturing Standard Cost Foundation

Forecasted Purchase Costs

CE_FCST_CI

See Understanding the Manufacturing Standard Cost Foundation

Additional Item Costs

CE_ITEMEXP_CI

See Understanding the Manufacturing Standard Cost Foundation

Conversion Overhead Codes

CE_OHCODE_CODE_CI

See Understanding the Manufacturing Standard Cost Foundation

Bill of Material Privileges

EN_IC_BOM_PRIV_CI

See Understanding BOM Maintenance

Item Price Markup

MARKUP_PCT_INV_CI

See Understanding Interunit Transfers

Production Replenish Locations

REPL_LOCATIONS_CI

See Understanding Component Issue Methods

Item Transfer Price

STD_PRICE_INV_CI

See Understanding Interunit Transfers

Floor and Ceiling Costs

CM_VALUE_REF_PGRP_CI

See Generating Reports of Financial Transactions.

Fixed Picking Locations

FIXED_PICK_BINS_CI

See Assigning Fixed Picking Locations.

Crew Actual Costs

CE_CREW_ACTCOST_CI

See Crew Actual Cost Page.

PeopleSoft Events and Notifications Framework

As your organization processes the continuous stream of transactions within your PeopleSoft system, the events and notifications framework enables you to monitor the transaction flow and alert your organization to any errors, changes, and stalled transactions. The messages generated by the events and notifications framework can notify you of the problem, give you a detailed description of the issue, and provide a link to the PeopleSoft page where you can resolve it. One of the ways to use the events and notifications framework is to create PeopleSoft Queries on one or more PeopleSoft tables, add the alert using the Alert Setup component, and then complete the alert setup steps. This method enables you to monitor data within a PeopleSoft table; for example, searching for stalled transactions, instead of looking at the results of a PeopleSoft process. When the Alerts process (EOEN_ALERT) is run, the PeopleSoft table is queried and the alert messages can be generated. These messages can be routed to the appropriate person (PeopleSoft user or non-PeopleSoft user) using an email, a PeopleSoft worklist entry, an XML message, or the PeopleSoft Notification Dashboard.

For the PeopleSoft Manufacturing application, sample data includes the following PeopleSoft queries that have been setup to work with the events and notifications framework. These queries may require minor modifications to work in your environment. You can also copy and alter these queries to create new alert messages.

Query

Process Name

Process Category

Description

MG_BCT_ERRORS

MG_ALERTS

MG_BCT_ERRORS

Query the BCT staging tables and generate alert messages for the following manufacturing transactions that are in error:

  • 210 Production Pick Plan

  • 220 Completion/Scrap

  • 225 Edit Issue Components

  • 230 Production Kit Issue/Return

  • 240 Actual Hours

  • 250 MFG Replenishment Request

  • 400 Serial Genealogy

MG_BCT_UNPROCESS

MG_ALERTS

MG_BCT_UNPROCESS

Query the BCT staging tables and generate alert messages for the following manufacturing transactions that have not been processed for more than 120 minutes:

  • 210 Production Pick Plan

  • 220 Completion/Scrap

  • 225 Edit Issue Components

  • 230 Production Kit Issue/Return

  • 240 Actual Hours

  • 250 MFG Replenishment Request

  • 400 Serial Genealogy

Note: The number of minutes can be changed by modifying the query.

MG_COMP_OVERISSUE

MG_ALERTS

ISS_REPL_COMP_OVERISSUE

Generates alert messages for production IDs and production schedules:

  • With a status of In Process.

  • With component issue method of Issue or Replenish.

  • Any component has an issue quantity greater than 110 percent of the scheduled quantity.

Note: The percentage can be changed by modifying the query.

MG_KIT_COMP_OVERISSUE

MG_ALERTS

KIT_COMP_OVERISSUE

Generates alert messages for production IDs and production schedules:

  • With a status of In Process.

  • With component issue method of Kit.

  • Any component has an issue quantity greater than 110 percent of the scheduled quantity.

Note: The percentage can be changed by modifying the query.

MG_LATE_PRODUCTION

MG_ALERTS

LATE_PRODUCTION

Generates alert messages for production IDs and production schedules:

  • With a status of Released or In Process.

  • Completed quantity is less than 95 percent of the scheduled quantity and are past due.

Note: The percentage can be changed by modifying the query.

See PeopleSoft Documentation: Approval Framework

Other Sources of Information

In the planning phase of your implementation, take advantage of all PeopleSoft sources of information, including the installation guides, table-loading sequences, data models, and business process maps. A complete list of these resources appears in the preface in the PeopleSoft Application Fundamentals Documentation, with information about where to find the most current version of each.

See the product documentation for PeopleTools: Setup Managerand PeopleTools: Component Interfaces