Providing Inventory Balances to Third-Party Systems
PeopleSoft provides the following enterprise integration points (EIPs) for transferring inventory information to third-party systems:
Inventory Balance Notification Integration Point
The Inventory Balance Notification EIPs are outbound asynchronous service operations that sends the Inventory business unit's current inventory levels to each supplier. This information is used by the supplier to determine stock replenishment quantities. These EIPs extract stock quantities (including quantity available, quantity reserved, quantity on hand, and quantity owned) from the BU_ITEMS_INV record for specified items in the business unit and relays this information to the supplier.
This integration point includes the following service operations:
|
Service Operation |
Description |
|---|---|
|
INV_BAL_NOTIF_BUS_UNIT |
Provides on-hand stock quantity balance data sorted by item then by business unit. |
|
INV_BAL_NOTIF_supplier |
Provides on-hand stock quantity balance data sorted by the supplying supplier. You can publish this message to provide suppliers with a balance summary of stock held on consignment. Suppliers can then use summaries to determine replenishment requirements for the consigned items. |
Both service operations meet the X.12 EDI requirements of the 846 − Inventory Inquiry/Advice transaction set. To publish the EDI transaction as a flat file, you must set up a batch publish rule for the application message using the Batch Publish Rule component in PeopleSoft Components.
PeopleSoft delivers the service operations in PeopleSoft Integration Broker with a default status of Inactive. You must activate each service operation before attempting to send or receive data from a third-party source or another PeopleSoft system, such as CRM.
To set up this EIP within PeopleSoft Integration Broker and Enterprise Components, use the information in the table below and refer to the setup instructions in the PeopleSoft Supply Chain Management Integrations, "Implementing Integrations", Setting Up Service Operations section.
|
Service Operation |
Direction and Type |
Handlers |
Chunking Available? |
Integrates With |
|---|---|---|---|---|
|
INV_BAL_NOTIF_BUS_UNIT |
Outbound Asynchronous |
No |
Third-party supplier systems |
|
|
INV_BAL_NOTIF_VENDOR |
Outbound Asynchronous |
No |
Third-party supplier systems |
See Setting Up Service Operations.
See PeopleTools : Integration Broker
Inventory by Location Integration Point
The Inventory Balance By Location Request EIP is an inbound synchronous service operation that enables a third-party system or another PeopleSoft database to inquire on item balances by material storage locations. The service operation has an option that allows the item balance information to be presented in summary, or, in detail, with visibility to serial ID and lot ID information.
PeopleSoft delivers the service operations in PeopleSoft Integration Broker with a default status of Inactive. You must activate each service operation before attempting to send or receive data from a third-party source or another PeopleSoft system, such as CRM.
To set up this EIP within PeopleSoft Integration Broker and Enterprise Components, use the information in the table below and refer to the setup instructions in the PeopleSoft Supply Chain Management Integrations, "Implementing Integrations" topic, Setting Up Service Operations section.
|
Service Operation |
Direction and Type |
Handlers |
Chunking Available? |
Integrates With |
|---|---|---|---|---|
|
INVENTORY_BY_LOC_REQ |
Inbound Synchronous |
REQUESTHDLR |
No |
Third-party systems |
Within the service operation, service, and version, attach both the INVENTORY_BY_LOC_REQ and INVENTORY_BY_LOC_RSP messages for request and response.
See Setting Up Service Operations.
See PeopleTools: Integration Broker
Inventory Item Balance using PeopleSoft Business Interlink
The Inventory Item Balance request/response business interlink (IN_ITEM_BALANCES and RF_IN_ITEM_BALANCES) sends item availability and storage location information to third-party systems. This request/response business interlink provides visibility to stock levels and can be used by third parties as well as another PeopleSoft database. The interlink has options that enable the requesting side to view information for a single item in SetID summary or in detail by distribution network and business unit with further details by storage location. The RF_IN_ITEM_BALANCES business interlink can be integrated with the PeopleSoft CRM Field Service database.
You can publish:
Availability for a single item or for multiple items.
Availability for a single storage location or for locations in all business units in the distribution network.
Location status information that shows quantities and flags for locations.
To set up a business interlink, use PeopleTools to:
Enter the correct merchant URL on the Business Interlink definition.
Enter the correct userid/password on the Business Interlink definition. This userid /password should be the same as the userid/password defined for the web profile.
See the product documentation for