PeopleSoft SCM Inventory Implementation
PeopleSoft Setup Manager enables you to review a list of setup tasks for your organization for the products 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 Inventory also provides component interfaces to help you load data from your existing system into PeopleSoft Inventory 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 |
---|---|---|
Default Putaway Locations |
DEFAULT_LOCATION_CI |
|
Fixed Picking Locations |
FIXED_PICK_BINS_CI |
|
Transfer Attributes Defaults |
TRANS_UNIT_INV_CI |
|
Transfer Attributes |
UNIT_TRANSFER_DEF_CI |
|
Storage Zone Codes |
ZONE_INV_CI |
|
Master Item Load Component Integration |
IN_MST_ITM_XLS |
|
Master Item supplier Load Component |
IN_VND_ITM_XLS |
|
Item Groups |
INV_ITEM_GROUPS_CI |
See Item Groups Page. |
Stocking Periods |
STOCK_PERIOD_CI |
|
Units of Measure |
INV_ITEM_UOM_CI |
|
Issue to Work Orders |
IN_WO_ISSUES_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 Inventory 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 |
---|---|---|---|
INV_BCT_ERRORS |
IN_ALERTS |
IN_BCT_ERROR |
Query the BCT staging tables and generate alert messages for the following inventory transactions that are in error:
|
INV_BCT_UNPROCESS |
IN_ALERTS |
IN_BCT_UNPROCESS |
Query the BCT staging tables and generate alert messages for the following inventory transactions that have not been processed for more than 120 minutes:
Note: The number of minutes can be changed by modifying the query. |
INV_FAILED_PUTAWAY |
IN_ALERTS |
IN_FAILED_PUTAWAY |
Generates alert messages for putaway transactions that are in error or have not been processed for more than one day. Note: The time period can be changed by modifying the query. |
INV_TRNSFR_ORD_NOT_RECD |
IN_ALERTS |
IN_TRANSFER_ORDER_NOT_RECD |
Generates alert messages for interunit transfer orders that are past their scheduled arrival dates and have a status of In Transit, Open, or Picked. |
See PeopleSoft Events and Notifications 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 to PeopleSoft Applications Fundamentals with information about where to find the most current version of each.