For the Task manager, the password is stored in the Logon Tab of the HyperionFinancialDataQuality Task Manager Service in the windows service panel
For the FDM load Balance Configuration it is set on the identity of the Load Balance Server DCOM object on the FDM application server.
The service account password is not stored in the database.
Do you have any custom scripts that are executing that are storing the old password and causing the lockout possibly?
I guess Password for service account doesnt get stored in somewhere FDM config . If password for the the service account gets stored somewhere in config files then the password you entered while configuring FDM should be used always as it is got stored(hard coded) somewhere in config files and changing the domain password shouldn't affect FDM login for that service account but which is not the case so basically the password gets stored in AD config side rather than the FDM side it just authenticates based on the acknowledgement from AD something like TRUE allow to login and False don't allow to login.
The passwords for native user end would be stored at FDM end but not sure of the location , happy to know further on this if someone is able to provide.
The password for the service account would not be stored on the file system except if it was used for a scheduled task and it was in the FDMTaskManagerConfiguration file under Oracle\Middleware\EPMSystem11R1\Products\FinancialDataQualtiy\SharedComponents\Config
The password for the configuration items is stored in the windows DCOM objects. If you reset the Configuration, the password would be changed on the objects.