Oracle Webcenter Content - My Logs: Integrating peoplesoft's managed attachments with UCM

Following are the steps to be followed to configure Managed Attachments from Oracle Webcenter Content for peoplesoft

Please note : these steps are to cover the configurations required from UCM and IPM only.

And these steps are used for Oracle Webcenter Content and IPM 11.1.1.5.0

Overview

For configuring managed attachment to work for people soft with UCM,it requires an AXF solution.

And AXF solution comes with IPM (AXF tables are a part of IPM data base schema).

Following are the steps followed to setup the AXF solution adapter for people soft from ECM

Setup IPM as managed server in ECM
Configure a UCM connection from IPM for the content repository
Enable IpmRespository, AppAdapterCore , AppAdapterPSFT and Content Folios in UCM

Please Note : for PS4, AppAdapterCore and AppAdapterPSFT components have bugs. A patch for these two components are available in support.oracle.com ( patch number : Patch 12878079: EBS/PSFT Adapter for ECM Managed Attachments 11.1.1.4.0 Patch (build 3) ). Though it says for PS3, it is applicable for PS4 ( 11.1.1.5.0) as well.

So if we are setting it for the first time, these two components need to be downloaded from the support and follow the steps given in the readme.txt for the same to apply it

Else disable the components, and install and enable the patched components by following the steps given in readme.txt file

4. Run the following installation scripts in IPM Schema

(Scripts are located in MW_HOME/ECM_HOME/axf/adapters/psft/)

INSERT INTO AXF_SOLUTIONS (SOLUTION_NAMESPACE, SOLUTION_CONTEXT) VALUES ('UCM_Managed_Attachments', 'ejb.AxfCommandMediator#oracle.imaging.axf.service.AxfCommandMediatorRemote');

INSERT INTO AXF_COMMANDS (SOLUTION_NAMESPACE, COMMAND_CLASS, COMMAND_NAMESPACE) VALUES ('UCM_Managed_Attachments', 'oracle.imaging.axf.commands.ucm.AfGrantAccessCommand', 'UCM_Managed_Attachments');

INSERT INTO AXF_SOLUTION_PARAMETERS (SOLUTION_NAMESPACE, COMMAND_NAMESPACE, CONFIGURATION_NAMESPACE, PARAMETER_KEY, PARAMETER_VALUE) VALUES ('UCM_Managed_Attachments', 'UCM_Managed_Attachments', 'oracle.imaging.axf.commands.ucm.AfGrantAccessCommand', 'UCM_CONNECTION_STR', 'http://<hostname>/cs/idcplg/_p/min/af/trigger-[ContentServerProfile]?IdcService=GET_SEARCH_RESULTS_FORCELOGIN&ResultCount=5&ResultTemplate=[ResultTemplate]&SearchEngineName=DATABASE.METADATA.AFLIST');

5. Verifying Required Oracle UCM Components and Configuration

Follow these steps to verify that required Oracle UCM components are enabled on the Content Server.

1. Log in to Content Server as an administrator.

2. Click the Configuration for [Instance] link in the content server Administration tray.

3. In the Features And Components section, click Enabled Component Details.

4. From the details shown, verify that the following components are enabled. If a component is not listed, install and enable it according to its installation documentation.

The following components must be at or above the version level included with Oracle UCM 11gR1 release 11.1.1.4:

o YahooUserInterfaceLibrary

o CheckoutAndOpenInNative

o CoreWebdav

o NativeOsUtils

o ContentFolios

5. In the User Admin applet, ensure that the roles below have the correct access level to the corresponding security groups.

6. In Content Server, select the Administration option from the main menu, choose Admin Applets, then User Admin. Select Security, then Permissions by Role.

o AFAdmin: AFDocuments (RWDA) and no permissions on any other groups

o AFDelete: AFDocuments (RWD) and no permissions on any other groups

o AFWrite: AFDocuments (RW) and no permissions on any other groups

o AFRead: AFDocuments (R) and no permissions on any other groups

Oracle Webcenter Content - My Logs

Tuesday, 17 April 2012

Configuration of AXF solutions for Managed Attachment from UCM & IPM