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 |
|
Ultimate Use Code |
SUT_USE_CI |
|
Item Load from Excel |
IN_MST_ITM_XLS |
|
Sales and Use Tax Authorities |
TAX_AUTHORITY_CI |
|
Sales and Use Tax Codes |
TAX_CODE_CI |
|
Distribution Type |
CM_DISTR_TYPE_CI |
|
Automatic Serial Numbers |
AUTO_SERIAL_NUM_CI |
|
Transfer Attributes |
UNIT_TRANSFER_DEF_CI |
|
Transfer Attributes Defaults |
TRANS_UNIT_INV_CI |
|
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 |
|
Item Price Markup |
MARKUP_PCT_INV_CI |
|
Production Replenish Locations |
REPL_LOCATIONS_CI |
|
Item Transfer Price |
STD_PRICE_INV_CI |
|
Floor and Ceiling Costs |
CM_VALUE_REF_PGRP_CI |
|
Fixed Picking Locations |
FIXED_PICK_BINS_CI |
|
Crew Actual Costs |
CE_CREW_ACTCOST_CI |
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:
|
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:
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:
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:
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:
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