Tuesday, August 9, 2011

Integrating APEX 4.0.2 with E-business Suite Release 12.1.1

Hi,
Apex can be integrated with E-business Suite release R12.In the below example my Database vesion is 11.1.0.7.0,I'm using APEX LISTENER for doing this task which is very secure and convenient way.Below are the steps I used for this purpose.

Step 1:Create one Tablespace for holding the Apex users Data

create tablespace APEX402 datafile '/oraDB/db/apps_st/data/apex402.dbf' size 1G autoextend on;

Step 2:Upgrade Apex to 4.0.2

E-business suite Database 11.1.0.7.0 comes with Apex 3.0.2 installed,For upgrading to the latest apex component follow the below steps:

For upgrading apex 4.0.2:
----------------------------


Go to apex 4.0.2 path:

sqlplus "/as sysdba"
@apexins.sql apex402 apex402 temp /i/

Message while upgrading coming to end:

Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the APEX_040000 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

Message while validating APEX componnent:

.Compiled 676 out of 2720 objects considered, 0 failed compilation 05:22:43
...234 packages
...227 package bodies
...426 tables
...12 functions
...19 procedures
...3 sequences
...439 triggers
...1177 indexes
...175 views
...0 libraries
...4 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 05:22:43
...Completed key object existence check 05:22:43
...Setting DBMS Registry 05:22:43
...Setting DBMS Registry Complete 05:22:43
...Exiting validate 05:22:43
timing for: Validate Installation
Elapsed: 00:44:26.45
timing for: Development Installation
Elapsed: 01:06:23.02
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


JOB_QUEUE_PROCESSES: 2

Check after validation in Database:

SQL> SELECT COMP_NAME||' '||VERSION||' '||STATUS FROM DBA_REGISTRY;

COMP_NAME||''||VERSION||''||STATUS
--------------------------------------------------------------------------------
Oracle Application Express 4.0.2.00.07 VALID
Oracle Ultra Search 11.1.0.7.0 VALID
Oracle Label Security 10.2.0.3.0 OPTION OFF
Oracle XML Database 11.1.0.7.0 VALID
Oracle Application Server Syndication Services 10.1.2.0.2 VALID
Oracle Application Server Single Sign-On 10.1.2.0.2 VALID
Oracle Workflow 10.1.2.0.2 VALID
Oracle Data Mining 11.1.0.7.0 VALID
OLAP Catalog 11.1.0.7.0 VALID
Oracle Text 11.1.0.7.0 VALID
Spatial 11.1.0.7.0 VALID

COMP_NAME||''||VERSION||''||STATUS
--------------------------------------------------------------------------------
Oracle Multimedia 11.1.0.7.0 VALID
Oracle Database Catalog Views 11.1.0.7.0 VALID
Oracle Database Packages and Types 11.1.0.7.0 VALID
JServer JAVA Virtual Machine 11.1.0.7.0 VALID
Oracle Database Java Packages 11.1.0.7.0 VALID
Oracle XDK 11.1.0.7.0 VALID
Oracle Real Application Clusters 11.1.0.7.0 INVALID
OLAP Analytic Workspace 11.1.0.7.0 VALID
Oracle OLAP API 11.1.0.7.0 VALID
Oracle Application Server Integration B2B 10.1.2.0.2 VALID
Oracle Application Server Integration BAM 10.1.2.0.2 VALID

COMP_NAME||''||VERSION||''||STATUS
--------------------------------------------------------------------------------
Oracle Application Server Certificate Authority 10.1.2.0.2 VALID
Oracle Internet Directory 10.1.2.0.2 VALID
Oracle Application Server Metadata Repository Version-R 10.1.2.0.2 VALID
Oracle Application Server Distributed Configuration Management 10.1.2.0.2 VALID
Oracle Business Intelligence Discoverer 10.1.2.0.2 VALID
Oracle Application Server UDDI Registry 10.1.2.0.2 VALID
Oracle Application Server Web Clipping 10.1.2.0.2 VALID
Oracle Application Server Wireless 10.1.2.0.2 VALID

30 rows selected.
Now,We have successfully upgraded APEX to 4.0.2.

Step 3:Start the http services using the ‘root’ user

#/etc/init.d/httpd start
[root@testnode1ebs apex]# /etc/init.d/httpd status
httpd (pid 13319 13318 13317 13316 13315 13314 13313 13312 13310) is running...

Step 4: Open the Apex http port from the Database side
SQL> begin
dbms_xdb.sethttpport('8080');
end;
/

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
from dual;

HTTP-Port
----------
8080

Step 5:Download JDK6 from oracle and unzip it in the E-business suite server.

Step 6:Download and Install the Apex Listener

Launch Oracle Application Express Listener in standalone mode:

1. Download and unzip Oracle Application Express Listener.

2. Execute the following command:

bash-3.2$ java -jar /apex_4.0.2/apex.war
INFO: Starting: /apex_4.0.2/apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: /tmp/apex
Enter the path to the directory containing the APEX static resources
Example: /Users/myuser/apex/images
or press Enter to skip: /oraAPP/apps/tech_st/10.1.3/images
INFO: Using classpath: file:/tmp/apex/apex/____embedded/start.jar:file:/tmp/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/ojmisc.jar:file:/tmp/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/tmp/apex/apex/WEB-INF/lib/ucp.jar:file:/tmp/apex/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/tmp/apex/apex/WEB-INF/lib/apex.jar:file:/tmp/apex/apex/WEB-INF/lib/je-4.0.103.jar:
INFO: Starting Embedded Web Container in: /tmp/apex
Enter a username for the APEX Listener Administrator [adminlistener]: apex
Enter a password for apex:welcome
Confirm password for apex:

Enter a username for the APEX Listener Manager [managerlistener]: apex
Enter a password for apex:welcome
Confirm password for apex:
Aug 10, 2011 2:32:41 AM ____bootstrap.Deployer deploy
INFO: Will deploy application path=/tmp/apex/apex/WEB-INF/web.xml
Aug 10, 2011 2:32:48 AM ____bootstrap.Deployer deploy
INFO: deployed application path=/tmp/apex/apex/WEB-INF/web.xml
Using config file: /tmp/apex/apex-config.xml
APEX Listener version : 1.1.2.131.15.23
APEX Listener server info: Grizzly/1.9.18-o
INFO: http://localhost:8080/apex started

Step 7:Configure the Apex listener.
http://testnode1ebs:8080/apex/listenerConfigure

To configure the Apex listener Open IE 8 browser or Mozilla 3.0….
And provide the information and password as mentioned :

SID:VIS
Host:10.47.33.56
Password: welcome

Step 8:Request Apex team to create WORKSPACE by giving ‘admin’ user password.

Note: ‘admin’ user should be entered in Lower case letters.

User:admin
Password:welcome


Step 9:If You are getting ADMIN/ADMIN_PASSWORD as "Invalid Login Credential Error", then run

Connect as sys user at the EBS Database and execute this procedure:
begin

SQL> begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'ADMIN',
p_email_address => 'xxx@xxxdomain.com',
p_web_password => 'welcome') ;
end;
/

PL/SQL procedure successfully completed.

Step 10:Verify now with the APEX team and ask them to change the password for security reason..

Username:workspace
Pass:welcome

Happy Apex learning job is done...


Best regards,

Rafi.

1 comment:

  1. Hi Rafi,
    I don't see where you integrated with R12.1.1


    I've been working on integrating APEX4.2 with EBS 12.0.4 using the APEX Listener.
    I have followed the example that Rob West wrote up and have the LaunchApex.jsp (Custom not GTW)
    http://www.oracle.com/technetwork/developer-tools/apex/apex-ebs-wp-cabot-consulting-169064.pdf

    I read R11i can be integrated by using modplsql, R12 uses the new jsp solution, BUT not until R12.1.3
    What about between R12.0 and R12.1.3 ?

    Our customer isn't upgrading for another 6 months but want to start developing EBS with APEX.. what about unsupported? that would work because we would go to product until the upgrade is done..

    Thanks, Bill

    ReplyDelete