Sunday 15 July 2012

Creating a new DataResultSet from an Existing DataResultSet

Most of us would have come across the scenario in which you need to create new DataResultSet object with the same fields as that of an existing DataTesultSet.

Following is the steps to create a DataResultSet from an existing DataResultSet without creating fields one by one.

1) Create a DataResultSet Object
 DataResultSet finalResultSet = new DataResultSet();   

2) Merge the fields from the source DataResultSet object
  finalResultSet.mergeFields(coverPageResult);

3) Add an empty row
  finalResultSet.createEmptyRow();

4) Get the field values from the source
                for(int x=0;x<rowList.size();x++) 
{
                    selectedList = new Vector();                   
         selectedList = coverPageResult.getRowValues(Integer.parseInt(rowList.get(x).toString()));
                    finalResultSet.addRow(selectedList)
       }

           Note : This step is to copy a subset of rows from the source dataresultset object to target. Based on your requirements, this step may vary.  Also creating a Vector/List object to add the values into the row is easier than adding values one by one especially if you want to copy them from one dataresultset object to another.
 

Monday 11 June 2012

Oracle Webcenter Content PS5 | Oracle WebCenter Content Search Engine Plug-in for Web Browsers

Oracle WebCenter Content: Desktop 11g Release 1 (11.1.1.6) provides search engine plug-ins for Internet Explorer, Mozilla Firefox, and Google Chrome, which allow you to perform quick searches on an Oracle WebCenter Content Server instance directly from the web browser search bar without having to go through the content server's web interface.

Oracle WebCenter Content: Desktop 11gR1 provides plug-ins for various popular web browsers which enable you to search for content on an Oracle WebCenter Content Server instance directly from the search field in your web browser. 
The following web browsers are supported:
  • Microsoft Internet Explorer 7.0 or higher
  • Mozilla Firefox 3.5 or higher
  • Google Chrome 10 or higher
Please note the following:
  • The Oracle WebCenter Content Server browser plug-in is available only if this feature has been enabled on the content server (on the DesktopIntegrationSuite component configuration page).
  • The default search provider name for an Oracle WebCenter Content Server instance is 'Oracle WebCenter Content Search', but this can be changed by the content server administrator. Contact your Content Server system administrator if you are not sure what the search provider name for an Oracle WebCenter Content Server instance is.
  • A content server search provider in your web browser is for a specific Oracle WebCenter Content Server instance only. You cannot search multiple content servers using a single search provider.
  • You cannot add two search providers for the same Oracle WebCenter Content Server instance. Once you have added a search provider, it will not be added again for the same Content Server instance.
  • The search results are displayed in the web browser, in the Oracle WebCenter Content Server web interface.
  • If you are currently logged in to the content server (that is, there is a login cookie for the server on your computer), you will see all content items that meet the search criteria and for which you have access privileges on the server. If you are not logged in, then you will see only public content.
  • The search performed in your web browser mimics the Quick Search feature in the Oracle Content Server web interface

 Adding Search Plugin to the Browsers


To Add the Search Engine Plugin for Web Browsers follow the steps mentioned below

1) Install Desktop Integration Suite 
2) Enable 'Web browser search plug-in from Desktop Integration Suite configuration page as given below
Configuration Page for 'Desktop Integration Suite' Component (Administration -->Configuration For <instance>-->Enabled Components-->Desktop Integration Suite-->Configure)





3) Log in to the Oracle WebCenter Content Server instance you want to add the search provider for ( open Oracle webcenter content in the browser to which you want to add the plug-in)
4) Open the My Content Server tray or menu.
5) Click My Downloads.
  The My Downloads for USER page opens.
6) Click Add browser search in either of the Desktop client table entries
7) The Add Search Provider dialog opens
8) Optionally, select the 'Make this my default search provider' check box.
9) Click Add to make the search provider available in the web browser
10) On Web browser, the search plug-in appears as given below 


Removing the Oracle WebCenter Content Search Engine

To remove the Oracle WebCenter Content search engine from Firefox:
  1. Open the browser
  2. Click the arrow in the browser search bar to open the search engine list.
  3. Click Manage Search Engines....
  4. Select the search engine for the Oracle WebCenter Content Server instance and click Remove.
  5. Click OK.
For More information : http://docs.oracle.com/cd/E23943_01/doc.1111/e10624/web_browsers.htm#BCFFJAHC
 

Tuesday 17 April 2012

Configuration of AXF solutions for Managed Attachment from UCM & IPM

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

  1.      Setup IPM as managed server in ECM
  2.     Configure a UCM connection from IPM for the content repository
  3.      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', 'RIDC_CONNECTION_STR', 'idc://<hostname>:4444');

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');

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_ADMIN_USER', 'sysadmin');

 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

Monday 16 April 2012

Integrating Microsoft's Active Directory with Oracle Webcenter Cotnent -11g


In a production system, Oracle Enterprise Content Management Suite applications need to use an external Lightweight Directory Application Protocol (LDAP) authentication provider. You need to reassociate the identity store for your application with one of the following external LDAP authentication providers before you complete the configuration of a Managed Server, before you connect a Managed Server to a repository, and before the first user logs in to the application:

Unlike the previous versions, LDAP provider needs to be configured in Weblogic server NOT IN  UCM.

Steps to integrate microsoft's active directory is as follows ( i have used security group based security model to create this example)

1) Login to weblogic console of the domain and navigate to 'Domain Structure' as given below



                                    2) On click of 'Security Realms, following page appears


                                    3)  Click on 'myrealm'  and the following page appears



Click on 'Providers' link as marked above

                                    4) Providers page appears
                                  


                                     Select 'New' to create a new providers
                                    5) Screen to enter ther 'Name' and 'Type' for the new provider appears
                                        

                                      For active directory the type should be : ActiveDirectoryAuthenticator

LDAP Authentication Provider                   Authenticator Type
                                         Microsoft AD                                       ActiveDirectoryAuthenticator


                                           Click 'Ok'
                                                   
                                         6)  Settings for 'my realm' appears as given below.  
                                          The newly created  provider   should be the first on in the list. To do that, we need to
                                            reorder the listing of providers using ‘Reorder’.
Reorder page appears as given below

Using the arrow buttons, move the newly created provider to the top of the list and click 'Ok'
On clicking 'Ok' , providers list will be updated as given below
 
                                       
     7)   Click on the newly created provider name and ‘Settings for <newly created provider> page gets displayed . 
  
                                      Select 'Control Flag' as 'Sufficient' for the newly created provider and click 'Save'.

 
8)    After changing the control flag and saving the settings click on ‘Provider Specific’ tab in the same page.
                                      ‘Settings’ page for the new provider  gets displayed as given below


9)    To connect the specific provider, we need to provide the details
  Set Provider Specific values in the following fields, and leave default values in the other fields:
Set connection Details
  • Host: The host name or IP address of the LDAP server.
  •  Port: The Oracle Internet Directory Port, 389 by default.
  • Principal: The Distinguished Name (DN) of the LDAP user that Oracle WebLogic Server should use to connect to the LDAP server; for example:
  •  cn=orcladmin
  • Credential: The credential used to connect to the LDAP server (usually a password).
  •  Confirm Credential: The same value as for the Credential field.


 
User Details
  • User Base DN: The base distinguished name (DN) of the tree in the LDAP directory that contains users; for example:
  •  cn=users,dc=example,dc=co      
  •  Note: Use an exact DN rather than a top-level DN. Using a top-level DN would provide access to all the default users and groups under the DN, giving access to more users than required by the application.
        •  Use Retrieved User Name as Principal: Specifies whether or not the user   name retrieved from the LDAP server should be used as the Principal value.
Group Details
        •   Group Base DN: The base distinguished name (DN) of the tree in the LDAP directory that contains groups; for example:
                           cn=groups,dc=example,dc=com




                                 After specifying connection, users and groups details. click on 'save' to save all the details.
                          10) Go back to the list of providers screen ( my realm page) and click on the default provider as give below
‘Settings’ page for the default provider opens as given below
Change the control flag for the ‘default provider’ to ‘Sufficient’ and click ‘Save’



11)    Restart the admin server using windows service
12)    Relogin to admin server
13)    Navigate to ‘my realm’ page as given below and click on ‘Users and Groups’ tab
 

14)    Users and Groups gets displayed as given below
Groups 

                          Verify whether the user names/groups  listed above are coming from the newly  configured provider by checking the ‘Provider’ column for each user as given in the screen shot. 


15) The next step is to map the groups from AD to UCM/Oracle Webcenter Groups
                           For that we need to create 'Roles' in Oracle Webcenter Content , with the same name as that of Groups



As given the screen shot above, we need to create Roles and assign rights to them. 
16) The next steps is to map the groups to these roles using credential mapping

For that we need to create a credential mapping as given below


                         Once the credential mapping is added as given above, an entry for the mapping should be added into the providers
                       For that  navigate to the provider.hda file for jps provider located at <domain_name>/ucm/cs/data/providers/jpsprovider

There in add the following variable:

ProviderCredentialsMap=<map name created above>

Save the file and restart UCM server .
17) Once the servers are restarted, login to Oracle Webcenter Content with the AD users and verify the access rights.



For more info : http://docs.oracle.com/cd/E12839_01/webcenter.1111/e12405/wcadm_security.htm#BGBHHGEH