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

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

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