Custom Field View is not accessible from SQL query

Hi @Kalindu ,

Did you publish and sync those fields ?

if you are using a different user, check whether you have granted the correct permissions too.

Kind Regards!

Niyomal.

Hi @NiyomalN ,

 Yes I have published and synced the fields. 

I’m wondering whether its because I’m using IFSDBREADONLY user. Is there any special permissions to access custom views? I can query and fetch data from tables (*_TAB ) as well, but not CFV and CLV. 

Regards,

Kalindu

Yes, that user do not get granted automatically.
You could use the IAL user (IFSINFO) instead. That one should get permissions to see views and tables automatically when publishing.

Thanks @Tomas Ruderfelt ,

Basic question, can I give read-only access to query from oracle database to a IAM user?

What steps should I take to make this work? 

I have given FND_IAL_ADMIN permission to the user, but when I try to test my connection, it always says “Logon denied: Invalid username/password” 

Thanks!

No, since a user in IFS Cloud is not created as Oracle user, as it was in APP10 and earlier.