Skip to main content

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?
 

 

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