How can we make like operator work in business objects created using Oracle AI Agent Studio

Summary:

Created a business object using the below resource in AI Agent Studio. Added REST-Framework-Version=9 in header as without this the API is erroring out.

/hcmRestApi/resources/11.13.18.05/contentItemsLov?finder=findByWord;ContentTypeId=104,ContentValueSetId=300000017518708&q=upper(Name) like upper('%Oracle%')&fields=ContentItemId,ContentTypeName,ContentValueSetCode,ContentValueSetId,ItemDescription,Name&onlyData=true

When tested in postman the query works,but when using this business object in agent and trying to test the functionality the API results in no data.

Below URL also works in Postman but not when used in AI Agent Studio

/hcmRestApi/resources/11.13.18.05/contentItemsLov?q=ContentTypeName='{ContentTypeName}' AND upper(Name) LIKE upper('%{Name}%')