https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-2499D868-5775-4F42-944E-BE7EDEFF2AC8.htm
The passwords for all data sources in the datasources.xml file are not migrated during the migration. You must manually enter and save the password for each...
oracle bi publisherdata sourcesconfiguringpasswords