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
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!
Hi @Dumeesha Wanigarathna, Yes, I can query normal views. And I can also query default entities with custom fields by adding _CFV to the view name.But when I create a whole new Entity, it doesn't show up. Is there any specific permission that I need to give? @Tomas Ruderfelt, I dont have access to any other user other than IFSDBREADONLY. Thank you!
Hello Mayura!!!!! :)Really nice to hear from you! Thank you!
Hello, Nevermind, I figured it out. It should be:enumeration_name_CFP.decode(‘db_value’); Thank you!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
