GrantsPersonnel 400 Bad Error - No Matching Row - When Updating Principal Investigator With Rest Api
(Doc ID 2947086.1)
Last updated on SEPTEMBER 04, 2023
Applies to:
Oracle Fusion Grants Management Cloud Service - Version 11.13.23.01.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.23.01.0 version, Webservices and Rest APIs
GrantsPersonnel Error - no matching row
When using the grantsPersonnel REST API endpoint to add someone as Principle Investigator using their email address, the POST fails because the email address is case-sensitive. With all lower case, the POST bombs but changing the email to first caps, the POST is successful.
ERROR
Error:
{
"title": "Bad Request",
"status": "400",
"o:errorDetails": [
{
"detail": "Applying List binding LOV_EmailAddress with given set of values leads to no matching row for a row of type :GrantsPersonnelVO, key oracle.jbo.Key[null ]",
"o:errorCode": "25072",
"o:errorPath": "/EmailAddress"
STEPS
The issue can be reproduced at will with the following steps:
1. Endpoint: https://xxxx/fscmRestApi/resources/latest/grantsPersonnel?fields=EmailAddress&onlyData=true
Payload:
{
"EmailAddress": "person.name@test.com",
"EligiblePiFlag": true
}
2. Changing the email to Person.Name@test.com, the POST completes successfully.
Payload:
{
"EmailAddress": "Person.Name@test.com",
"EligiblePiFlag": true
}
Cause
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
Symptoms |
Cause |
Solution |
References |