Oracle Transport and Global Trade Management (OTM/GTM) Integration Reference

Lists certified components, supported operations, configuration modes, default out-of-the-box attributes for the integration between Oracle Transport and Global Trade Management (OTM/GTM) and Oracle Access Governance.

Oracle Transport and Global Trade Management (OTM/GTM) Components Certified for Integration with Oracle Access Governance

The Oracle Transport and Global Trade Management (OTM/GTM) components that you can integrate with are listed below.

Table - Certified Components

Component Type Component
System Oracle Transport and Global Trade Management (OTM/GTM)
APIs REST APIs with OAUTH 2.0 Authorization

Supported Configuration Modes for Oracle Transport and Global Trade Management (OTM/GTM) Integrations

Oracle Access Governance integrations can be setup in different configuration modes depending on your requirement for on-boarding identity data, and provisioning accounts.

Oracle Transport and Global Trade Management (OTM/GTM) Orchestrated System supports the following mode:
  • Managed System

    You can manage Oracle Transport and Global Trade Management (OTM/GTM) accounts, roles and business intelligence roles and business intelligence applications.

Supported Operations When Provisioning To Oracle Transport and Global Trade Management (OTM/GTM)

When you provision an account from Oracle Access Governance to Oracle Transport and Global Trade Management (OTM/GTM) certain operations are supported.

The Oracle Transport and Global Trade Management (OTM/GTM) Orchestrated System supports the following account operations when provisioning a user:

  • Create Account
  • Update Account
  • Enable Account
  • Disable Account
  • Delete Account
  • Add Roles
  • Remove Roles
  • Add Business Intelligence Roles
  • Remove Business Intelligence Roles
  • Add Business Intelligence Application
  • Remove Business Intelligence Application

For more details see Oracle Access Governance Integration Functional Overview and Integrate Oracle Access Governance with Oracle Transport and Global Trade Management (OTM/GTM).

Default Supported Attributes

Oracle Access Governance supports the following default Oracle Transport and Global Trade Management (OTM/GTM) attributes.

Table - Account Attribute Mapping

Entity Oracle Transport and Global Trade Management (OTM/GTM) Account Attribute Oracle Access Governance Account Attribute Oracle Access Governance Display name
User __UID__(GL_USER_GID) uid Unique Id
  __NAME__ name User login
  GL_USER_XID userName User name
  __ENABLE__ status Status
  __PASSWORD__(PASSWORD) password Password
  USERNAME nickName Nick name
  IS_EXTERNAL isExternal External user
  UNSUCCESSFUL_LOGIN_ATTEMPTS unsuccessfulLoginAttempts Unsuccessful login attempts
  LAST_LOGIN_DATE lastLoginDate Last login date
  LAST_NAME lastName Last name
  FIRST_NAME firstName First name
  EMAIL_ADDRESS email Email
  IS_OBIEE obieeNonSSOUser OBIEE non sso user
  EFFECTIVE_DATE startDate Start date
  EXPIRATION_DATE endDate End date
  DOMAIN_NAME domainName Domain name
  GL_ACCOUNT_POLICY_GID accountPolicy Account policy
  AUTO_APPROVE_RULE_PROFILE_GID approveRuleProfile Approval rule profile
  DOCUMENT_USE_PROFILE_GID documentUseProfile Document use profile
  PW_EXPIRATION_DATE passwordExpirationDate Password expiration date
  ACCOUNT_LOCKOUT_TIME accountLockoutTime Account lockout time
Business Intelligence Role BI_ROLE_GID businessIntelligenceRoleId Business intelligence role id
Business Intelligence Application GL_USER_BI_APP businessIntelligenceApplication Business intelligence application
Role DEFAULT_USER_ROLE_GID roles Roles

Default Matching Rules

In order to map accounts to identities in Oracle Access Governance you need to have a matching rule for each orchestrated system.

The default matching rule for the Oracle Transport and Global Trade Management (OTM/GTM) orchestrated system is as follows:

Table - Default Matching Rules

Mode Default Matching Rule
Managed System

Account matching checks if incoming accounts match with existing identities.

Screen value:

User name = Employee user name

Supported Special Characters

For successful provisioning and data load, adhere to the list of special characters for the default attributes

Special Characters for UserName (GL_USER_XID)

  • Supported Special Characters: (@ . {} [] () : * ! ^ ~ ` | \ )
  • Unsupported Special Characters: ( - $ # ; & ? / , < > )

Special Characters for Other Default Attributes

Unsupported Special Characters: (& <)

For additional details, refer Basic Data Entry in OTM/GTM.

Limitations

The following limitations exist by design while working with orchestrated system.

  • You cannot assign Administration roles using the USER-ADMINISTRATION role from Oracle Access Governance. To do so, assign DBA.ADMIN.
  • If you assign DBA.ADMIN role to the service account, you cannot provision Business Intelligence Role and Application Reconciliation roles.