Does anybody have AFX documentation for Oracle EBS Connector? We need to provision Oracle Roles & Responsibilities through automated provisioning with Oracle system.
Thanks
Does anybody have AFX documentation for Oracle EBS Connector? We need to provision Oracle Roles & Responsibilities through automated provisioning with Oracle system.
Thanks
I can't upload the pdf here so, I just copied the document for you. It lost the markup in the process, forgive me for this.
Oracle e-Business Suite Connector Data Sheet
for RSA IMG Platform 6.8.1 or later
Connector Information
Name of the Connector: Oracle e-Business Suite Connector (Oracle Database Connector)
Endpoint application: Oracle -Business Suite
Connection Details
To successfully configure the connector, you must provide the certain configuration parameters. Make
sure that you have the following information before you proceed:
• OEBS Application URL
• Application Credentials
• Driver Class: oracle.jdbc.driver.OracleDriver
• Driver URL: jdbc: oracle: thin:/@vm-oebs.aveksa.local:1521:VIS
User Name:
• Password:
System Requirements
Oracle e-Business Suite r12.1.1 with Oracle 11g Database
RSA IMG Platform v6.8.1 or later
Command Matrix
Configure the connector with the following commands:
• Create an Account
• Delete an Account
• Enable an Account
• Disable an Account
• Reset an Account’s Password
• Update an Account
• Add Entitlement to an Account
• Remove Entitlement from an Account
• Add App Role to an Account
• Remove App Role from an Account
Oracle e-Business Suite Connector Data Sheet for RSA IMG Platform 6.8.1 or later 1
Mappings
Map the following attributes for each command:
CreateAccount
Account ${User.Name}
Password ${AccountTemplate.Password}
Owner ${AccountTemplate.Owner}
PersonPartyId ${User.UniqueId}
Description ${AccountTemplate.Description}
Email ${User.Email}
Fax ${AccountTemplate.Fax}
SQL Command CALL FND_USER_PKG.CreateUserParty(x_user_name=>${Account},
x_owner => ${Owner}, x_unencrypted_password =>
${Password},x_description => ${Description}, x_email_address =>
${Email}, x_fax =>${Fax}, x_person_party_id => ${PersonPartyId})
DeleteAccount
Account ${Account.Name}
SQL Command CALL FND_USER_PKG.DisableUser(username => ${Account})
EnableAccount
Account ${Account.Name}
SQL Command CALL FND_USER_PKG.EnableUser(username => ${Account})
DisableAccount
UserName ${Account.Name}
SQL Command CALL FND_USER_PKG.DisableUser(username => ${Account})
ResetPassword
Account ${Account.Name}
New password ${AccountPassword}
SQL Command Select FND_WEB_SEC.Change_Password(p_user => ${Account}, p_new_pwd
=> ${Password}) from dual
2 Oracle e-Business Suite Connector Data Sheet for RSA IMG Platform 6.8.1 or later
Update Account
Account ${User.Name}
Owner ${AccountTemplate.Owner}
Description ${AccountTemplate.Description}
Email ${User.Email}
Fax ${AccountTemplate.Fax}
Password ${AccountTemplate.Password}
PersonPartyId ${User.UniqueId}
SQL Command CALL FND_USER_PKG.UpdateUserParty(x_user_name=>${Account}, x_owner
=> ${Owner}, x_unencrypted_password => ${Password},x_description =>
${Description}, x_email_address => ${Email}, x_fax =>${Fax},
x_person_party_id => ${PersonPartyId})
AddEntToAccount
Account ${Account.Name}
Resource ${Entitlement.Resource}
Action $Entitlement.Action
SQL Command CALL FND_USER_PKG.AddResp(username => ${Account}, resp_app =>
${Resource}, resp_key => ${Action}, security_group => ${Securi- tyGroup},
description => ${Description}, start_date => TO_DATE(${StartDate}, 'yyyy-mmdd'), end_date => TO_DATE( ${EndDate}, 'yyyy-mm-dd'))
RemoveEntFromAccount
Account ${Account.Name}
Resource ${Entitlement.Resource}
Action $Entitlement.Action
SQL Command CALL FND_USER_PKG.DelResp(username => ${Account}, resp_app =>
${Resource}, resp_key => ${Action}, security_group => ${Securi- tyGroup})
AddAppRoleToAccount
Account ${Account.Name}
Resource ${Entitlement.Resource}
Action ${Entitlement.Action}
SQL Command CALL FND_USER_PKG.AddResp(username => ${Account}, resp_app =>
${AppRole}, resp_key => ${AppName}, security_group => ${Securi- tyGroup},
description => ${Description}, start_date => TO_DATE(${StartDate}, 'yyyy-mmdd'), end_date => TO_DATE( ${EndDate}, 'yyyy-mm-dd'))
Oracle e-Business Suite Connector Data Sheet for RSA IMG Platform 6.8.1 or later 3
RemoveAppRoleFromAccount
Account ${Account.Name}
Resource ${Entitlement.Resource}
Action ${Entitlement.Action}
SQL Command CALL FND_USER_PKG.DelResp(username => ${Account}, resp_app => ${AppRole},
resp_key => ${AppName}, security_group => ${Securi- tyGroup})
Version Supported
Oracle e-Business Suite r12.1.1 with Oracle 11g Database
Limitations
RSA IMG Platform cannot map Security Group, Description, Start Date and End Date AddEntToAccount,
RemoveEntFromAccount, AddAppRoleToAccount and RemoveAppRoleFromAccount.
Some attributes, for example email, can be provisioned and collected through the ACM, but cannot be
seen through the UI of endpoint.
The DeleteAccount operation is not supported by Oracle e-Business Suite. Instead it provides
DisableAccount operation. When RSA IMG Platform performs a DeleteAccount action, the equivalent
DisableAccount action is peformed.
The RemoveEntFromAccount and RemoveAppRoleFromAccount operations are not directly supported
by Oracle e-Business Suite. RSA IMG Platform disables the entitlements and roles assigned to users in
these operations.
4 Oracle e-Business Suite Connector Data Sheet for RSA IMG Platform 6.8.1 or later
PDF version - RSA Identity Governance and Lifecycle - Oracle E-Business Connector Datasheet