- Distribute to
- Destination
- Email Address List
- 2 Posts
- 16 Views
Where do we update the SQR process email address list
Hello,
We have an SQR recurrenct process that run once every week.
It is sending resulting PDF to a list of emails defined within the process:
We need to update these email and distribution IDs but so far cannot find where to do it.
Anyone shedding some light will appreciated
@Kelvin-TT
The following from MOSC may assist you:
https://community.oracle.com/mosc/discussion/comment/15409853/#Comment_15409853
PS_PRCSRUNCNTL - Stores user's language code and language option
PSPRCSRUNCNTLS - Stores server name and time zone
PS_PRCSRUNCNTLEOPT - Stores parameters for process request runs to email such as email address, subject, body text…etc.
PS_PRCSRUNCNTLDTL - Stores run control details such as output type, output format, output destination, folder name, email output option for per process type and process name
PS_PRCSRUNCNTLDIST - Stores distribution list