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:

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

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