Don't forget to apply this patch when upgrading to 12.1.1 !

In a recent test upgrade from 11.5.10.2 (ATG RUP6) to R12.1.1, one of the issues we discovered is that users are unable to login after the upgrade due to an "invalid password" message. Resetting the password using FNDCPASS did not help. After logging an SR with Support and much troubleshooting, we discovered that an important pre-requisite patch had been overlooked.


The patch number is 8764069 and it needs to be applied in pre-install mode (see the patch README for detailed instructions). The cause of the issue and the fix that this patch delivers is found in these MOS Documents -


566521.1 - Oracle Application Object Library Release Notes, Release 12.1.1 (see Section 5)
457166.1 - FNDCPASS Utility New Feature: Enhance Security With Non-Reversible Hash Password (see highlighted Note #5 (in yellow) in the "Goal" section)


In essence, if you are on 11.5.10.2 ATG RUP6 or higher, and have migrated to using non-reversible hash passwords using the FNDCPASS USERMIGRATE functionality delivered in ATG RUP6, and are now migrating to R12.1.x, this patch needs to be applied before the upgrade.


Not doing so will, unfortunately, make the upgraded instance unusable - and there is no fix, other than to re-do the upgrade from scratch. MOS Docs 942600.1 (Post Rapid Wiz Install Check Fails On Login Page With RW-50016 After Upgrading From 11i or 12.0.x to 12.1.x) and 566521.1 indicate that this patch can be applied after the upgrade, but this did not remedy the situation in our case. We basically had to start with the upgrade process all over again.


This important pre-requisite is not currently documented in any of the R12.1.x upgrade guides.


REFERENCES


566521.1 - Oracle Application Object Library Release Notes, Release 12.1.1
457166.1 - FNDCPASS Utility New Feature: Enhance Security With Non-Reversible Hash Password
942600.1 - Post Rapid Wiz Install Check Fails On Login Page With RW-50016 After Upgrading From 11i or 12.0.x to 12.1.x)