accesses internal tables workflow

[LoumerJosephMor]

Hi,

I am trying to migrate the workflows from 7.0.1 to 7.1.1 and added a two SQL Select for Manual Account Activities Workflow. Then I copied the SQL query from 7.0.1 to 7.1.1 and it gives me warning that Accesses internal tables.

SQL Select 1 contains:

select TECHNICAL_OWNER from avuser.t_applications where NAME = ${access_request_cri_app_name}

SQL Select 2 contains:

select entitled_id as OtherTechnicalOwners from avuser.t_av_security_values where (reference_key = 'APP_OTO' AND reference_id =(select ID from T_APPLICATIONS where NAME = ${access_request_cri_app_name}))

For additional details please refer at the images below:

What causes this error and how can I fix it? Thank you in advance.

[BorisLekumovich · Accepted solution]

The warning is in place as RSA suggested practice is to query public views instead of internal tables.

The is a warning only, you can still query the internal tables if you can't find the relevant information in the public views