Problem Configuring ODC Commit profile for ODC For KFI.zip in Solution Accelerator!!!

Hi Everyone

I was working on a project and faced a very strange issue while configuring Commit Profile in ODC as part of  Financial Image Processing Solution Accelerator 11.1.1.4 for EBS.

My servers were running on a different machine(server) and ODC was on a different machine(client).

I was able to import definition for KFI but was not able to configure commit driver(Commit Profile)
The error looked like this:

Failed to automatically connect to I/PM systems and retrieve data.Please correct the login settings and reconnect
Error:Failed to login.Exception:java.lang.LinkageError:JAXB 2.0 API is being loaded from the bootstrap classloader, but this RI(from jar:file:/C:/Program%20Files/OracleDocument%20Capture/OracleIPM11g/lib/oracle.webservices.standalone.client.jar!/com/sun/xml/bind/v2/model/impl/ModelBuilder.class) needs 2.1 API.Use the endorsed directory mechanism to place jaxb-api.jar in the bootstrap classloader(See:http://download.oracle.com/javase/1.5.0/docs/guide/standards/)


After doing lot of research, i concluded that the error was due to the difference in java versions.
There are two methods to overcome this

1)java.endorsed.directory mechanism:

  In order to resolve this issue, download jaxb-api-2.1.jar and put it under jre\lib directory where your Java Jdk is installed for e.g. C:\Program Files\Java\jdk1.6.0\jre\lib\endorsed(create new if doesn't exist)

Create a java.endorsed.dir system variable and assign value equal to path of endorsed directory.
Try this time and this should work, if it doesn't try 2nd step


2)Install the Update patch

If there is a version in JDK version(in client and server machine) even the patch version, then download and install the patch which can make both the version as same

For e.g. if Server is using Sun JDK 1.6_25 and the client machine on which ODC is running uses Sun JDK 1.6.0,
then download and install jxpiinstall.exe

Try this time and it should work!!!
Keep working hard and you will make it!!

How to change Weblogic's JDK Version and Vendor in Windows Platform??

Well this post might not be very useful to you because such a requirement is very rare....but still i thought of writing what i experienced.

I was working on a project and i installed Weblogic by using JDK of Jrockit version 1.6_25(update 25).
Then i installed all the managed servers like soa_server, IPM_server, UCM_server under weblogic.

Everything was working fine till the time i had to configure ODC on a Sun JDK machine, somehow things were not working properly, so i thought of changing the JDK version of my servers.

I dropped the idea of re-installing weblogic and all the managed servers as,  it would have not solved the purpose.

Thus, i figured out the way to change it so that when the server starts it creates a JVM of SUN instead of JRockit.
In order to achieve this, following changes have to be incorporated:

"ShutDown all the servers before starting making configuration changes"

1)First install Sun JDK 1.6.25 and give install directory as C:\java
2)Open setDomainEnv.cmd present under \user_projects\domains\base_domain\bin
3)set BEA_JAVA_HOME=C:\Java\jdk1.6.0_25(modify existing do not add new)
4)set SUN_JAVA_HOME=C:\Java\jdk1.6.0_25(modify existing do not add new)
5)Go to directory \wlserver_10.3\common\bin
6)Open commEnv.cmd
7)set JAVA_HOME=C:\Java\jdk1.6.0_25(modify existing do not add new)
8)set  JAVA_VENDOR=Sun(add if not there)
9)Under option :sun
  i)set JAVA_VM=-client( for development)
               or
 i)set JAVA_VM=-SERVER( for production)
10)Save all and restart servers

Make sure everything is working fine, if weblogic server doesn't start try to add Environment Variable
JAVA_VENDOR=Sun



I hope this might be of any help to you just in case you get stuck in similar situation..!!!

Oracle IPM-Implementing Financial Image Processing Solution Accelerator

Hi Everybody

I have been writing blogs on SOA and BPM, but of late i have started working on Oracle IPM(Imaging And Process Management) 11gas well.

Recently i have started one implementation of Oracle IPM on Financial Image Processing Solution Accelerator for Oracle EBS at a client's location. The accelerator is a basic solution for AP process(Accounts Payable), it offers basic functionality for implementing paperless solution for Accounts Solution.
Invoice comes into the Organization,scan it using ODC or ODDC from remote location, index it using OFR and manage workflows using IPM with SOA-BPEL as the engine.
During this implementation i encountered several issues which i never faced while working in my office.So, i thought of sharing them just in case it might be of any help.
The main step in Installing Accelerator is to make sure AXF is working fine.AXF is nothing but a framework Application Extension Framework which consists of tables with entires at ERP end(EBS in this case) and at IPM end.
AXF is automatically installed at IPM end when Oracle ECM 11.1.1.5 is installed.Oracle provides directory under C:\Oracle\Middleware\Oracle_ECM1\axf
This directory consists of scripts and demo for installing and testing AXF for EBS or PeopleSoft.
After the installation, it's necessary to test whether AXF is running fine.
To test go to drivers directory under axf:-
1) Click helloworld and then dbscripts directories respectively
2)use the credentials for IPM schema(created during RCU) for login in database
3)Connect and run inserthellocommand.sql
4)Open :http://:16000/imaging/faces/Driver.jspx
 where ipaddress:address where IPM server is running
5)Login using the administrative credentials
6)Enter CommandNamespace:HelloWorld
7)SolutionNamespace:Hi
8)User:Administrative User(eg weblogic)
9)Click on Execute Command, if Conversation Id is generated that means AXF is installed and working properly......


Testing AXF-BPEL Integration:
The main purpose of AXF is to provide integration between IPM and ERP(EBS and Peoplesoft).When a document is scanned and submitted in IPM, then workflow is initiated in SOA on BPEL engine.Thus, whenever any change is done in the process which requires changes in ERP it should be reflected automatically.
In order to synchronize AXF is used and BPEL integration becomes necessary.

To test, perform following things
1)Under axf\HelloBpel select dbscripts\oracle
2)Open insertHelloBPELData.sql
3)In statement,Insert into AXF_SOLUTION_ATTRIBUTES (SOLUTION_NAMESPACE,PARAMETER_KEY,PARAMETER_VALUE) change BPEL_ConnectionName with the name of the Connection created in IPM
4)Execute this query with credentials of shema owner for IPM(created using RCU)
5)Open HelloBpel.jws in jdeveloper and deploy to soa managed server.
6)See the human task, if task is assigned to california group, then create one in Admin Console and assign admin user to it.
7)Open :http://:16000/imaging/faces/Driver.jspx where ipaddress:address where IPM server is running
8)Enter following CommandNameSpace:HelloBPEL
9)Solutionnamespace:OPEN_TASKLIST
10)User:Administrative User(eg weblogic)
11)Click on ExecuteCommand
12)ConversationId should be generated
13)Click on ExcecuteResponse
14)It will take you to worklist and you should be able to see task

If succesful, consider htis to be done.

Common issues: If after clicking on Execute Response, you see this

If this is what you see, try StartHelloBPEL as CommandNamespace.I hope this should work.

Even then if it doesn't show tasks in the worklist, fire the BPEL instance from Enterprise Manager and try to generate a task in worklist.
I am sure once you are able to see task in BPM worklist, you can be sure that instance would automatically get fired once document is uploaded in IPM.

I hope you will find this a bit useful for your implementations.

Thanks and all the best!!