R12 E-Business Suite Applications Framework Error 'java.sql.SQLException: ORA-01017: invalid username/password; logon denied' When Running OAF Forms From JDeveloper For OA Extensions After Case-Sensitive Password Changes
Last updated on NOVEMBER 15, 2016
Applies to:Oracle Applications Framework - Version 12.1.3 and later
Information in this document applies to any platform.
E-Business Suite R12 Applications Framework, Framework issues
Using jDeveloper with OA Extensions <Patch 9879989>, the steps in the below document result in an error:
<Note 1581584.1> - Enabling the Oracle Database 11g Case-Sensitive Password Feature for Oracle E-Business Suite Release 12.1.1
1. Stopped the EBS processes
2. Changed all passwords to upper case via FNDCPASS to ensure all passwords are in a known state.
3. Changed SEC_CASE_SENSITIVE_LOGON=TRUE in the DB and bounced the DB.
4. Used FNDCPASS to set all passwords to mixed case.
5. Restarted all the EBS processes.
After completing the above steps developing and debuging extensions does not work due to the case sensitive password changes.
Connecting to the Jdeveloper Development instance works for the actual project and in the default project settings.
However when running a page from JDeveloper against the DB with case sensitive password changes the runregion.jsp starts but fails with the following:
'java.sql.SQLException: ORA-01017: invalid username/password; logon denied'
Using <Patch 9879989> 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms