System Preferences

The following table describes Oracle Data Relationship Management system preferences.

Table 14-1 System Preferences

System Preference Type Description

AllowAsOf

Boolean

True forces capture of core actions and creates a baseline version to allow the creation of As-Of versions. If this preference is set to False, As-Of versions cannot be created.

Default value is True.

Note: A change to this preference requires a restart of the Data Relationship Management application.

AllowNextIDGeneration

Boolean

True enables automatic Next ID generation.

Default value is False.

AllowNextIDKeyCreation

Role

List of roles allowed to create a new key in NextID feature.

Default values are Interactive User, Data Creator, Data Manager.

AllowPru

Boolean

True enables the pruning option which allows a non-admin user to remove a node that has children. If False, a non-admin user cannot remove a node that has children.

Default value is True.

AllowRelaxedMove

Boolean

When a node is moved, True allows the new parent to take precedence over any conflicting parental relationships for the node in other hierarchies.

Default value is False.

AllwSpac

Boolean

True allows spaces in node names.

Default is True.

AnalyticsNodeCountUpdateTime

String

Specifies a time of day, in local time using 24-hour format, when the node counts for versions and hierarchies for all loaded, normal versions are to be updated. For example, 2:15 PM would be entered as "1415". The default time is 3:00 AM.

ApprovalGroups

String

Comma-delimited list of approval groups.

ApprovalGroupTrackProperties

String

Delimited list of approval properties tracked by groups.

ApprovalPropertyByApprovalGroup

String

Global boolean approval property by approval group.

AuthMethod

String

User authentication method:

  • Internal––Users are only authenticated within Data Relationship Management.

  • CSS (External)––Users are only authenticated externally. Requires access to Shared Services.

  • Mixed––Users are authenticated internally or externally based on a setting for each individual user.

Default value is Internal.

Note: A change to this preference requires a restart of the Data Relationship Management application.

CopyLcl

Boolean

True copies local values when a node is copied.

Default value is True.

DefaultCurrentVersion

Version

Default current version. This preference can be set using the Make Default option for versions.

DefaultPreviousVersion

Version

Default previous version. This preference can be set using the Make Default option for versions.

DefaultPropCopyMode

String

Default property copy mode.

Valid values are Overridden, Selected, and ForceAll.

Default value is Overridden.

EnablePropCopyOptions

Role

List of roles allowed access to the property copy options.

Default values are Interactive User, Data Creator, Data Manager.

EnforceListProps

Boolean

True allows updates to a List Property with values from the pre-defined list only.

Default value is True.

FiltrChr

String

Set of characters for the Replace function on the Output Option screen of exports.

FindByProperties

Property

List of properties available to search with when browsing a hierarchy.

The properties displayed are those to which a user has access. Also, the properties displayed may not be applicable to all hierarchies.

Note: The ADMIN user cannot be added to custom Property Categories in Data Relationship Management. As a consequence, if a property listed in the FindByProperties system preference is not added to a Property Category that ADMIN is already a member of, then ADMIN will not be able to perform a Find with that property in the Hierarchy Browse window.

FindWildCardAppend

Boolean

True appends an asterisk (*) to the Find criteria when Exact Match is not selected.

Default value is False.

FindWildCardPrepend

Boolean

True prepends an asterisk (*) to the Find criteria when Exact Match is not selected.

Default value is False.

GlobalPropLocalOverride

Property

List of properties to exclude from local checks on global properties. These are used when GlobalPropLocalSecurity is enabled.

Note: A change to this preference requires a restart of the Data Relationship Management application.

GlobalPropLocalSecurity

Boolean

True enforces local security on global properties. Changes to global properties are checked against local security (node access levels) for the user for all hierarchies where the node exists.

Default value is False.

Note: A change to this preference requires a restart of the Data Relationship Management application.

HierSep

String

Hierarchy and node separator character.

Default value is tilde ( ~ ).

IdleTime

Integer

Number of minutes to session time out on the application server.

Default value is 60.

Note: A change to this preference requires a restart of the Data Relationship Management application.

Inactivate

Role

List of user roles allowed to inactivate nodes.

Default value is all roles.

InactiveChanges

Role

List of roles allowed to change inactive nodes.

Default values are Data Manager, Application Administrator, Access Manager.

InvDescr

String

List of invalid characters for node description property.

InvName

String

List of invalid characters for node name.

Note: Characters in this list cannot be used as the delimiter with shared nodes.

JobResultsMaxSize

Integer

For jobs that are run using the Client File option, maximum size (in bytes) of results saved to the Job History. Job results exceeding this size are not saved to the Job History. The default value is 10,000,000 bytes. A negative value indicates that all results, regardless of size, are saved to the Job History.

Caution: Disabling JobResultsMaxSize by setting to a negative value is strongly discouraged because this can significantly impact performance for large jobs.

Note: JobResultsMaxSize does not apply to Exports run using the Server File or Database Table options.

JobResultsRetentionAge

Integer

Number of days to retain archived job result detail in history. A value of zero indicates that job results are never purged from history.

Note: Job results are purged to manage database size. Disabling the purge may result in significant database growth over time.

LeafEdit

Role

List of roles allowed to change the Leaf property.

Default values are Data Manager, Data Creator, Application Administrator, Access Manager.

LockoutInactivity

Integer

Maximum number of days of inactivity before a user is locked out.

Default value is 30; zero indicates no maximum.

LockoutInvalidLogins

Integer

Maximum number of invalid logins before a user is locked out.

Default value is 6; zero indicates no maximum.

LossLevel

String

Loss level to capture.

Valid values are:

  • Defined

  • All

Default value is Defined. Selecting All can significantly impact system performance for removed or deleted nodes with many property values.

Note: A change to this preference requires a restart of the Data Relationship Management application.

LRUPropertyCacheSize

Integer

Maximum size for the LRU property cache. The LRU Property cache stores calculated values that may be accessed multiple times. Generally, the default for this preference should be used and should not be changed.

MaxDescr

Integer

Maximum number of characters for node description. Valid values are 12 to 255.

Default value is 80.

MaxLeaf

Integer

Maximum number of characters for the leaf name. Valid values are 3 to 20.

Default value is 255.

MaxLimb

Integer

Maximum number of characters for the limb name. Valid values are 3 to 20.

Default value is 255.

NodeApprovedSecurity

Role

List of roles allowed to view and update. the NodeApproved system property for nodes

PasswordDuration

Integer

Number of days that a user password is valid. Valid values are 1 to 9999.

Default value is 30.

PasswordMaxLength

Integer

Maximum number of characters for user password. Valid values are 0 to 255. Zero indicates no minimum.

Default value is zero.

PasswordMinLength

Integer

Minimum number of characters for user password. Valid values are 0 to 9999. Zero indicates no minimum.

Default value is 6.

PasswordPolicyEnabled

Boolean

True requires the password to contain three of the following elements:

  • Uppercase letters

  • Lowercase letters

  • Numbers

  • Special characters

Default value is True.

PasswordWarningPeriod

Integer

Positive or negative number to indicate how many days before (-) or after (+) the password expiration date to warn users to change their password before no longer allowing them to log in. Valid values are -30 to 30.

Default value is 1.

RenameLeaf

Role

List of roles allowed to rename leaf nodes.

Default values are Data Manager, Application Administrator, Access Manager.

RenameLimb

Role

List of roles allowed to rename limb nodes.

Default value is all roles.

ReqMerge

Boolean

True requires merge for inactivates or deletes when UseMerge is enabled.

Default value is False.

SharedNodeDelimiter

String

Specifies the delimiter between the node name and the shared node suffix.

The SharedNodeDelimiter character should not be used anywhere that would affect node names.

Default value is colon (:).

Caution: Different characters must be used when setting up the SharedNodeDelimiter and SharedNodeSequenceSeparator system preferences. For example, if the SharedNodeDelimiter is a colon, the SharedNodeSequenceSeparator character cannot be a colon.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeIdentifier

String

Specifies the identifier to be used after the shared node delimiter.

Default value is Shared.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeMaintenanceEnabled

Boolean

True enables shared nodes.

Default value is False.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeNamingType

String

Specifies the alternate name for shared nodes. Valid values are: Suffix or Prefix.

Default is Suffix

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeSequenceLength

Integer

Specifies the length of the uniqueness key when using numeric sequence type.

Default value is 3.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeSequenceSeparator

String

Specifies the separator character to be placed after the shared node identifier.

Default value is dash (-).

Caution: Different characters must be used when setting up the SharedNodeDelimiter and SharedNodeSequenceSeparator system preferences. For example, if the SharedNodeDelimiter is a colon, the SharedNodeSequenceSeparator character cannot be a colon.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SharedNodeSequenceType

String

Specifies the type of uniqueness key. Valid values are Numeric or Ancestors.

Default is Numeric.

Note: A change to this preference requires a restart of the Data Relationship Management application.

SortLimbsFirst

Boolean

True controls the sorting of limb nodes first followed by leaf nodes. If False, limb and leaf nodes can be sorted together. This preference affects hierarchy exports, display, and node lists.

Default value is True.

TopNodeParentString

String

Used in Import and Export to denote parent value for a top node.

Default value is None.

TransactionLevels

String

List of transaction levels to capture. Turning on As-Of or specifying result or loss actions forces core actions to be captured.

Valid values are:

  • Logged Action

  • Core Action

  • Result Action

  • Loss Action

Note: Transactions at the Admin level are always logged regardless of this system preference.

Default values are Logged Action, Core Action, Result Action, Loss Action.

Note: A change to this preference requires a restart of the Data Relationship Management application.

UpName

Boolean

True uses uppercase always for the node name

Default value is False

UseChangeApproval

Boolean

True enables change approval.

Default value is False.

UseMerge

Boolean

True enables use of Merge methodology for inactivated and deleted nodes.

Note: If ReqMerge is True, then the system requires a merge node to be specified. If ReqMerge is False, then a merge node is optional unless the node approved property is True. The node approved property is set to True when a version is finalized or when it is specifically set to True by a user with appropriate access.

Default value is False.

ValSec

Boolean

True checks node access group security to determine whether a user can run batch validations for a node.

Default value is False.

WarnHL

Integer

Maximum number of nodes to be displayed for lists such as Descendants, Children, Query Results, and so on. Minimum value is 1000. If set to a value less than 1000, then 1000 nodes are displayed.

Default value is 5000.

For more information, see: