Actions to Verify When Running Into ORA-01017 While Creating Datasource
(Doc ID 1556742.1)
Last updated on MAY 25, 2024
Applies to:
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Purpose
The <Note:974949.1> "Oracle E-Business Suite Software Development Kit for Java (includes AppsDataSource, Java Authentication and Authorization Service, session management)" explains the steps to create a Datasource for external applications to connect to the E-Business Suite database.
An error often reported here is the ORA-01017: invalid username/password; logon denied which normally indicates that a database user passed incorrect credentials. However when it comes to creating Datasource the ORA-01017 is raised as soon as there is an issue with the connection and the actual ORA message is not reporting the actual error.
This document will provide a number of things to verify which may assist in troubleshooting the ORA-01017 when raised in context of Datasource.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Troubleshooting Steps |
1. Verify the FND user defined in the Datasource |
2. Verify relevant profile options |
3. Small test class to verify the connection |
References |