Question

All entities can not see in query designer

  • 15 January 2024
  • 1 reply
  • 66 views

Badge

Hi ,

We can not see any of the IFS standard entities other than custom entities in the query designer ,
This is upgraded environment from APPS8.

Anyone have an idea on this one?
 

 


1 reply

Userlevel 3
Badge +5

Hi @NayayanS ,

 

It seems that the Entities which listed in the query designer need to have Row Level Security defined in the LU level or in column level.

 

You can try below sql query (login as sys user)

 

SELECT LU_NAME, Row_level_security 
FROM ifsapp.dictionary_sys_view_active
WHERE lu_name IN ('TEST_A','TestC')
AND view_type = 'B';

 

Best Regards,
Tharindu

Reply