What Jeffrie said. You can even build your main query to return your SQL for the individual queries.
select distinct 'select * from ' || A.table_name || ' where OPRID = :1;'
from all_tab_columns A, all_tab_columns B
where A.table_name = B.table_name
and A.column_name = 'OPRID'
and B.column_name = 'RUN_CNTL_ID'
and A.table_name not like '%AET'
and A.table_name not like '%VW'
and A.table_name not like '%RC'
and A.table_name not like '%TMP%'
and A.table_name not like '%BRA'
and A.table_name not like '%SRCH'
and A.table_name not like '%TAO%';
There are probably some other strings you may want to exclude from the "table_name not in" list. Even with this list of exclusions, I got over 2800 rows back, so it's still going to take a while to parse through them. Good luck!
------------------------------
Erica Simpkins
Business Systems Analyst, ITS
University of California-Santa Cruz
esimpkin@ucsc.edu------------------------------
Original Message:
Sent: 03-13-2026 07:33 AM
From: Tom Johnson
Subject: Reporting out Run Control Values for a User
Good Morning All.
I am attempting to create a method to review Run Control values for a person who is now on LOA. She has been with our institution for over 30 years, she has 100's of RC Values configured, and we are trying to document some of what she has created.
I know that there are certain dedicated tables that store RC data (like PSPRCSRUNCNTL), and there are a lot of one-off tables. I also know that HCM, FIN and CS handle this differently.
Does anyone have a document which describes how you approached this problem? (Or approached a similar situation?) I'm not looking for a single all encompassing solution, but it would be helpful to have a plan of attack that has been previously vetted.
We have other options to get at this data, plus documentation this person left, but we would prefer to also have a reporting based solution to this issue.
thank you!
------------------------------
Tom Johnson
Sr Business Systems Analyst
Duke University
tom.johnson@duke.edu
"None of us is as smart as all of us"
------------------------------