well for one, you last line FROM p_row_sec_vw is missing the ps_ it should be "FROM ps_row_sec_vw" - This will cause your table or view does not exist error. Fix that and try again :)

Hi,
Thanks for your time. The last line p_row_sec_vw is a dinamyc view also so it is not part of the DB. However I tried with ps_p_row_sec_vw and still same error.

I tried this other SQL in a dynamic view (to avoid dinamyc view calling dynamic view), don't give error but it did not return anything?

SELECT group_id
FROM SYSADM.PS_TL_GRP_SECURITY
WHERE rowsecclass IN (
SELECT rowsecclass
FROM SYSADM.psoprdefn
WHERE %oprclause)

I appreciate any help. Thanks a lot!

I not sure what you are really tying to accomplish BUT why do you need to dynamic views? Why not put every thing into one like the following:

Try including either the OPRID or OPRCLASS in the search record for the page/ Component where the error occured.

Hey, ur error clearly showing that there is some table which left unbuilt...So check out for the that table and build it...

The error must be specifying which table/view does not exist. try to build that record again n the log file will show you where the error is during the build process. In case of view, this error occurs when there is some error in the sql n hence the view couldn't be built. Hope it helps.