Item Ids Incorrectly Processed by Integration Broker from Price List XML File

(Doc ID 2143987.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The delivered ITEM_PRICELIST_LOAD is used for incoming 832 XML files.

The issue happens on the OnNotify method which is the code which is triggered when processing a message in Integration Broker.

When the incoming XML file includes some inventory item id's which exist in Peoplesoft and some items where it has to identify the inventory item id based on the vendor item id (existing in Peoplesoft on the Peoplesoft Inventory Item) or manufacturing id (existing in Peoplesoft on the Peoplesoft Inventory Item), the system identifies correctly only the Items which derived from their vendor item id/ manufacturing id.

The inventory item ids which are mentioned in the XML are not identified. Instead of the inventory item ids mentioned in the XML, the system integrates multiple times the last item id it has identified based on its vendor item id/ manufacturing id.



Steps to reproduce the issue:

Tested using xml file and Handler tester on 9.1 demo.


1. Setup creation for Integration Broker, per note How To Setup the Item Price List EIP (ITEM_PRICELIST_LOAD) to Add and/or Update Item Information Using People Tools 8.48 and Above (Doc ID 653306.1)
2. Item setup in order to replace the items from the customer xml file.

Examples:

Item id: 10021 for Vendor Item Id=Manufacturer’s Item Id=2851.
Item id: 10021 for Vendor Item Id=Manufacturer’s Item Id=2851.
Item id: 10023 for Vendor Item Id=Manufacturer’s Item Id=2883.
Item id: 10024 for Vendor Item Id=Manufacturer’s Item Id=2884.

3. Modified the XML file from the customer in order to test with it in our 9.1 demo.
Replaced the information in the customer XML file with the information from our 9.1 demo, using the items mentioned above. Used only 4 items (transaction sections in the xml)

4. PeopleTools > Integration Broker > Service Utilities > Handler Tester:
a) Service = Service Operation = ITEM_PRICELIST_LOAD

b) select first Handler Type (On Notify) (notice it's the same name as the method modified by the customer) and select Handler Name
c) Then provide XML (button "Provide XML') and click on Execute Event

5. Check the menus below to find your transactions:
Once the message is processed, you should be able to see the data here: SCM Integrations Transaction Error Handling Maintain Data Definitions

6. Check the table:

select EIP_CTL_ID,INV_ITEM_ID,MFG_ITM_ID from PS_ITM_LOAD_MST_EC;
select EIP_CTL_ID,INV_ITEM_ID,MFG_ITM_ID from PS_ITM_LOAD_MST_EC where EIP_CTL_ID like '1997711111%';

7. Test result: The system has integrated the first 2 items from the file, 10021 and 1022 with their corresponding Manufacturer item ids and for the other 2 item ids 10023 and 10024 the system has integrated 2 times the item id 10022.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms