Skip to main content

Hi,

 I have created a custom field and added that into an entity. 

I also created a new entity/projection/page with some custom fields.

 

I tried to query into the custom views using PLSQL developer, 
I used:   

SELECT * FROM IFSAPP.PART_CATALOG_CFV

But it gives the error: “ORA-00942: Table or view does not exist”

 

For the custom page, I can see data in the client, and I used the View name shown in the debug console for the query, but still gives the same error.

I’m using IFSDBREADONLY as the user.

 

Any help to resolve this?

 

Thank you.

Kalindu

 

 

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.

Reply


Terms & ConditionsCookie settings