Oracle Applications Endpoint 'Oracle_EBS' creation failed: Connector Server Add failed: code 49 (INVALID_CREDENTIALS)

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Error when trying to Create Oracle EBS (Oracle Application Endpoint)
jcs_daily.log Shows :
2019-01-03 10:25:15,837 1117889890 [ApacheDS Worker-thread-175] (com.ca.jcs.csproxy:com.ca.jcs.csproxy.CSProxyMetaConnectorType:362) 
ERROR - Failed to activate connector on proxy connector server 
javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Oracle Applications credentials.]; 
remaining name 'eTFNDDirectoryName=Oracle_EBS,eTNamespaceName=Oracle Applications,dc=im,dc=etasa' 

server.log Shows :
2019-01-03 10:25:22,092 ERROR [com.netegrity.ims.exception.EventExecuteStateException] 
(Thread-2781 (HornetQ-client-global-threads-1140550615)) Execution of event: CreateOracleApplicationsEndpoint failed. 
Exception encountered: Oracle Applications Endpoint 'Oracle_EBS' creation failed: Connector Server Add failed: 
code 49 (INVALID_CREDENTIALS): failed to add entry eTFNDDirectoryName=Oracle_EBS,eTNamespaceName=Oracle Applications, 
dc=im,dc=etasa: [email protected]: JNDI: Failed to activate connector on proxy connector server: 
[LDAP: error code 49 - Invalid Oracle Applications credentials.] (ldaps://10.145.29.31:20411), 
 

- Customer created a database account called “IDMEBSBD” , informing it was granted with same privileges like “APPS” user account.

Environment

vApp 14.2 
Oracle EBS 12 
 

Resolution

1. Hypothesis is a UserID access rights issue.
2. To discard/confirm , configure the UserID for ODBC Datasource Configuration with a Oracle System Administrator Account 
ie :
TNS Service Name =ebsts
UserID=APPS

** Where "APPS" is a full Rights User on Oracle-EBS

3. Also configure from IDM User console->Endpoints->Manage endpoint->Create Endpoint->Oracle Applications 
**Under Connection Information Section :
Add the following :
ODBC Data source name (DSN)=OracleEBS
Database user name =APPS

** Under Applications section, we left the default values as appearing below :
Application Database Name=APPS
Administrative Database Name=APPLSYS
Applications User Name =ETAAPP

4. Save , Endpoint should be created .

5. Additional Test to confirm all is going well :
   a) From Provisioning Manager Console, Opened the new Endpoint created and do an "Explore & Correlate ",
        Set Action = "Explore endpoint to Managed Object " option selected only for testing purposes.

   b) modify a User Description, save and check if  change is replicated to Oracle-EBS endpoint
 

Additional Information

https://docops.ca.com/ca-identity-manager-and-governance-connectors/1-0/EN/connectors/oracle-connectors/connector-for-oracle-applications