My Oracle Support Banner

Actions to Verify When Running Into ORA-01017 While Creating Datasource (Doc ID 1556742.1)

Last updated on APRIL 06, 2021

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.