hi,
thank you for your example. Help me a lot, but my case is a little bit different.
I need to get the security row level base on the login user so I am using a dinamic view with the following code
SELECT rowsecclass
, oprid
FROM (
SELECT rowsecclass
, oprid
FROM SYSADM.psoprdefn )
WHERE %oprclause
With the RowsecClass I need to get the groups and display them in the LookPrompt so I am using a second dynamic view
SELECT group_id
FROM PS_TL_GRP_SECURITY
WHERE rowsecclass in (
SELECT rowsecclass
FROM p_row_sec_vw) <-- CALLING FIRST DINAMIC VIEW
when I run the page I have error "
SQL Error. #:650 Error position 95 Return: 942-ORA-00942 table or view does not exist"
I am not sure how I can accomplish this.. Any suggestion!! Please HELP ME!!
Thanks in advance
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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 :)
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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:
FROM PS_TL_GRP_SECURITY
WHERE rowsecclass in (SELECT rowsecclass
FROM (SELECT rowsecclass
, oprid
FROM ( SELECT rowsecclass
, oprid
FROM SYSADM.psoprdefn )
WHERE %oprclause)
)
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
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.