Oracle Content Manager Profile Options and Lookups

This appendix covers the following topics:

Finding Responsibility ID Values

Before you set the required Oracle CRM Technology Foundation (JTT) profile options, you must know the values for APPLICATION_ID and RESPONSIBILITY_ID for Oracle iContent and IBC Super User responsibilities. To know the values log into Oracle Applications with the System Administrator responsibility.

Note: The APPLICATION_ID value for Oracle iContent is 549 (for Oracle iContent) and the RESPONSIBILITY_ID value for IBC Super User is 23812.

Oracle CRM Technology Foundation (JTT) Profile Options

This section summarizes the Oracle CRM Technology Foundation (JTT) profile options that you must set to implementing Oracle Content Manager.

Set the profile options in this section at the Site and Application levels.

Note: Choose Oracle iContent as the application.

The Table: JTT Profile Options for the Oracle Content Manager UI lists the JTT profile options for the Oracle Content Manager UI.

JTT Profile Options for the Oracle Content Manager UI
Profile Option Name Value Description
JTF_PROFILE_DEFAULT_APPLICATION 549 Default application ID (549=Oracle iContent).
JTF_PROFILE_DEFAULT_CSS jtfucss.css Default Oracle CRM Technology Foundation Cascading stylesheet.
JTF_PROFILE_DEFAULT_CURRENCY USD Default currency. Enter the currency code in all uppercase letters.
JTF_PROFILE_DEFAULT_RESPONSIBILITY (application level only) 23812 Default responsibility ID (23812=IBC Super User).

FND Profile Option

The FND: Framework Compatibility Mode profile should be set to 12.0 at the application level "Oracle iContent".

Oracle Content Manager Profile Options

Table Profile Categories for Oracle Content Manager shows the categories for the profile options in Oracle Content Manager.

Profile Categories for Oracle Content Manager
Profile Category Functional Name Profiles
Debug IBC: Debug Output Directory
Debug IBC: Debug Type
Debug IBC: Enable Debug
Interaction IBC: Content Type Group
Interaction IBC: Customize Approval Workflow
Interaction IBC: Default Home Folder
Interaction IBC: Display Base Language
Management and Delivery IBC: Enable Audit Log
Management and Delivery IBC: Enforce Available Date
Management and Delivery IBC: Enforce Expiration Date
Management and Delivery IBC: Num for Copy Optimization 
Security IBC: Enable Encryption
Security IBC: Encryption/Decryption Key
Security IBC: Use Access Control

The Table: Oracle Content Manager Profile Options, provides the profile options used by Oracle Content Manager.

Oracle Content Manager Profile Options
Profile Name Description
IBC: Content Type Group Use this profile to enable users to view only those content types to which they are mapped, in the Content Type Groups.
IBC: Customize Approval Work flow Use this profile to customize the approval workflow. By default, the value is set to No. This means that if the content creator also has approval privileges on the folder, then no workflow is launched. But if you have customized the workflow and to launch it, then you must set the value to Yes.
IBC: Debug Output Directory Use this profile to set the directory where the debug log files must be created. To find the location, SELECT * from v$parameter where name like 'utl_file_dir'.
IBC: Default Home Folder Use this profile to set the Default Home folder for the user.
IBC: Debug Type Use this profile to set the Content Manager Debug Type.
IBC: Display Base Lang Use this profile to check whether to display the base language content item version, if the version status is not approved.
IBC: Enable Audit Log Use this profile to enable Audit Log for Content Manager Application
IBC: Enable Debug Use this profile to enable debug for Oracle Content Manager Application.
IBC: Enable Encryption OCM Runtime provides URL access to content item attachments and content items themselves with the capability of encrypting sensitive parameters in the OCM generated URLs.
Set this profile value to Y to turn on the encryption.
IBC: Encryption/Decryption Key Use this profile to set the encryption/decryption key for Oracle Content Manager.
IBC: Enforce Available Date Each content item created in OCM can be set to have an Available Date. If the profile value is set to Yes, then this feature is turned on.
IBC: Enforce Expiration Date Each content item created in OCM can be set to have an Expiration Date. If the profile value it set to Yes, then this feature is turned on.
IBC: Num for Copy Optimization Use this profile in a Copy Folder operation to set when the operation is performed in real time versus by a concurrent program. The profile sets the value of x in the following cases. In the case when a folder has no folders within it, that is, a single-level folder, and contains x or fewer content items, then the request is done in real time. In the case when the folder contains subfolders or more than x content items, then the request uses a concurrent program. This profile has a default value of 5.
IBC: Use Access Control Use this profile to set the access control for OCM.
If set to Yes, security is enabled. Security verification is made on the users access control.
If set to No, security is disabled. No check is made on the users action.
Upload File Size Limit Use this profile to specify the maximum size of a file that a user can upload.
This profile is not specific to OCM but instead belongs to the Oracle Applications Framework.

Oracle Content Manager Lookups

Lookups appear as drop-down values in the user interface. There are three types of lookups:

The Table: Oracle Content Manager Lookup Settings lists the OCM Lookup settings.

Oracle Content Manager Lookup Settings
Lookup Type Lookup Values
IBC_ATTRIBUTE_DATA_TYPE attachment
boolean
component
dateTime
decimal
html
string
url
IBC_CITEM_PERMISSIONS CITEM_READ
CITEM_APPROVE
CITEM_TRANSLATE
CITEM_DELETE
CITEM_ARCHIVE
CITEM_EDIT
CITEM_APPROVE_TRANSLATE
IBC_CITEM_STATUS APPROVED
ARCHIVED
PENDING
ARCHIVED-CASCADE
IBC_CITEM_VERSION_STATUS APPROVED
ARCHIVED
INPROGRESS
REJECTED
SUBMITTED
IBC_CTYPE_STATUS ACTIVE
INACTIVE
IBC_DIRECTORY_PERMISSIONS DIR_CITEM_ADD
DIR_CREATE
DIR_EDIT
IBC_IMAGE_TYPES GIF
JPEG
JPG
PNG
IBC_CL_ATTRIBUTE_CODES IBC_CONTENT_BLOCK
IBC_IMAGE
IBC_ACTIONS_LIST COPY
CREATE_NEW_VER
LATEST_VER
LOCK_ITEM
PREVIEW_ITEM
REMOVE
UNLOCK_ITEM
UPD_ANOTHER_VER
UPD_TRANSLATIONS
IBC_ADV_SEARCH IS
IS_NOT
CONTAINS
IBC_AUDIT_ACTIVITIES MOVE
UPDATE
ARCHIVE
REMOVE
REJECT
COPY
CREATE
APPROVE
CREATE_NODE
UPDATE_NODE
UPDATE_NODE_SECURITY
IBC_AUDIT_OBJECTS ASSOC
ABUNDLE
COMP
CITEM
LABEL
CIVERSION
CTYPE
DIRNODE
IBC_CATEGORIES_BROWSE ALL_CATEGORIES
CURRENT_CATEGORY
IBC_CATEGORY_PERMISSIONS PD_EDIT
PD_PUBLISH
PD_VIEW
IBC_CITEM_ACTIONS_LIST COPY
CREATE_NEW_VER
LATEST_VER
LOCK_ITEM
PREVIEW_ITEM
REMOVE
UNLOCK_ITEM
UPD_ANOTHER_VER
UPD_TRANSLATIONS
IBC_CITEM_ACTION_LIST IBC_CITEM_VIEW_ASSOCIATIONS
IBC_CITEM_VIEW_HISTORY
IBC_CITEM_VIEW_USAGE
IBC_CITEM_VIEW_VERSIONS
IBC_CITEM_CONTAINS ANYWHERE
DESCRIPTION
CONTENT_ITEM
IBC_CITEM_SEARCH_COLUMN CONTENT_ITEM_NAME
DESCRIPTION
IBC_CL_CHANNELS IBC_EMAIL_CTG
IBC_FAX_CTG
IBC_PRINT_CTG
ALL
IBC_CONTENTITEMS_ACTIONS_LIST CREATE_NEW_VER
LOCK_ITEM
LATEST_VER
UPD_TRANSLATIONS
UNLOCK_ITEM
COPY
MOVE
UPD_ANOTHER_VER
PREVIEW_ITEM
REMOVE
IBC_COPY_ERROR_ACTIONS CREATE_NEW
IBC_CTG_SEEDED_STATUS YES
NO
IBC_CTG_STATUS ACTIVE
AB
INACTIVE
IBC_CTYPE_SUMMARY_STATUS ACTIVE
ALL
INACTIVE
SEEDED
IBC_DEBUG_TYPES PIPE
FILE
IBC_DIRECTORY_NODE_STATUS ACTIVE
ARCHIVED
INACTIVE
IBC_FOLDER_ACTIONS_LIST COPY
MOVE
REMOVE
IBC_GRANTEE_TYPES GROUP
USER
GLOBAL
RESPONSIBILITY
IBC_INHERITANCE_STATUS INHERIT
OVERRIDE
IBC_NODE_TYPES WDIR
PDIR
IBC_OBJECT_PERMISSIONS CITEM_APPROVE
CITEM_APPROVE_TRANSLATE
CITEM_ARCHIVE
CITEM_READ
CITEM_DELETE
CITEM_EDIT
CITEM_TRANSLATE
DIR_CITEM_ADD
DIR_CREATE
DIR_EDIT
PD_EDIT
PD_VIEW
PD_PUBLISH
IBC_PA_FILTER ALL
CONTENT_APPROVAL
TRANSLATION_APPROVAL
IBC_PA_NOTIFICATIONS IBC_CITEM_APPROVE_NOTIFICATION
IBC_CITEM_TRANS_APPROVE_NOTIFY
IBC_READONLY_PAGES ITEM_HISTORY
ITEM_USAGE
VIEW_VERSIONS
IBC_RENDITIONS APPLICATION/MSEXCEL
APPLICATION/VND.MS-EXCEL
APPLICATION/X-JAVASCRIPT
APPLICATION/X-MSEXCEL
AUDIO/MPEG
APPLICATION/POSTSCRIPT
APPLICATION/VND.MS-POWERPOINT
APPLICATION/X-TAR
APPLICATION/VND.MSWORD
APPLICATION/X-ZIP-COMPRESSED
APPLICATION/MSWORD
APPLICATION/RTF
APPLICATION/PPT
APPLICATION/PDF
AUDIO/MIDI
VIDEO/X-MSVIDEO
VIDEO/X-AVI
IMAGE/GIF
TEXT/RICHTEXT
AUDIO/X-REALAUDIO
AUDIO/X-PN-REALAUDIO-PLUGIN
AUDIO/X-PN-REALAUDIO
TEXT/RTF
IMAGE/PJPEG
IBC_SRCH AFTER
BEFORE
Y
IBC_USER_GROUPS GROUP
USER
IBC_VERSIONS_CTG LATEST_VERSION
LIVE_VERSION
IBC_VIEW_OPTIONS HIDE_FOLDERS
SHOW_ALL
IBC_YES_NO N
Y
IBC_ZIP_TYPES ZIPU
ZIPL
IBC_RENDITIONS VIDEO/QUICKTIME
TEXT/PLAIN
VIDEO/X-SGI-MOVIE
VIDEO/MPEG
TEXT/XML
AUDIO/X-WAV
UNKNOWN_MIME_TYPE
TEXT/SGML
IMAGE/JPEG
TEXT/HTML
IMAGE/BMP
IMAGE/X-MS-BMP
IMAGE/X-BMP
TEXT/CSS