EBS 12.1.3 Registration with OID 11.1.1.5 through SSL for SSO

Got the following error while executing the EBS-OID registartion script from EBS DB.

Steps followed:

1. Import the OID certificates into the EBS DB key store.
2. Create a dedicated admin account in OID which will be used for EBS-OID registration. eg: cn=ebsadmin
3. Execute the OID registration script from EBS DB as per the Oracle guidelines.


applscp@ebsapplication01:12.1.3 ebsapp01_BALANCE$ $FND_TOP/bin/txkrun.pl \
> -script=SetSSOReg \
> -registeroid=yes \
> -ldaphost=oidlb.testdomain.com \
> -ldapport=389 \
> -oidadminuser=cn=ebsadmin,cn=Users,dc=testdomain,dc=com \
> -oidadminuserpass=******* \
> -appspass=xxxx \
> -instpass=*******

You are registering this instance with OID Server.


*** Log File = /u01/app/applscp/inst/apps/ebsapp01_ebsapplication01/logs/appl/rgf/TXK/txkSetSSOReg_Tue_May_15_13_45_05_2012.xml

Beginning input parameter validation for OID registration.
Input parameters validation for OID registration completed.

BEGIN OID REGISTRATION:
Beginning to register Application and Service containers if necessary.
Application and Service containers were created successfully if necessary.
Beginning to register application in Oracle Internet Directory.
Registration of application in Oracle Internet Directory completed successfully.
-> LOADING:  /u02/app/applscp/apps/apps_st/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp
Beginning to register provisioning profile in Oracle Internet Directory.


*** ERROR :  Application Provisioning profile registration is not Successful.
May be provisioning does not exist.It is recommended that you review the log files to determine the cause


End of /u02/app/applscp/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered


applscp@ct11bzapp136:12.1.3 caoa071_BALANCE$ view /u01/app/applscp/inst/apps/ebsapp01_ebsapplication01/logs/appl/rgf/TXK/txkSetSSOReg_Tue_May_15_13_45_05_2012.xml
  INFO
  oracle.apps.fnd.txk.ias.oid.BiDirectionalProfile
  create
  10
  Creating a BiDirectional (default) Profile


  2012-05-15T13:45:13
  1337089513180
  75
  txkSetSSOReg
  SEVERE
  oracle.apps.fnd.txk.ias.oid.BiDirectionalProfile
  create
  10
  java.lang.Exception: ERROR: [LDAP: error code 50 - Insufficient Access Rights]
The Provisioning Profile for the Application could not be created.
    at oracle.ldap.util.provisioning.ProvisioningProfileV2.process(ProvisioningProfileV2.java:185)
    at oracle.ldap.util.provisioning.ProvisioningProfile.manageProfiles(ProvisioningProfile.java:722)
    at oracle.ldap.util.provisioning.ProvisioningProfile.ProfileHandler(ProvisioningProfile.java:680)
    at oracle.apps.fnd.txk.ias.oid.BiDirectionalProfile.create(BiDirectionalProfile.java:66)
    at oracle.apps.fnd.txk.ias.oid.Provisioning.create(Provisioning.java:221)
    at oracle.apps.fnd.txk.ias.oid.Instance.createProvisioning(Instance.java:1028)
    at oracle.apps.fnd.txk.ias.oid.Instance.register(Instance.java:947)
    at oracle.apps.fnd.txk.ias.oid.Instance.main(Instance.java:1390)


  2012-05-15T13:45:13
  1337089513180
  76
  txkSetSSOReg
  SEVERE
  oracle.apps.fnd.txk.ias.TXKSTDIO
  exception
  10
  oracle.apps.fnd.txk.ias.SsoOidException: Application Provisioning profile registration is not Successful.
May be provisioning does not exist.It is recommended that you review the log files to determine the cause

    at oracle.apps.fnd.txk.ias.oid.Provisioning.create(Provisioning.java:224)
    at oracle.apps.fnd.txk.ias.oid.Instance.createProvisioning(Instance.java:1028)
    at oracle.apps.fnd.txk.ias.oid.Instance.register(Instance.java:947)
    at oracle.apps.fnd.txk.ias.oid.Instance.main(Instance.java:1390)



Solution:

Login to your OID via ODSM console, open data browser, open root => cn=oracle internet directory => cn=DirectoryAdminGroup. Click on green "+" and add newly created user as a member of this group. And re-run the registration script.

!!!All the best !!!

OAM EBS integeration for SSO - RAC Accessgate Datasource Creation issue

Environment Details:  Oracle E-Business Suite 12.1.3 is been integrated with Oracle Access Manager 11.1.1.5 for SSO. EBS is hosted on the RAC database. So I am aware that i need to create the Accessgate datasources manually and may deploy the application using the script.

Issue:  I am getting the following error while creating the Datasource using the DBC files generated from the EBS DB. The following exception has been thrown in the Accessgate server logs.

"An error occurred during activation of changes, please see the log for details"

"weblogic.application.ModuleException"

"Could not connect ro 'oracle.apps.fnd.ext.jdbc.datasource.AppsdataSource'. The returned message is : ORA-01017:invalid username/password; logon denied it is likely that the login or password is not valid. It is also possible that something else is invalid in the configuration or that the datasource is not available."

<[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1334603711605> weblogic.application.ModuleException:
    at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:302)
    at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
    at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:518)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
    at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
    at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:47)
    at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:614)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
    at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:184)
    at weblogic.application.internal.SingleModuleDeployment.prepare(SingleModuleDeployment.java:43)
    at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
    at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.createAndPrepareContainer(ActivateOperation.java:208)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doPrepare(ActivateOperation.java:98)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.prepare(AbstractOperation.java:217)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentPrepare(DeploymentManager.java:749)
    at weblogic.deploy.internal.targetserver.DeploymentManager.prepareDeploymentList(DeploymentManager.java:1216)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handlePrepare(DeploymentManager.java:218)
    at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.prepare(DeploymentServiceDispatcher.java:160)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doPrepareCallback(DeploymentReceiverCallbackDeliverer.java:171)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.prepare(DeploymentReceiverCallbackDeliverer.java:41)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.callDeploymentReceivers(AwaitingContextUpdateCompletion.java:164)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.handleContextUpdateSuccess(AwaitingContextUpdateCompletion.java:66)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.contextUpdated(AwaitingContextUpdateCompletion.java:32)
    at weblogic.deploy.service.internal.targetserver.TargetDeploymentService.notifyContextUpdated(TargetDeploymentService.java:225)
    at weblogic.deploy.service.internal.DeploymentService$1.run(DeploymentService.java:190)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused By: weblogic.common.resourcepool.ResourceSystemException:
 Could not connect to 'oracle.apps.fnd.ext.jdbc.datasource.AppsDataSource'.

 The returned message is: ORA-01017: invalid username/password; logon denied

 It is likely that the login or password is not valid.
 It is also possible that something else is invalid in
 the configuration or that the database is not available.
    at weblogic.jdbc.common.internal.JDBCUtil.parseException(JDBCUtil.java:301)
    at weblogic.jdbc.common.internal.PooledConnectionEnvFactory.makeConnection(PooledConnectionEnvFactory.java:313)
    at weblogic.jdbc.common.internal.PooledConnectionEnvFactory.createResource(PooledConnectionEnvFactory.java:97)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1249)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1166)
    at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:249)
    at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1155)
    at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:154)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:455)
    at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:372)
    at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:255)
    at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
    at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:518)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
    at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
    at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:47)
    at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:614)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
    at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:184)
    at weblogic.application.internal.SingleModuleDeployment.prepare(SingleModuleDeployment.java:43)
    at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
    at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.createAndPrepareContainer(ActivateOperation.java:208)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doPrepare(ActivateOperation.java:98)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.prepare(AbstractOperation.java:217)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentPrepare(DeploymentManager.java:749)
    at weblogic.deploy.internal.targetserver.DeploymentManager.prepareDeploymentList(DeploymentManager.java:1216)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handlePrepare(DeploymentManager.java:218)
    at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.prepare(DeploymentServiceDispatcher.java:160)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doPrepareCallback(DeploymentReceiverCallbackDeliverer.java:171)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.prepare(DeploymentReceiverCallbackDeliverer.java:41)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.callDeploymentReceivers(AwaitingContextUpdateCompletion.java:164)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.handleContextUpdateSuccess(AwaitingContextUpdateCompletion.java:66)
    at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingContextUpdateCompletion.contextUpdated(AwaitingContextUpdateCompletion.java:32)
    at weblogic.deploy.service.internal.targetserver.TargetDeploymentService.notifyContextUpdated(TargetDeploymentService.java:225)
    at weblogic.deploy.service.internal.DeploymentService$1.run(DeploymentService.java:190)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Root Cause for this Error: DBC file was not generated properly and had some issue.

Solution:  Re-generated the DBC file using the following command and tried to creating the AccessGate datasource which resolved the issue.


java oracle.apps.fnd.security.AdminDesktop apps/APPS CREATE NODE_NAME= DBC=${FND_SECURE}/${TWO_TASK}.dbc