My Oracle Support Banner

Procurement Spend Analysis Page Throwing Error Because of the Characters Used In Supplier Item ID (Doc ID 2314228.1)

Last updated on NOVEMBER 23, 2019

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
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

Whats Works
This error is because of the supplier Item ID entered on the requisition in Step 1.
If we change this Supplier Item ID 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.