Procurement Spend Analysis Page Throwing Error Because of the Characters Used In Supplier Item ID
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.
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
1.Create a purchase order and enter Supplier Item ID as : VOYA-1000-2 - KEVIN MILLER, CLU®,CHFC&
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.
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
This error is because of the supplier Item ID: VOYA-1000-2 - KEVIN MILLER, CLU®,CHFC& 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.
Procurement Spend analysis page throwing error because of the characters used in Supplier Item ID
Business Impact: Loss of functionality
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms