SCR: Error - 'Invalid Decimal Value' if a Multi-select List Question is included in the Supplier Request Template (Doc ID 2299120.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

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

Symptoms

Multi-select list question causes error when saving a supplier change for later.

When performing a supplier change, it is possible to save your change for later.  This allows you to have a draft supplier change in place, which you can then return to later to edit further before submitting for approvals.
However, we have discovered that when initiating a supplier change for a supplier that does not have an existing value populated for a multiselect profile question type, and a response is not entered for the question prior to saving the supplier change transaction for later (even though a response to the question is not required at all) then it not possible to access that draft supplier change transaction later.

Instead, clicking on the Edit button for the draft supplier change transaction will generate a hardstop error, one that prevents access to transaction.

ERROR:
Invalid decimal value --. (180,106) SCR.Update.PopulateldPage.OnExecute  Name: Populate_profilequestions PCPC23703  Statement:195
Called from SCR.Update.PopulateldPage.OnExecute  Name:Load_idPage  Statement:1070
Called from SCR.GBL.PostBuild  Statement:1

The specified string in an invalid decimal value.

If necessary, run a PeopleCode trace (SHOW_FETCH) to determine the reason for failure.



The issue can be reproduced at will with the following steps:
Setup Supplier Change Request template to use a Multi-select list type question.
Initiate a Supplier Change Request making sure to use the Save for Later option at the end.

Call up the Supplier Change Request and Edit the request that was started above.

Error message is received:   

Invalid decimal value --. (180,106) SCR.Update.PopulateldPage.OnExecute Name: Populate_profilequestions PCPC23703 Statement:195
Called from SCR.Update.PopulateldPage.OnExecute Name:Load_idPage Statement:1070
Called from SCR.GBL.PostBuild Statement:1

The specified string in an invalid decimal value.

If necessary, run a PeopleCode trace (SHOW_FETCH) to determine the reason for failure.


The issue has the following business impact:
Due to this issue, users cannot edit a supplier change request

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