Create OID User using java SDK

in this article i gonna show java code sample that explain how to create user in OID grammatically .
before taking the code you have to do the following two steps :

1. Create custom project 
2. add reference for the following jar ldapjclnt11

now Create Class and copy the following code :

import oracle.ldap.util.*;

import oracle.ldap.util.jndi.*;

import javax.naming.NamingException;

import javax.naming.directory.*;

import java.io.*;

import java.util.*;

public class OIDConnect {

    public OIDConnect() {

        super();

    }

    

    final static String ldapServerName = "xx.xx.xx.xx";

    final static String ldapServerPort = "3060";

    final static String rootdn = "cn=orcladmin";

    final static String rootpass = "password";

    public static void main(String[] args) throws NamingException {

       

       

        // Create the connection to the ldap server

        InitialDirContext ctx = ConnectionUtil.getDefaultDirCtx(ldapServerName, ldapServerPort, rootdn, rootpass);

        // Create the subscriber object using the default subscriber

        Subscriber mysub = null;

        String[] mystr = null;

       

        try 

            {

                RootOracleContext roc = new RootOracleContext(ctx);

                mysub = roc.getSubscriber(ctx, Util.IDTYPE_DN, "dc=xx,dc=xx,dc=xx", mystr);

                              

            

              

            } 

        catch (UtilException e) {

            e.printStackTrace();

        }

        // Create ModPropertySet 

        ModPropertySet mps = new ModPropertySet();

        

        

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "cn", "John");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "sn", "John");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "objectclass", "person");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "objectclass", "organizationalPerson");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "objectclass", "inetOrgPerson");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "objectclass", "orclUser");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "objectclass", "orclUserv2");

        

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "givenname", "John");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "userPassword", "xxx");

        mps.addProperty(LDIF.ATTRIBUTE_CHANGE_TYPE_ADD, "uid", "John");

        // Create the user

        User newUser = null;

        try {

            newUser = mysub.createUser(ctx, mps, false);

            

        

            System.out.println("New User DN: " + newUser.getDN(ctx));

        } catch (UtilException e) {

            e.printStackTrace();

        }

    }

      

        

   

}

Workaround To Prevent user from inserting Filename without Extension in UCM Attachment Dialog

in this article i'am going to show you a workaround that may be useful to deal with Extension issue that appear when integrate UCM with BPM .

as you may know when you check use package checkbox in human task(document tab) and before that you were did the required configuration to integrate BPM and UCM(such as defining credentials and UCM IP in workflow properties) the attachment Dialog in pages will appear with extra fields such bellow :

when use fill the data form and then he click OK, the dialog will disappear and the file will be added to table of files which exist at the bottom of page . but the name of link will be like the value of name field in popup above  and without extension this means that user will get undetermined extension file and when he try to download it ,  the file will not be opened in the proper application directly instead of  it's need manual work to associate it with suitable software such as word ..etc using open With and that will cause a headache for users specially those with low computer skills .

To work around this issue i have added regex validator  to input Text to control the input and prevent filenames without real extensions . the solution is sound simple but actually it's take some efforts to catch . such as any other customization for BPM workspace .

Please follow the steps below :

•  Go to similar path on your server  C:\Users\alaayacoub\AppData\Roaming\JDeveloper\system12.2.1.0.42.151011.0031\DefaultDomain\servers\DefaultServer\tmp\_WL_user\oracle.soa.worklist.webapp\km13lp\WEB-INF\lib

•  Open jar adflibWorklistComponents in winrar
•  Copy page manageDocuments.jspx outside and open it
•  Search for inputtext with name “dc_it1” which used for all inputtexts on Dialog using Foreach
•  Replace the Input text with following block

<af:switcher facetName="#{def.propertyDef.id != 'dDocTitle' and  def.propertyDef.id != 'cmis:name'}" defaultFacet="true" id="dc_s88777">

                                    <f:facet name="true">

                                                <af:inputText label="#{def.displayName}" value="#def.providedValue}"

                                                                                          contentStyle="width:200px" columns="35" visible="#{def.visible}"

                                                                                          required="#{def.required}" readOnly="#{def.updatability eq 'READONLY'}" id="dc_it1"/>

                                    </f:facet>

                                    <f:facet name="false">

                                                <af:inputText label="#{def.displayName}" value="#{def.providedValue}"

                                                                                          contentStyle="width:200px" columns="35" visible="#{def.visible}"

                                                                                          required="#{def.required}" readOnly="#{def.updatability eq 'READONLY'}" id="dc_it_name">

                                                            <f:validateRegex pattern="([^\\s]+(\\.(?i)(doc|csv|pdf|xlsx))$)"   />

                                                </af:inputText>

                                    </f:facet>

                        </af:switcher>

•        The goal of above code is 2 things

a.       Separate the name inputtext from others and give him special manipulation

b.      Add Validate Regex to validate Filename and extension on it

• .       Replace adflibWorklistComponents jar with updated on Lib folder
• .       Restart is not required

implementing Sql Authenticator to secure Weblogic , ADF and BPM workspace in 12. 2.1

Sql Authenticator is a weblogic provider that used to enable users stored in databases to login to weblogic console , EM. in addition to use it to authenticate users in ADF stand-alone applications and BPM workspace (using workaround was valid in 11g) .

in 2008, Edwin Biemond wrote very nice article that explain how to implement SQL Authenticator , you can find here here . before few days i have applied this steps in 12.2.1 environments with minor modification . so please pay attention for the Tips below before you go to original article .

• in  12c Groups names for Sql authenticator should be typical to that already defined in default authenticators . groups such as "administrators", "AdminChannelUsers" ...etc , should be added to the table "JHS_ROLES" and keep in mind that column "Short_Name" is sized with only 10 which not enough for Default authenticator groups , for that please consider to change it to 100
• Standalone ADF application which deployed on weblogic can be authenticated using Database users without any extra efforts
• the bad news is about using those users to login BPM workspace by implementing the workaround that specified here and here . this solution was valid in 11g but it's not supported any more based on oracle response to my SR which opened regarding this matter before couples of days  ! 

the error that you will receive as below :

The configured Identity Store provider "oracle.security.jps.internal.idstore.generic.GenericIdentityStoreProvider" is not supported by IDM IdentityDirectory     

to login to BPM workspace using users stored in database you have to use OVD                                                                                                        

How database Adapter Deal with procedures that use Cursors

in this article i gonna take you in short tour to show the way that database adapter manipulate with procedures that use Cursors .

through this article i will explain small BPM example starting from Timer and call Procedure and based on outputs it will raise some human tasks .

first of all, please see the structure of BPM notation :

simply this notation start every cycle (one day in my case ) and call the procedure "GET_COOPS_NOTIFY_YST" to get the group of users that meet the condition spicified the procedure "the remaining days for their end of financial year is 30 days or less " below is the procedure that search for that condition :


create or replace PROCEDURE "GET_COOPS_NOTIFY_YST"
(
  Num_Days IN NUMBER
, prodCur OUT SYS_REFCURSOR
) AS
BEGIN
OPEN prodCur FOR SELECT * FROM USERS  where (to_date( sysdate,'DD-MM-YYYY') - to_date( Fiscal_year_date,'DD-MM-YYYY')) > Num_Days;
END;

the output of this procedure in the Service Activity appeared as 2-dimensional array : rows and columns

the table "users" assumed to be like this :

once record has been returned , simple count check will be fired to make sure that procedure has returned rows and if count >0 the next step will be start to take confirmation from manager to send the notifications to users and if he clicked "APPROVE" the notification will be sent.

to keep the loops moving on i have added 3 scripts :

1. increase Rows : responsible to increase the variable iRows by 1 and reset the value of icols to it initial value
2. increase Columns :responsible to increase the variable icols by 1
3. Set Username : responsible for set value of username to usercoop field which will be set later to FYI notification letter human task .

final check is responsible to exit from loops when irows value exceed count of rows to avoid the index out of range exception .

hope you find this article is useful for you !

Class Not Found Exception when deploying BPM Process

as usual when any developer meet ClassNotfoundException through his deployment of EAR , he will be confused about the reason of this issues . the first reason might come to your mind is missing jar  , which will be the right solution in most of cases but not this case !

today i have faced the following exception  : 

weblogic.application.ModuleException: java.lang.ClassNotFoundException: org.apache.myfaces.trinidad.webapp.TrinidadConverterELTag

as you may expect i started with looking jars and checking weblogic.xml to find any missing jar or reference without any hope .

finally , the solution came from smart colleague and it was simple and direct and it just recreation the Ear profile and use it to deploy again and everything has worked like charm !

Fill Multi language Select One Choice from Table using java Bean

In this article i will show how to fill Select one Choice component from database based on Default browser language .

• Create Table with name "Lov" that contains two languages columns for display text . as show below :

   

• Create jspx page and create java bean for it
• inside the java bean define Selecitems object as follow:                                                                             private List listOfItems = new ArrayList();
• drag drop selectonechoice component to your page the following dialog will appear to determine the list that your SOC will reference to
• choose First option and click Bind and map to listOfItems in your java bean then click next . in the next form fill the label text and requiredmessagedetails

• Generate the accessors
• i suppose that Lov List will be changed based on Browser language , to catch the current language i have added Resource key with name "language"  inside the available Bundles then i will read the value of this key every time i need to check the language .                                                    
  
                                                                                                                                               
• in getListOfItems add the following Code                                                                                   public List getListOfItems() throws SQLException                                                                                                                {                                                                                                                                                                                        Connection DBConn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","user","password");

                          Statement statement = null;                                                                                                                        
                          statement = DBConn.createStatement();                                                                                                    
                          FacesContext context = FacesContext.getCurrentInstance();                                                                        
                          String Lang = context.getApplication().evaluateExpressionGet(context, "#{bundle['language']}", String.class);
                          // or use  Locale browserLocale = FacesContext.getCurrentInstance().getViewRoot().getLocale();
                          // browserLocale.getDisplayLanguage() ;
                          String strQuery =null ;
                          if (Lang=="en")
                             {                                                                                                                                                                
                                  strQuery = "select ID, EN_Name Lov_Name from Lov" ;
                              }
                          else
                             {
                                  strQuery = "select ID, AR_Name Lov_Name from Lov" ;
                              }
                         ResultSet rs = statement.executeQuery(strQuery);
                       
                         while (rs.next())
                            {
                               SelectItem si = new SelectItem();
                               si = new SelectItem();
                               si.setLabel(rs.getString("ID"));
                              si.setValue(rs.getString("Lov_Name"));
                              listOfItems.add(si);
                            }
                return listOfItems;
    }

• to test your code change the language of Browser to see the effect

handling the outcome of serial/Parallel approval human task

in some cases and to avoid creating many ADF pages for the same functionality (same human Task) you may go to use Complex Human Task also you will include many users or roles as serial or parallel or mix of Both . please see image below :

There is no problem when participant click Approve , where task simply will move to the next participant , on contrast we must stop the whole task and go in alternative path if any participant reject the task , to do that we have to use Early Completion feature and check the three checkboxes explained below .

This Feature allow Task to be ended early and exit when certain condition happened such Reject or Approve and no need to pass through next participants.

Monitoring Composite Applications with Sensors and Oracle BAM (1-3) - Composite Sensors

in this series of articles i will discuss monitoring composite applications using Sensors (composite & BPEL)  , in the last part , i will go in short tour to explain integration with oracle BAM.

Sensors Definition :

A sensor is an Oracle construct that enables users to monitor key execution points or data in their composite application. 

There are two types of sensors:
• Composite application
• BPEL

Sensors are associated with sensor actions that can send data
to different publish types:
• Database
• JMS destination
• Custom (Java)
• BAM  

Composite Sensors :

Composite sensors are defined on service and reference binding components. They provide a method for implementing trackable fields on incoming and outgoing messages.

Composite sensor actions enable you to:
• Specify composite sensor details in the search utility of the Instances page of      a SOA composite application in the Oracle Enterprise Manager Fusion                Middleware Control console. This action enables you to locate a particular          instance.
• Publish JMS data computed from incoming and outgoing messages

Composite ِSensors Actions :
Composite sensors support only two types of sensor actions: 

• Enterprise Manager
•  JMS.

Select Enterprise Manager to make runtime sensor data searchable on the Instances tab of a SOA composite application in the Oracle Enterprise Manager Fusion Middleware Control console. 

Note: When Enterprise Manager is selected, sensor data is sent to the trackable fields tables. When it is not selected, data is not sent. However, in both cases, the Oracle Enterprise Manager Fusion Middleware Control console still displays the fields that enable you to search for composite instances based on that sensor.

The JMS Queue and JMS Topic selections enable the composite sensor data (XML payload) to be used by other consumers, including Oracle Business Activity Monitoring and Oracle Complex Event Processing (CEP). Both selections use the native JMS support provided with Oracle WebLogic Server, and not the Oracle SOA Suite JMS adapter described in the Oracle Fusion Middleware User’s Guide for Technology Adapters. You can view JMS messages in the Oracle WebLogic Server administration console.

SOA Composite Example : 
in this section i will create example to show how Composite Sensors works .

• Create SOA Application from Jdeveloper with name "TestCompositeSensorsApp"
• Create SOA Project And name it "TestCompositeSensorsProj"
• Drop BPEL component on composite 
• Drop Assign Component inside BPEL to simply connect input string to output

• Go to Composite.xml an click composite Sensor Icon 
• Create New Sensor and give name , Expression and Filter 

• click ok and deploy !
• go To EM
• test web service with inputs test,test1,test2,test (4 times)
• Click Flow instances Tab
• in Search option Click Add/remove Filter --> check Flow Instance option
• Add the sensor you want and Search instances

Oracle BPM 12c Events

In this post i would like to share nice series of articles about BPM events (start, End and intermediate) this articles has been written by Antonis (oracle ACE) see Blog . you can browse articles from the following links :

http://antonis-antoniou.blogspot.com/2015/01/oracle-bpm-12c-events-part-1-of-3-start.html

http://antonis-antoniou.blogspot.com/2015/04/oracle-bpm-12c-events-part-2-of-3-end.html

http://antonis-antoniou.blogspot.com/2015/07/oracle-bpm-12c-events-part-3-of-3.html

actually it's nice articles and cover the topic in very attractive way .

calling attachment Dialog in BPM human Task pages 12c

in 12c , oracle has changed the way that deal with attachments instead off tables they have added new component with name managedocument .

the way of deal with this control still not clear because the lack of resources and when i try to call attachment of dialog i did not find way for that , finally i found the solution by finding it from inspector then calling it using findcomponet method and that's worked .

to call the attachment dialog you have to use code like below :

 RichPopup attachmentDialo = (RichPopup)manageDoc.findComponent("newAttachmentPopup");
 RichPopup.PopupHints ph = new RichPopup.PopupHints();
        attachmentDialo.show(ph);

Change the branding Logo for BPM Workpace 12C

in this post i will show in details and through clear steps how to change branding log for oracle workspace :

1- first of all create new folder for example mylogowork
2- inside newly created folder create 2 sub folders with names subEar & subwar
3- copy the OracleBPMWorkspace.ear file from C:\Oracle\Middleware\Oracle_Home\soa\soa\applications to subEar
4-Extract EAR file using java jar tool using the following command

C:\Users\alaayacoub\Desktop\mylogowork\subEar>"C:\Program Files\Java\jdk1.8.0_65\bin\jar" c
vf OracleBPMWorkspace.ear  *

5- copy file OracleBPMWorkspace.war to folder subwar
6-repeat step 4 with minor changes

C:\Users\alaayacoub\Desktop\mylogowork\subwar>"C:\Program Files\Java\
jdk1.8.0_65\bin\jar" cvf OracleBPMWorkspace.war *

7- inside folder subwar you will see 2 folder with names img and images and you can set your new image inside any one of them

8- create war file again using jar tool with comman like this

C:\Users\alaayacoub\Desktop\mylogowork\subwar>"C:\Program Files\Java\jdk1.8.0_65\bin\jar" xvf OracleBPMWorkspace.war *

9- copy the new war to folder sub ear and then create new ear file
10- replace OracleBPMWorkspace.ear in oracle home with the new one
11- update the deployment OracleBPMWorkspace in console
12 go to workspace --> administration
13 change the path of logo image to /faces/images/yourimage  save
14- it's worked !

Change Category for BPM Process

 By default all BPM process are listed under Other category in workspace and to categorize it under different categories follow the next steps :

1- open process file (.BPMN) by text editor notepad or notepad++ for better viewing
2- go to xml Tag

  
3- Save and deploy
4- open workspace and you will your process is listed under category "General Services"

Note : you can download Notepad ++ from here