Question

Custom Field View is not accessible from SQL query

  • 22 February 2024
  • 5 replies
  • 66 views
K
Rank
Badge +2

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

 

 

5 replies

NiyomalN
Rank
Userlevel 3
Badge +9

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.

LinkedIn : www.linkedin.com/in/ niyomal-nathanielsz-18112341
K
Rank
Badge +2

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

 

T
Rank
Userlevel 7
Badge +19

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.

K
Rank
Badge +2

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!

 

T
Rank
Userlevel 7
Badge +19

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

Reply


Terms & ConditionsCookie settings