Integrate Oracle ADF with Oracle E-Business Sutie 12.2 ASCP Instance

Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA - Supply Planning Work Area


What is Oracle ADF?

Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework that builds on Java EE standards and open-source technologies to simplify and accelerate implementing enterprise applications. Oracle ADF is suitable for enterprise developers who want to create applications that search, display, create, modify, and validate data using web, mobile, and desktop interfaces.

You can use the whole Oracle ADF framework to create an application, or you can use parts of the framework in combination with other technologies. Throughout this guide, applications that contain any ADF technologies are generally referred to as ADF applications. Web applications that incorporate ADF technologies throughout the business service, model, controller, and view layers are referred to as Fusion web applications.

What is SPWA - Supply Planning Work Area?

12.2.5 VCP introduces a new form for users that is an alternative to the planner workbench.
The standard Planner Workbench is still available and will not be removed from the applications.

This form uses the same ADF (Application Development Framework) tech stack that powers Rapid Planning and Fusion applications - part of the FMW tech stack - (Fusion Middle Ware)
This does not use standard Oracle Forms tech stack that has been the standard for the last 15+ years.

It depends on your Weblogic tech stack and ADF rendering of the forms.

There are some important functional differences between the Planner Workbench and the Supply Planning Work Area
There are also setup considerations for your Sysadmin to consider during setup.
And there are different debugging steps required for issues that you may encounter in the Work Area

How do you Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA - Supply Planning Work Area

From EBS 12.2.5 On wards Supply Planning Work Area is introduced which replaced ASCP Planner Workbench in earlier EBS releases

Meaning How do you launch Oracle ADF page from Oracle E-Business Suite 12.2

High Level  Steps

1. Download and Install New/Separate Weblogic Server Version 10.3.6
2. Download and Install ADF Runtime 11.1.1.9.0
3. Configure Weblogic Server Domain
4. Create new Managed Server in Weblogic for this ADF
5. Create JDBC Data Source
6. Setting up MDS Reporsitory
7. Start Admin and Managed Server
8. Deploy the Planning UI Application
9. Set the MSC Profile in EBS
10. Test the ADF page from EBS Responsibility

In detail..

1. Download and Install New/Separate Weblogic Server Version 10.3.6

Download Software from below URL

https://www.oracle.com/middleware/technologies/weblogic-server-installers-downloads.html

- Stage this in file system
- Make sure you have JDK 1.6 above
- Set the JDK Home (export JDK_HOME=/u01/utilities/jdk160_29)
- If the installation file type in jar then run the below command

$(JAVA_HOME)/bin/java –jar wls1036_generic.jar
-If the instillation file type is bin then run the below command

./wls1036_linux32.bin

The Welcome screen will be displayed. Click on Next to continue

In the Next screen, Select the Middleware Home Directory and click on Next to continue .

In the Register for Security Updates page, give your email address if you want to get security updates. Otherwise  do not select the check box and Click on continue .

If you have not selected the check box , in the next page click Yes to continue,

In the next screen, Select the check box to continue .

In the Installation Type page, select Typical and click on Next to continue

In the next page, select the JDK installed on the server.

In the Next screen , select the directories for Product installation.  Click on Next to continue

In the Installation Summary page , click on Next to continue

The Weblogic 10.3.6 Installation will start and you can see the progress in the next screen . Click on next once 100% is completed .

The Weblogic 10.3.6 installation is completed .

2. Download and Install ADF Runtime 11.1.1.9.0

Download Software from below URL

https://www.oracle.com/tools/downloads/application-development-framework-downloads.html

- Stage this software in the file system in the unix server
- cd /stage/adf_11.1.1.9.0
./runInstaller -jreLoc /u01/utilities/jdk160_29

The Welcome screen will be displayed. Click on Next to continue

Select Skip Software Updates. Click on Next to continue

Click on Next to continue

Input Middleware Home path where you installed Weblogic Software in the First step

Click on Next to continue

Click on Install to continue

Click on Next to Finish the Installation

ADF Runtime 11.1.1.9.0 installation is complete

3. Configure Weblogic Server Domain

- Goto Newly instllaed Weblogic Home/common/bin
cd /u01/app/oracle/product/fmw_oam2/wlserver_10.3/common/bin
./config.sh

The Welcome Wizard screen will be displayed. 
Select Create a new Weblogic domain

The Select Domain screen will be displayed. 
Select first option Generate domain 
Select both Oracle Enterprise Manager and Oracle JRF

The Specify Domain screen will be displayed. 
Give Domain Name as ascp_domain

The Configure Administrator screen will be displayed. 
Give Weblogic password - welcome123

The Configure Server Start Mode screen will be displayed. 
Select Production Mode

The Optional Configuration screen will be displayed.
Select Administration Server

The Configure the Administration server screen will be displayed.
Change the Listener port to other port if this WLS is installed on Same EBS Apps Tier
Change to 7051 and uncheck SSL if not SSL Enabled

The Configuration Summary screen will be displayed.
Click on Create button

The Creating Domain screen will be displayed.
Click on Done completes Domain Screen

Domain creation is  complete

4. Create New Managed Server in Weblogic for this ADF

We are creating Managed Server 

- Open Weblogic Console with port 7051 given while Configuring Admin server
-  http://webtest.linux.local:7051/console
- Login with weblogic username and password

The Administration Console screen will be displayed.
Click on Servers -> Create New

Open Weblogic EM Console with port 7051 given while Configuring Admin server
-  http://webtest.linux.local:7051/em
- Login with weblogic username and password

The EM Fusion Middleware Console Control screen will be displayed.
Click on Weblogic Domain -> ASCPManagedServer
Click  on Apply JRF Template

JRF Template Confirmation

5. Create JDBC Data Source

- Open Weblogic Console with port 7051 given while Configuring Admin server
-  http://webtest.linux.local:7051/console
- Login with weblogic username and password

The Administration Console screen will be displayed
Click on ascp_domain->Services->Data Sources -> New -> Generic Data Sources

Click Next and select Database Driver type

Click Next and select Default options

Click Next and provide DB Name,Apps Username and password

Click Next and finish

Change the value to 150 in Application DB Configuration tab Maximum Capacity

Services -> Data Sources -> Application DB -> Connection Pool Tab

Maximum Capacity = 150

6. Setting up MDS Repository

Create MDS Directory at OS level in ASCP Managed Server Location 

cd /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/servers/ASCPManagedServer

mkdir mds

Creating a Fille Persistence Store in Weblogic Console


- Open Weblogic Console with port 7051 
-  http://webtest.linux.local:7051/console
- Login with weblogic username and password

The Administration Console screen will be displayed

Click on ascp_domain->Services->Persistent Stores -> New -> CreateFileStore

Create a New File Store screen will come

Enter mds-ascp-repos in the Name field.

Select ASCPManagedServer from the Target list.



Enter /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/servers/ASCPManagedServer/mds in the Directory path field.

Click Ok

In case you don't see directory structure, Bounce ASCPManagedServer Once

7. Start Admin and Managed Server

You can use standard commands to start these servers

8. Deploying the Planning UI Application

1)    Copying and extracting the ZIP files.

mkdir /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/applications

cp $MSC_TOP/patch/115/ear/PlanningUIEar.zip /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/applications/.

2)    Deploying the Planning Application.

    

cd /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/applications/

unzip PlanningUIEar.zip

mkdir /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/servers/ASCPManagedServer/stage/PlanningUI

cp applications/PlanningUI.ear /u01/app/oracle/product/fmw_oam2/user_projects/domains/ascp_domain/servers/ASCPManagedServer/stage/PlanningUI/.

3) In order to deploy the Planning Application

 open the WebLogic UI for ASCP Domain according to the procedure mentioned in Starting the Admin Server and Managed Server.

  Select Deployments in the Domain Structure region.

  The Summary of Deployments - Control tab appears.

  Select Install to install the new Planning Application.

  The Install Application Assistant - Locate deployment to install and prepare for deployment page appears

Open Weblogic Console with port 7051 

-  http://webtest.linux.local:7051/console

- Login with weblogic username and password

The Administration Console screen will be displayed

Click on ascp_domain->Deployments -> Install -> Provide Path

Click Next -> Select ASCPManagedServer - Click Finish

When the deployment is complete, the PlanningUI deployemnt is visible

Select Deployments from the Domain Structure region, locate PlanningUI in Deployments table. PlanningUI deployment should be in ""Active"" state."

9. Set the MSC Profile in EBS

This is only needed for ASCP Work Bench which is ADF Page for EBS ASCP Instance

Profile Name: MSC: ASCP Planning URL

Value: http://webtest.linux.local:7151

10. Test the ADF Page from EBS Responsibility

Reference:

12.2.5 - SPWA - Supply Planning Work Area - An Alternative To The ASCP Planner Workbench (Doc ID 2049195.1)


https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=964316.1%3AE48790_03&action=inline