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 (Doc ID 2196763.1)

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.

Symptoms

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'


Changes

 Using <Patch 9879989> 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms