How do you implement it? In Apex Repository or ORDS repository? Can you give more details?
in Apex webservice you can set it like so
I am using Oracle SOA Integrated gateway for exposing the webservice.
For exposing the FND_Profile I performed the following steps,
1. Go to responsibility `Integrated SOA Gateway¿ and open Integration
Repository link. Search Internal name FND_PROFILE. Go to REST web service
tab. Enter service alias PROFWS and then select all three objects.
2. Go to Grants tab. Select all 3 objects, create grant for all users.
3. Deploy the REST service as PROFWS.
--- completed, service is deployed and ready to invoke.
4. Using the third party POSTMAN app, invoke the REST service with this
Note that we are invoking using PROFWS service alias.