Saturday, November 16, 2019

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


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? Orac...