E-Business Suite R12 : Users Not Getting Provisioned From OID To E-Business Suite After Registering OID 11g With EBS (Doc ID 1267163.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

E-Business Suite R12 Applications Technology Stack, OID SSO Technologies issues

After installing E-Business Suite version 12.1.3 to be integrated with OID 11g, OID SSO Technologies, provisioning from OID to EBS is not working.

When a user is created in OID, the same user is not getting created in E-Business Suite.

Below error can be observed in wls_ods1-diagnostic.log on OID 11g environment:

(11g Oracle Home/user_projects/domains/IDMDomain/servers/<managed_servername>/logs/<managed_servername>-diagnostic.log) 

[2010-11-15T12:16:16.539-06:00] [wls_ods1] [ERROR] [DIP-20050] [oracle.dip] [tid: <profile>_E] [userId: weblogic] [ecid: 0000IlCKNcLADSoqwSicMG1CqBo_0000a0,0] [APP: DIP#11.1.1.2.0] [arg: jdbc:oracle:thin:@<dbhost>:<dblistenport>:<SID>] [arg: APPS] connecting as : URL : jdbc:oracle:thin:@<dbhost>:<dblistenport>:<SID> , User : APPS
[2010-11-15T12:16:16.539-06:00] [wls_ods1] [ERROR] [DIP-20052] [oracle.dip] [tid: <profile>_E] [userId: weblogic] [ecid: 0000IlCKNcLADSoqwSicMG1CqBo_0000a0,0] [APP: DIP#11.1.1.2.0] Exception on connecting to DB.[[
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at oracle.ldap.odip.gsi.DBConnector.connect(DBConnector.java:185)
at oracle.ldap.odip.gsi.PLSQLWriter.initialise(PLSQLWriter.java:156)
at oracle.ldap.odip.prov.ProvPLSQLWriter_2_0.initialise(ProvPLSQLWriter_2_0.java:63)
at oracle.ldap.odip.prov.ProvOIDToAppSync_2_0.initialise(ProvOIDToAppSync_2_0.java:189)
at oracle.ldap.odip.web.DIPProvBean.runOldVersion(DIPProvBean.java:1059)
at oracle.ldap.odip.web.DIPProvBean.doOneIteration(DIPProvBean.java:616)
at oracle.ldap.odip.web.DIPProv_o70i40_EOImpl.doOneIteration(DIPProv_o70i40_EOImpl.java:64)
at oracle.ldap.odip.web.ProvQuartzJobImpl.execute(ProvQuartzJobImpl.java:174)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:634)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:208)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 16 more
Caused by: java.net.UnknownHostException: <host>
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:189)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
... 21 more

Changes

 NA

Cause

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