IBM Security Identity Adapter 7.1.12 for Oracle eBS - Release notes

IBM Security Identity Adapter 7.1.12 for Oracle eBS Adapter is available. Compatibility, installation, and other getting-started issues are addressed.





These Release Notes contain information for the following products that was not available when the IBM Security Identity Server manuals were printed:

Oracle eBS Adapter Installation and Configuration Guide


Adapter Features and Purpose

 The Oracle eBS Adapter is designed to create and manage accounts on the Oracle e-Business Suite application. The adapter runs in "agentless" mode and communicates using JDBC to the systems being managed.

IBM recommends the installation of this Adapter (and the prerequisite Tivoli Directory Integrator) on each node of IBM Security Identity Server WebSphere cluster. A single copy of the adapter can handle multiple IBM Security Identity Server Services. The optimum deployment configuration is based, in part, on the topology of your network domain, but the primary factor is the planned structure of your IBM Security Identity Server Provisioning Policies and Approval Workflow process. Please refer the IBM Knowledge Centre for a discussion of these topics.

IBM Security Identity Server Adapters are powerful tools that require administrator level authority. Adapters operate much like a human system administrator, creating accounts, permissions and home directories. Operations requested from the IBM Security Identity Server will fail if the adapter is not given sufficient authority to perform the requested task. IBM recommends that this adapter run with administrative (root) permissions.

License Agreement


Review and agree to the terms of the IBM Security Identity Adapter License prior to using this product.

The license can be viewed from the "license" folder included in the product package.



Contents of this Release

Adapter Version



Build Date

2017 December 08 06.39.33

Adapter Version


Component Versions

Adapter build:



Dispatcher 7.0.32(packaged separately)


The following guides are available in the IBM Knowledge Centre

         Oracle EBS Adapter Installation and Configuration Guide





New Features


Enhancement # (RFE)




Items included in current release(7.1.12)



Support for the new specialFlags attribute in targetProfile.json


Items included in 7.1.11 release

RTC 151780

Add Support for Identity Governance and Intelligence (IGI) v5.2.2


This adapter is now designed for use with IBM Security Identity Manager,

Privileged Identity Manager, and Identity Governance and Intelligence.


Items included in 7.0.10 release





ODBC: eBS 12.2.5  (GA 10/15)

Support for Oracle EBS adapter V12.2.5



RTC 133536

Support for Complex attribute handler for OracleeBS

Note: Refer to Installation and Configuration Notes, Corrections to Installation Guide section.



Items included in 7.0.9 release


64565 (33791)



Support for Oracle EBS adapter  V12.2




RFE 65867 (34485)


Oracle EBS adapter posed a security hole when user is suspended but individual responsibility code is not end-dated.


Note: Refer to Installation and Configuration Notes, Corrections to Installation Guide section.



Items included in 7.0.8 Release


PMR 88770,999,000



Added service form options for support data.

Do not Reconcile Roles?

Do not Reconcile Suppliers?

Do not Reconcile Persons?

Do not Reconcile Customers?

Do not Reconcile Responsibilities?

Do not Reconcile Securing Attributes?


If any of above checkbox is selected then that support data won't be reconciled.

E.g.: If checkbox for "Do not Reconcile Roles?" is checked then Roles won't be reconciled.



Items included in 7.0.7 release


Initial Release




Closed Issues



PMR# / Description



Items closed in current release(7.1.12)

RTC 168156

Bug 2454

PMR 45750,004,000

As an Oracle eBS adapter developer, I must ensure my adapter works correctly with IGI 5.2.3.

RTC 169649

Bug 2465


PMR 47347,004,000 - TS000016292

As an Oracle eBS adapter developer, I must ensure my adapter correctly handles date/time attributes



Items closed in 7.1.11 release






Items closed in 7.0.10 release






Items closed in 7.0.9 release






Items closed in 7.0.8 release





Items closed in 7.0.7 release


RTC 108806


 PMR 21917,000,834


Removed service group for responsibilities from service.def as ISIM does not support subforms for service groups.




Initial Release































Known Issues



PMR# / Description




Deprovisioning user accounts

Account deprovisioning is not supported natively (no stored procedure) in

Oracle e-Business Suite and is therefore not available in the adapter.




Changing a Password on a Suspended Account

On Oracle eBS 12i if account is suspended (end dated) then password change

operation will fail with following error: "ORA-20001: APP-FND-02602: Unabled

to change password for user XXXXXXX for this following reason: Your account

does not exist or has expired"

Work Around:

1. You must enable the account first by setting future end date or deleting the end date and then perform password change.

2. Use restore operation and specify new password.




Anonymous Record History

Assigning or modifying responsibilities through ITIM results in the audit fields

("Created By" and "Updated By") showing an anonymous value.


To have the "SYSADMIN" value show in the audit fields for the responsibility

record of an Oracle eBS user account, modify OracleEBSManageUserAL.xml

and nonAPPS.sql (if using a non-APPS user) as follows:

Step 1. Changes required for OracleEBSManageUserAL.xml:

In the conOracleEBSManageUser connector, add the following piece of code

to the After Initialize hook of the Prolog section:

if (g_bIsAPPSUser) {

task.logmsg("DEBUG","Initialized session parameters APPS");

result = thisConnector.connector.execSQL("Begin

FND_GLOBAL.APPS_INITIALIZE( 0, -1, -1, 0, -1); end;");

} else {

task.logmsg("DEBUG","Initialize session parameters Non-APPS");

result = thisConnector.connector.execSQL("Begin

APPS.ITIM_APPS_INITIALIZE(0, -1, -1, 0, -1); end;");


if (result != "") {

task.logmsg("ERROR","Could not initialize the session



Failed. Error: " + result);

else task.logmsg("DEBUG","APPS.ITIM_APPS_INITIALIZE Failed. Error:

" + result);


After making the changes, recreate the OraEBSProfile.jar. Import the modified

OraEBSProfile.jar to ITIM.

Step 2. Changes required in nonAPPS.sql:

Add the following lines to the nonAPPS.sql and execute the file.


user_id in number,

resp_id in number,

resp_appl_id in number,

security_group_id in number default 0,

server_id in number default -1

) AS begin


user_id => user_id,

resp_id => resp_id,

resp_appl_id => resp_appl_id,

security_group_id => security_group_id,

server_id => server_id);


grant execute on APPS.ITIM_APPS_INITIALIZE to nonapps;




Installation and Configuration Notes


 Corrections to Installation Guide


Language package installation

The adapters use a separate language package from the IBM Security Identity Server. See the IBM Security Identity Server library and search for information about installing the adapter language pack.




 Configuration Notes

 The following configuration notes apply to this release:

Option for deploying the custom sub forms

The Oracle eBS Adapter is supplied with custom subforms to specify the roles, responsibilities, and securing attributes associated with a user. The subforms are contained in the file.

Before you begin

Extract the contents of the file to the subforms folder of the installed IBM Security Identity Server web application.

For a self service console installation


For an administrative console installation


For Identity Service Center installation


About this task

In a clustered environment the subform must be deployed on each WebSphere application server. If WebSphere version 6.1 is being used, the jdkSourceLevel JSP engine configuration parameter must be set to15 for each web application on which the subforms are deployed.


1.     Open the WEB-INF/ibm-web-ext.xmi file from the configuration directory. For example, WAS_PROFILE_HOME/config/cells/cellName/applications/ITIM.ear/deployments/ITIM/webModuleName. The webModuleName is the itim_self_service.war file or the itim_console.war file or both.

2.     Add the following tag within the content of the webappext:webAppExtension tag:

<jspAttributes xmi:id="JSPAttribute_1" name="jdkSourceLevel" value="15"/>

Note: The integer n in JSPAttribute_n has to be unique within the file.

3.     Save the file.

4.     Take one of the following actions:

o    Restart the IBM Security Identity Server application from the WebSphere Administrative Console.

o    Restart the service.


Customizing or Extending Adapter Features

IBM Security Identity Server adapters can be customized and/or extended. The type and method of this customization may vary from adapter to adapter.

Getting Started

Customizing and extending adapters requires a number of additional skills. The developer must be familiar with the following concepts and skills prior to beginning the modifications:

Note: If the customization requires a new IBM Tivoli Directory Integrator connector, the developer must also be familiar with IBM Tivoli Directory Integrator connector development and working knowledge of Java programming language.

IBM Security Identity Server Resources:

            Check the "Training" section of the IBM Knowledge Centre for links to training, publications, and demos.

IBM Security Directory Integrator Resources:

            Check the "Training" section of the IBM Security Directory Integrator Support web site for links to training, publications, and demos.

Support for Customized Adapters

The integration to the IBM Security Identity Server server "the adapter framework" is supported. However, IBM does not support the customizations, scripts, or other modifications. If you experience a problem with a customized adapter, IBM Support may require the problem to be demonstrated on the GA version of the adapter before a PMR is opened.

Supported Configurations

Installation Platform

The IBM Security Identity Server for Oracle eBS Adapter was built and tested on the following product versions.


Adapter Installation Platform: 



Note:  The adapter supports IBM Security Directory Integrator 7.2, which is available only to customers who have the correct entitlement. Contact your IBM representative to find out if you have the entitlement to download IBM Security Directory Integrator 7.2.


 Managed Resource:


IBM Security Identity Manager:

IBM Security Identity Manager v7.0

IBM Security Privileged Identity Manager (PIM):

ISPIM v2.0

ISPIM v2.1

Identity Governance and Intelligence (IGI):

IGI v5.2.1

IGI v5.2.2

IGI V5.2.3


This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY  10504-1785  U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:

IBM World Trade Asia Corporation


2-31 Roppongi 3-chome, Minato-ku

Tokyo 106-0032, Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged should contact:

IBM Corporation


11400 Burnet Road

Austin, TX 78758  U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.


The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both:

BM logo
Universal Database

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

Intel, Intel Inside (logos), MMX and Pentium are trademarks of Intel Corporation in the United States, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Linux is a trademark of Linus Torvalds in the U.S., other countries, or both.

Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

End of Release Notes