Procurement Spend Analysis Page Throwing Error Because of the Characters Used In Supplier Item ID

(Doc ID 2314228.1)

Last updated on OCTOBER 04, 2017

Applies to:

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

Symptoms

FSCM 9.2 Image 23 Tools: 8.54 Environment Affected: NA

Issue: Procurement Spend analysis page throwing error because of the characters used in Supplier Item ID

Steps
1.Create a purchase order and enter Supplier Item ID as : VOYA-1000-2 - KEVIN MILLER, CLU®,CHFC&AMP
2.Save and Dispatch the PO
3.Navigate to Main Menu > Purchasing > Analyze Procurement > Update Spend History
And make sure that process goes to success.
4.Navigate to Fluid Home and select Procurement Options from the dropdown.
5.Click on Procurement Spend analysis tile
6.Select from date and To date as current date
7.Click on search button. Error message is displayed.

Error:

Invalid decimal value--#174.(180,106) PT_PACKAGE.PT_PGInformation.OnExecute Name: GetAllDimesnionValues PCPC:71883 Statement: 1274
Called from:PTPG_API.Model.OnExecute Name:getFacets Statement:69
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:GetFacetNodes Statement:608
Called from:PTS_SEARCH:PivotGridSearch.OnExecute Name:fillFacetArea Statement:327
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:DoSearch Statement:209
Called from:PTS_SRCH.PTS_SRCH_BTN.FieldFormula Name

Whats Works
This error is because of the supplier Item ID: VOYA-1000-2 - KEVIN MILLER, CLU®,CHFC&AMP entered on the requisition in Step 1.
If we change this Supplier Item ID to : VOYA-1000-2 - KEVIN MILLER it doesn’t throw any error message. Why is PeopleSoft behaving like this as Supplier Item ID is free form text field.


Actual Results:
Procurement Spend analysis page throwing error because of the characters used in Supplier Item ID

Business Impact: Loss of functionality

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