You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I create an Expense Report using an OIC OAuth JWT Assertion Connection?

edited Aug 23, 2026 10:42PM in Integration

Summary:

I'm trying to create an expense report using an OAuth JWT Assertion connection. I want to verify that, when I query the expense report using something like SELECT ... WHERE expense_report_num = 'GAST-000...', the CREATED_BY column shows the user that I'm passing as a parameter in the integration.
I configured an Oauth JWT Assertion Connection in OIC but when I try to use it I get this error message:

CloudInvocationException [ Fault Details :
<ns0:APIInvocationError xmlns:ns0="http://xmlns.oracle.com/cloud/generic/rest/fault/REST/createExpense"><ns0:type/><ns0:title/><ns0:detail/><ns0:errorCode/><ns0:errorDetails><ns0:type>http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.2</ns0:type><ns0:title>Unauthorized</ns0:title><ns0:errorCode>401</ns0:errorCode><ns0:errorPath>&lt;![CDATA[InboundJaxrsResponse{context=ClientResponse{method=POST, uri=https://ebxu-test.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/expenseReports, status=401, reason=Unauthorized}}]]&gt;</ns0:errorPath><ns0:instance>&lt;![CDATA[.The 401 error message is usually returned by services that requires user credentials. So if you have got this error then it pobably means you entered an invalid username or password. It may also be that one of the intermediaries (proxy, LBR) could be returning this code. Please note, test connection doesn't validate the credentials and even if it is successful, it may not be sufficient. As the parameters defined within the connection page are used to call the target endpoint REST API, which is configured as part of endpoint configuration, it is strongly recommended that

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!