Release Levels
This chapter discusses:
Release levels.
Business process.
Item master integration architecture.
Integration points for the item master integration.
Field structure comparison between the PeopleSoft Enterprise system and the JD Edwards EnterpriseOne system.
Assumptions for implementing the item master integration.
Release Levels
This document supports the integration between JD Edwards EnterpriseOne 8.12 Inventory Management and PeopleSoft Enterprise 8.9 FSCM.
Business Process
The item master integration promotes tight control of inventory items across an organization's branch plants or business units. This approach improves the buying power of the organization and increases the visibility of items used across branch plants.
With the item master integration, you can maintain items at the corporate level using the PeopleSoft Enterprise system, and push that information to branch plants using the JD Edwards EnterpriseOne system.
The major tasks involved in the item master integration are:
Setting up integration options and code cross-referencing in the JD Edwards EnterpriseOne Web Services Gateway (WSG) soft-coding/cross-reference database.
Setting up the integration in the PeopleSoft Enterprise database.
Loading PeopleSoft Enterprise items into JD Edwards EnterpriseOne tables.
Synchronizing incremental changes in PeopleSoft Enterprise items with the JD Edwards EnterpriseOne system.
Item Master Integration Architecture
This section discusses the integration architecture for the:
Initial load of items.
Incremental synchronization of items.
Integration Architecture for the Initial Load of Items
This diagram illustrates the initial load of items from the PeopleSoft Enterprise system to the JD Edwards EnterpriseOne system:
Initial load of items process
The initial load of items from the PeopleSoft Enterprise system to the JD Edwards EnterpriseOne system consists of these steps:
The PeopleSoft Enterprise user publishes full item information using the ITEM_FULLSYNC_EFF message.
The E_Item_To_E1_ItemMaster.insert_E_Item_To_E1_ItemMaster integration service receives the message and invokes the insertInventoryItems interface flow, which inserts records directly into the F4101 Item Master Unedited Transaction Table (F4101Z1).
The JD Edwards EnterpriseOne user runs the Item Master Unedited Transactions Inbound Processor program (R4101Z1I) to move the records from the F4101Z1 table to the Item Master table (F4101).
Integration Architecture for the Incremental Synchronization of Items
This diagram illustrates the incremental synchronization of items from the PeopleSoft Enterprise system to the JD Edwards EnterpriseOne system:
Incremental synchronization of items process
The incremental synchronization of items from the PeopleSoft Enterprise system to the JD Edwards EnterpriseOne system consists of these steps:
The PeopleSoft Enterprise user activates the ITEM_SYNC_EFF message.
This is a one-time setup step.
The PeopleSoft Enterprise system automatically publishes the ITEM_SYNC_EFF message when a user adds or changes an item.
The E_Item_To_E1_ItemMaster.process_E_Item_To_E1_ItemMaster integration service receives the message and invokes the processInventoryItem interface flow, which inserts the record directly into the Item Master table (F4101).
Integration Points for the Item Master Integration
This table lists the integration points used in this integration and provides a brief description of each:
|
PeopleSoft Enterprise Message Name |
Integration Flow |
JD Edwards EnterpriseOne Interface Flow |
Description |
|
ITEM_FULLSYNC_EFF |
E_Item_To_E1_ItemMaster: |
insertInventoryItems |
The PeopleSoft Enterprise system sends an initial load of items to the JD Edwards EnterpriseOne F4101 Item Master Unedited Transaction Table (F4101Z1). |
|
ITEM_SYNC_EFF |
E_Item_To_E1_ItemMaster: |
processInventoryItem |
The PeopleSoft Enterprise system sends incremental updates of items to the JD Edwards EnterpriseOne Item Master table (F4101). |
Field Structure Comparison Between the PeopleSoft Enterprise System and the JD Edwards EnterpriseOne System
This table summarizes corresponding field structure for items in the PeopleSoft Enterprise system and the JD Edwards EnterpriseOne system:
|
PeopleSoft Enterprise Field |
JD Edwards EnterpriseOne Field |
Comments |
|
Item Number - Short (ITM) |
The value in this field is generated by Next Numbers when the item record is created in the JD Edwards EnterpriseOne system. No corresponding field exists in the PeopleSoft Enterprise system. |
|
|
Item ID (INV_ITEM_ID) |
2nd Item Number (LITM) |
The PeopleSoft Enterprise field is 18 characters and is mapped directly to the 25 character string in the JD Edwards EnterpriseOne system. |
|
Description (DESCR60) |
Description - Line 1 (DSC1) and Description - Line 2 (DSC2) |
The Description field from the PeopleSoft Enterprise system is parsed and placed into the two JD Edwards EnterpriseOne Description fields. The first 30 characters are placed in the Description - Line 1 field, and the second 30 characters are placed in the Description - Line 2 field. |
|
Standard Unit of Measure (UNIT_MEASURE_STD) |
Unit of Measure - Primary (UOM1) |
The user must set up a code cross-reference between the PeopleSoft Enterprise codes and the JD Edwards EnterpriseOne codes. |
|
Weight UOM (UNIT_MEASURE_WT) |
Unit of Measure - Weight (UWUM) |
The user must set up a code cross-reference between the PeopleSoft Enterprise codes and the JD Edwards EnterpriseOne codes. |
|
Volume UOM (UNIT_MEASURE_VOL) |
Unit of Measure - Volume (UVM1) |
The user must set up a code cross-reference between the PeopleSoft Enterprise codes and the JD Edwards EnterpriseOne codes. |
|
Category - G/L (GLPT) |
This field does not exist in the PeopleSoft Enterprise system. It is populated in the JD Edwards EnterpriseOne system by the value in the G/L Class Code integration option. |
|
|
Shipping Serial Control (SHIP_SERIAL_CNTRL) Lot Control (LOT_CONTROL) |
Layer Code - Source (SRCE) |
If the Shipping Serial Control field in the PeopleSoft Enterprise system is set to 1, a value of 4 is mapped to the Layer Code - Source field in the JD Edwards EnterpriseOne system. If the Lot Control field in the PeopleSoft Enterprise system is set to 1, a value of 3 is mapped to the Layer Code - Source field in the JD Edwards EnterpriseOne system. If both of these conditions are met, the Lot Control field in the PeopleSoft Enterprise system takes precedence. |
|
Grade (INV_PROD_GRADE) |
Standard Grade (STDG) |
The user must set up a code cross-reference between the PeopleSoft Enterprise codes and the JD Edwards EnterpriseOne codes. Note. This field is included only in the batch load of items. |
|
Inventory Item (INVENTORY_ITEM) |
Stocking Type (STKT) |
If the value in the PeopleSoft Enterprise field is Y, the value from the Active Item Stocking Type Code integration option is used to populate the JD Edwards EnterpriseOne field. |
|
Line Type (LNTY) |
This field does not exist in the PeopleSoft Enterprise system. It is populated in the JD Edwards EnterpriseOne system by the value in the Line Type Code integration option. |
|
|
Serial Control (SERIAL_CONTROL) |
Serial Number Required (SRNR) |
The one-character PeopleSoft Enterprise field maps directly to the one-character JD Edwards EnterpriseOne field. |
|
Shelf Life (Days) (SHELF_LIFE) |
Days - Shelf Life Days (SLD) |
The PeopleSoft Enterprise field is 4 characters and is mapped directly to the 6- character string in the JD Edwards EnterpriseOne system. |
Assumptions for Implementing the Item Master Integration
When you implement the item master integration, you should be aware of these assumptions:
The PeopleSoft Enterprise system is the system of record for inventory items.
Item price and item cost information is not integrated; it must be entered manually in the JD Edwards EnterpriseOne system.
This integration supports only items with a status of Active or Discontinue in the PeopleSoft Enterprise system.
If you change the status of an item in the PeopleSoft Enterprise system to Discontinue, the integration changes the stocking type of the item in the JD Edwards EnterpriseOne system to U (Obsolete - Use Up). Changes to other statues do not produce any changes in the JD Edwards EnterpriseOne system.