Scheduled Batch Validation Stops After User Password Is Changed (Doc ID 1354785.1)

Last updated on AUGUST 19, 2021

Applies to:

Goal

i.
User noticed that their scheduled Batch Validation jobs no longer ran even though the job was still scheduled after changing their database password (ie records for batch validation runs which get kicked off by the scheduled job no longer appear in the Batch Jobs screen after password is changed) .

ii.
symptoms that can be observed:

- the users database account gets locked (if the Profiles => 'FAILED_LOGIN_ATTEMPTS' database feature is being used and the number of failed logins exceed the configured value)
- the 'REP-501: Unable to connect to the specified database' error is seen in the Reports Queue Manager for the Batch Validation jobs which get kicked off by the scheduled job but fail to run

Why is that? Is there an alternative to stop this from happening?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.