Oracle eBusiness Suite & Oracle IPM Integration using AXF Adapter

Introduction

Oracle Imaging and Process Management (IPM) provides a well demand integration with Oracle E-Business Suite to increase business processes efficiency enterprise-wide. The E-Business Suite Adapter for Oracle I/PM automates paper-intensive processes by coupling document capture and imaging technology with workflow, enabling organizations running E-Business Suite to streamline content-driven, high transactional processes like invoice processing or expense reporting.

Integration Approach

The E-Business Suite Adapter for Oracle I/PM provides a framework known as Application Extension Framework (AXF) which delivers a seamlessly integrated user experience to E-Business Suite, via a loosely-coupled, service oriented architecture.

Oracle Application Extension Framework (AXF) is a command-driven, web services integration between a business application and BPEL (Oracle BPEL Process Manager), using Oracle I/PM as the imaging source. Through an AXF configuration, business users can process associated images and perform document-centric workflow tasks from their business application user interface. The open Java-based architecture of AXF allows integrators to configure multiple business process solutions.

Steps Carried/To be carried out In Ebusiness Suite’s Enviroment

 A) Login as system User in EBS Database and Run the below PL/SQL Commands For      Creation OEIS user 

  Create user OEIS identified by OEIS;

   grant connect,resource to OEIS;

   grant create table to OEIS;

   grant create sequence to OEIS;

   grant create public synonym to OEIS;    

B) Connect to EBS Database as OEIS user and execute  ebs/R11/AXF_CREATE_TABLES_SYNONYM.sql 

C) Connect to EBS Database as apps user and execute (This is used to store PL/SQL procedures for the integration)

1) R11/AXF_ADD_EBS_ATTACHMENT_PROC_R11.sql

2) R11/AXF_SOAP_CALL_PROC.sql

D) Forms Compilation :-

AXF installation also requires a number of files to be uploaded to the E-Business Suite

system. This enables a seamless integration of custom actions with pre-existing

E-Business Suite Forms

1) From the installation package, copy AXF_INSTALL_DIR/ebs/R12/AXF_

CUSTOM.pld or AXF_INSTALL_DIR/ebs/R11/AXF_CUSTOM.pld  to the E-Business Server

2) For UNIX system , If copied the.PLDs from a Windows machine, issue the dos2unix command before converting it

3) Open Oracle Forms Builder and connect to the E-Business Suite database as the

apps user. Forms Builder is typically located in the /bin/ subdirectory of your

database's Oracle Home.

4) Open and convert the AXF_CUSTOM.pld to a.pll by selecting File >

Administration > Convert. Select PL/SQL libraries from the drop down box and

the Text to binary option while converting the file.

5) With AXF_CUSTOM.pll open, select Program > Compile > All.

6) Select File > Administration > Compile File to compile AXF_CUSTOM into a

module (.plx).

7) Select File > Connect and ensure that you are connected to the database as an

APPS user.

8) Open the CUSTOM.pll by selecting File > Open and selecting PL/SQL Libraries

(*.pll) in the Files of Type: combobox

9) Ensure that this file is appropriately backed up before making changes.

10) Modify the CUSTOM.pll as shown below. The modifications are formatted in bold

italics. If any other customizations already exist in this file, place our modifications

at the end of the existing code inside each function/procedure

 function zoom_available return boolean is

 begin

-- Required for ALL integrations

return AXF_CUSTOM.zoom_available();

 end zoom_available;

  procedure event(event_name varchar2) is

 begin

-- Required for AXF integrations

AXF_CUSTOM.event(event_name);

null;

end event; 

11) With the CUSTOM.pll open, verify that AXF_CUSTOM is listed as an Attached

Library and select Program > Compile > All. If AXF_CUSTOM is not listed, add it

before compiling.

12) Select File > Administration > Compile File to compile CUSTOM into a module

(.plx). AXF_CUSTOM must be compiled using the APPS schema user ID.

13) Adding Ip address of IPM Server to host entry

E) Connect to EBS Db as OEIS. And  Execute 

AXF_EBS_SOLUTION_DATA.sql

2) insertApData.sql

(Puts AXF configuration values in the AXF Tables in Ebusiness Suite database)

 F) Create a user called jcooper and jausten in your EBS instance and assign them the APresponsibility.

 G) Test the integration setup.