Advanced Supply Chain Planning

This chapter covers the following topics:

Performing Pre-Configuration Setup

Complete these tasks after applying the patch and before starting the installation.

Overview

Review this table for the correct WebLogic, Fusion Middleware, and Java Developer Kit versions. Install them based on your platform operating system.

Release WebLogic Version Fusion Middleware Version Java Developer Kit Version
Value Chain Planning Release 12.2.4.1 and earlier 10.3.6.0 - Fusion Middleware 11.1.1.6.0
- ADF Runtime 11.1.1.6.0		 Use the Oracle JDeveloper and Application Development Framework 11g Certification and Support Matrix.
Value Chain Planning Release 12.2.4.2 and later 10.3.6.0 - Fusion Middleware 11.1.1.9.0
- ADF Runtime 11.1.1.9.0		 Use the Oracle JDeveloper and Application Development Framework 11g Certification and Support Matrix.

If you are installing Value Chain Planning Release 12.2.6, apply these Application Development Framework patches against Fusion Middleware 11.1.1.9.0:

Process

  1. Confirm that you have WebLogic 11gR1 (WebLogic Server 10.3.6.0) installed. See the table in this section to confirm that you have the proper Fusion Middleware Version, ADF Runtime, and Java Developer Kit versions installed.

    1. Install the required Java Developer Kit.

      Confirm that you install a Java Developer Kit that is compatible with your operating system and WebLogic Server version.

      See Oracle Fusion Middleware 11g Release 1 (11.1.1.x) Certification Matrix.

    2. Install WebLogic 10.3.6 according to Oracle WebLogic Server Installers

      Navigate to Installers with Oracle WebLogic Server and Oracle Coherence and download the file for your platform, for example, ./wls1036_linux32.bin.

      After installing, create a new Oracle home and note the directory.

    3. Install Application Development Framework Runtime according to Downloads for Oracle ADF. Navigate to Application Development Runtime, select the correct version, and download the file.

      Download ADF Runtime 11.1.1.6.0 from Oracle Software Delivery Cloud.. Search for Oracle Application Development Runtime.

      Unzip the ADF runtime zip file, for example,

      unzip ofm_appdev_generic_11.1.1.9.0_disk1_1of1.zip.

      cd Disk1

      ./runInstaller -jreLoc <JDK location>

      Use the same Oracle home from the WebLogic installation.

    4. Configure the WebLogic Server domain according to Creating the ASCP Domain and Admin Server.

  2. After applying the patch, copy file $MSC_TOP/patch/115/ear/PlanningUIEar.zip from the EBS server to a directory on the WebLogic Server.

  3. Create a folder named applications on the host machine where WebLogic is installed. These instructions reference this folder as applications. For example,

    /slot/ems1392/oracle/mwhome/user_projects/domain/fmw_domain/applications.

  4. Copy the .zip file to the folder applications.

  5. Extract the .zip file to the same folder. The zipped file contains the file PlanningUI.ear that you select from this location during deployment.

    See also:

  6. In the EBusiness Suite application, set profile option MSC: ASCP Planning URL at the site level--the EBS instance which the data source points to. The internal profile name is MSC_ASCP_WEBLOGIC_URL.

    Set it to http://domain_name:port_number, for example, http://rws60144rems.us.oracle.com:6087.

    Use the same port number for the Advanced Supply Chain Planning domain managed server that you define in Creating the ASCP Managed Server.

Performing Configuration

This section includes information about the following ASCP configuration tasks:

  1. Creating the ASCP Domain and Admin Server

  2. Creating the ASCP Managed Server

  3. Creating the JDBC Data Source

  4. Setting Up MDS Repository

  5. Starting the Admin Server and Managed Server

  6. Deploying and Starting the Planning Application

Creating the ASCP Domain and Admin Server

If you currently have a working WebLogic Server (WLS) and domain created with the certified JDK version and specified ADF Runtime version, this step is optional. Go to Creating the ASCP Managed Server.

On the installed WLS, create a new WLS domain (for example, ascpdomain), and a new admin server (for example, AdminServer) in this domain.

Perform the following procedure to create the ASCP domain.

  1. Go to <WLS_HOME>/common/bin folder.

    Example:

    cd <installation path>/wlserver_10.3/common/bin

  2. Run config.sh script.

    Example:

    ./config.sh

    The Welcome screen for the Oracle WebLogic Configuration Wizard appears. This wizard guides you through the steps to generate a new domain or extend an existing domain.

    the picture is described in the document text

  3. Select Create a new WebLogic domain and click Next. The Select Domain Source screen appears.

    the picture is described in the document text

  4. Perform the following:

    1. Select Generate a domain configured automatically to support the following products.

      Keep the default settings.

    2. Click Next.

      The Specify Domain Name and Location screen appears.

      the picture is described in the document text

  5. Provide the Domain name and Domain location, and then click Next.

    The domain location is <WLS_HOME>/user_projects/domains where <WLS_HOME> is the installation path for your WebLogic server.

    The Configure Administrator User name and Password screen appears.

    the picture is described in the document text

  6. Enter the User name, User password and Confirm user password of your choice, and then click Next.

    The Configure Server Start Mode and JDK screen appears.

    the picture is described in the document text

  7. Perform the following:

    1. Select Production Mode.

    2. In JDK Selection region, select Available JDKs and select the appropriate version.

    3. Click Next.

      The Select Optional Configuration screen appears.

      the picture is described in the document text

  8. Select the Administrative Server option only and click Next.

    The Configure the Administration Server screen appears.

    the picture is described in the document text

  9. Perform the following:

    1. Input the fields in the following table.

      Field Description
      Name Enter the name of the admin server.
      Listen address The admin server listen port address. Leave default option of All Local Addresses.
      Listen port Enter the server listen port number. Check the availability of the number before entering a value.
      SSL listen port Enter the SSL listen port number. Check the availability of the number before entering a value.

    2. Select the SSL enabled option.

    3. Click Next.

      The Configuration Summary screen appears.

      the picture is described in the document text

  10. Review the details. If you want to modify any settings, use the Previous button to return to the appropriate screen. If no changes are required, click Create.

    The Creating Domain screen appears and displays the system progress.

    the picture is described in the document text

  11. When the domain is complete, click Done.

    The wizard closes.

  12. Go to the ASCP domain directory.

    Example:

    $ cd /slot/ems3424/appmgr/WLS/user_projects/domains/ascpdomain/

  13. In the ASCP domain directory (for example, ascpdomain), create the output/ and log/ directories as follows:

    $ mkdir - m 777 output/

    $ mkdir -m 777 log/

Creating the ASCP Managed Server

This section provides procedures for creating the managed server and applying JRF.

  1. Open a Web browser and type in the URL/address in the following format:

    http://<Machine_Name>:<Port_No>/console

    <Machine_Name> represents the host name of the machine on which the WebLogic server is running (for example, rws3220163.us.oracle.com) and <Port_No> is the Admin server Listen port number specified when the ASCP domain was created.

    Example:

    http://rws3220163.us.oracle.com:7901/console

    The Oracle WebLogic Administration Console appears.

    the picture is described in the document text

  2. Navigate to Servers in the Domain Structure region.

    Example Navigation Path:

    base_domain > Environment > Servers

  3. Click New to create a new server.

  4. Perform the following:

    1. Input the fields in the following table.

      Field Description
      Server Name Enter the name of the ASCP managed server (for example, ASCPManagedServer).
      Server Listen address Enter the listen address for manager server.
      Server Listen port Enter the server listen port number.

    2. Define the server cluster options as needed.

    3. Click Next.

    4. Select the SSL Enabled option to enter the SSL port number.

    5. Enter the Secured Socket Listen port in the SSL Port field.

    6. Click Finish.

      The Configuration tab displays the new managed server.

      the picture is described in the document text

  5. Apply JRF on Managed Server using Enterprise Manger (EM).

    1. Open a Web browser and type in the URL/address in the following format:

      http://<Machine_Name>:<Port_No>/em

      <Machine_Name> represents the host name of the machine on which the WebLogic server is running (for example, rws3220163.us.oracle.com) and <Port_No> is the Admin server Listen port number specified when the ASCP domain was created.

      Example:

      http:// rws3220163.us.oracle.com:7901/em

    2. Navigate to WebLogic domain, your domain name, and select the Managed Server.

      The managed server information appears on the right side of the page.

      the picture is described in the document text

    3. Click Apply JRF Template.

      When successfully applied, a confirmation message appears at the top of the page.

      the picture is described in the document text

      The JRF Template can also be applied from the command line using the following procedure:

      Note: Skip the command line procedures if JRF was already applied using Enterprise Manger (EM).

      1. Run wlst.sh from Middleware bin directory.

        cd $MIDDLEWARE_HOME\oracle_common\common\bin

        ./wlst.sh

      2. Authenticate the connection.

        Example:

        connect('weblogic','welcome1', 'rws3220040.us.oracle.com:7004')

        Substitute your WLS username and password in the example above. Provide the host and port where the WLS Admin Server is running for the ASCP domain.

      3. Apply JRF.

        Example:

        applyJRF('ASCPManagedServer', '/slot/ems6479/appmgr/Oracle111160/Middleware/user_projects/domains/base_domain', true)

        Use your Managed Server name and the path for the ASCP domain directory example above.

Creating the JDBC Data Source

Perform the procedure below to create the JDBC data source (for example, ApplicationDB).

  1. Log in to the WebLogic administration console, as described in Creating the ASCP Managed Servers.

  2. Click Lock & Edit from the Change Center region, located on the top left of the page, if applicable.

    the picture is described in the document text

  3. Navigate to Data Sources under the Domain Structure region.

    Example Navigation:

    base_domain > Services > JDBC > Data Sources

  4. Click New.

    The Create a New JDBC Data Source page appears.

    the picture is described in the document text

  5. Perform the following:

    1. Input the fields in the following table.

      Field Description
      Name Enter the name of the JDBC data source (for example, ApplicationDB).
      JNDI Name Enter the name you want to assign to your new JDBC Data Source (for example, jdbc/ApplicationDBDS).

    2. Select Oracle from the Database Type list.

    3. Click Next.

      The JDBC Data Source Properties page appears.

      the picture is described in the document text

    4. Select the Oracle's Driver (Thin) for instance connections, Version 9.0.1 and later from the Database Driver list.

    5. Click Next.

      The Transaction Options page appears.

      the picture is described in the document text

    6. Click Next to accept the default settings displayed.

      The Connection Properties page appears.

      the picture is described in the document text

    7. Input the database connection detail fields in the following table.

      Field Description
      Database Name Enter the database name (for example, ma1yd213).
      Host Name Enter the host name or IP address of the database server (for example, rws60052rems.us.oracle.com).
      Port Enter the port on the database server used to connect to the database (for example, 1572).
      Database User Name Enter the database account user name you want to use to create database connections (for example, apps).
      Password Enter the database account password you want to use to create the database connections.
      Confirm Password Retype your password.

    8. Click Next.

      The Tests Database Connection page appears.

    9. Click Test Configuration.

      If the JDBC is set up correctly, then the following message appears at the top of the page:

      Connection test succeeded.

      the picture is described in the document text

    10. Click Next.

      The Select Targets page appears.

      the picture is described in the document text

    11. Select the ASCP managed server you created (for example, ASCPManagedServer), and click Finish.

    12. Select the new JDBC data source (for example, ApplicationDB), and click the Configuration tab.

    13. Select Connection Pool subtab and set Maximum Capacity field to 150. The default value for the field is 15.

      the picture is described in the document text

    14. Scroll down the page, and click the Advanced link. The Advanced options appear.

    15. Select Test Connections on Reserve and click Save.

    16. Click Activate Changes from the Change Center region, located on the top left of the page. This screen only appears if you were in Lock & Edit mode, which you selected at the beginning of this procedure.

      the picture is described in the document text

      At this point, you have successfully set up the JDBC Resource.

Setting Up MDS Repository

Performing the following procedure to set up the MDS repository.

  1. Return to the UNIX console and go to the ASCP domain home (the path where ASCP domain is installed).

  2. Create a new directory "mds": (<ASCP_Domain_Home>/servers/<ASCPManagedServer>/mds).

    Example:

    <installation_path>/user_projects/domains/uitestdomain/servers/AdminServer/mds

Creating a File Persistence Store

To create a file persistence store in WebLogic Server Administration Console, perform the following procedure:

  1. Click Lock & Edit button from the Change Center region to change the domain configuration, if applicable.

  2. Click Persistent Stores from the Domain Structure region (or you can navigate to Services > Persistent Stores from the Domain Structure region).

    The Summary of Persistent Store page appears.

    the picture is described in the document text

  3. Click New, and select Create File Store.

  4. Perform the following:

    1. Enter mds-ascp-repos in the Name field.

    2. Select ASCPManagedServer from the Target list.

    3. Enter <ASCP_Domain_Home>/servers/<ASCPManagedServer>/mds in the Directory path field.

    4. Click OK.

  5. Click Activate Changes from the Change Center region, located in top left of the page.

Starting the Admin Server and Managed Server

Perform the command line procedure below to start the ASCP Admin Server and ASCP Managed Server.

  1. Change directories to the <DOMAIN_HOME>/bin location.

    Syntax:

    cd $<DOMAIN_HOME>/bin

    Example:

    /slot/ems6479/appmgr/Oracle111160/Middleware/user_projects/domains/base_domain/bin

  2. Start the AdminServer.

    Example Syntax:

    nohup ./startWebLogic.sh -Dweblogic.management.username=weblogic -Dweblogic.management.password=welcome1> weblogic.out &

    Substitute your Hostname, Managed server post, Username and Password in the example command above.

  3. Start the ASCPManagedServer.

    Example Syntax:

    nohup ./startManagedWebLogic.sh "ASCPManagedServer" "http://rws3220163.us.oracle.com:7001" -Dweblogic.management.username=weblogic -Dweblogic.management.password=welcome1 >ASCPManagedServer.out &

    Substitute your Hostname, Managed server post, Username and Password in the example command above.

Deploying and Starting the Planning Application

This procedure consists of the following tasks:

  1. Copying and extracting the ZIP files.

  2. Deploying the Planning Application.

Copying and Extracting the ZIP Files

Perform the following procedure to copy and extract the ZIP files.

After applying the VCP patch, the PlanningUIEar zip file has to be copied from EBS APPL_TOP to a directory where WebLogic is installed. The new application will have to be deployed to the ASCPManaged server.

  1. Create a folder with name "applications" in a directory on the host machine where WebLogic is installed. This folder is referred to as "applications".

    Example:

    /slot/ems1392/oracle/mwhome/user_projects/domain/fmw_domain/applications

  2. Copy the following ZIP files to the folder "applications".

    Example:

    cp $MSC_TOP/patch/115/ear/PlanningUIEar.zip <applications>

  3. Extract the ZIP files to the same folder.

    The PlanningUI.ear file is selected from this location for deployment.

Deploying the Planning Application

Perform the following procedure to deploy the Planning Application:

  1. 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.

  2. Select Deployments in the Domain Structure region.

    The Summary of Deployments - Control tab appears.

  3. Select Install to install the new Planning Application.

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

    the picture is described in the document text

  4. In the Path field, enter the <applications> directory path.

    Example:

    /slot/ems1392/oracle/mwhome/user_projects/domain/fmw_domain/applications

  5. Select PlanningUI.ear and click Next.

    The Select deployment targets page appears.

    the picture is described in the document text

  6. From the list of Available targets for PlanningUI, select ASCPManagedServer and click Finish.

    When the deployment is complete, the "PlanningUI" deployment is visible.

  7. Verify your deployment.

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

    the picture is described in the document text

Post-Installation

If you are installing Value Chain Planning Release 12.2.6, edit the file $FND_TOP/secure/allowed_redirects.conf by adding these lines:

profile MSC_ASCP_WEBLOGIC_URL

profile FND_OBIEE_URL

Upgrading ASCP

Performing an upgrade consists of the following tasks:

  1. Copying and extracting the ZIP files.

  2. Redeploying the planning application.

Copying and Extracting the ZIP Files

Perform the Copying and Extracting the ZIP Files procedure in Deploying and Starting the Planning Application.

Redeploying the Planning Application

To redeploy, you must first delete the existing PlanningUI application. Perform the procedure below to delete the PlanningUI application, then refer to Deploying and Starting the Planning Application for instructions on deploying your new Planning Application.

  1. In order to redeploy the Planning application, open the WebLogic UI for the ASCP Domain according to the procedure mentioned in Starting the Admin Server and Managed Server.

  2. Select Deployments in the Domain Structure region.

    the picture is described in the document text

  3. Select the PlanningUI application you want to redeploy and click Stop. Select Force Stop Now.

  4. Click Yes to stop the application.

    the picture is described in the document text

  5. Select the PlanningUI application you want to redeploy and click Delete.

  6. Deploy your new Planning Application. Refer to Deploying and Starting the Planning Application for instructions.

Troubleshooting

The table below contains information or possible solutions about potential issues or errors that may occur while attempting to upgrade to the ASCP Usability Enhancement.

Issue Solution
The PlanningUI deployment does not appear in Active state. Please stop and delete the deployment. Follow steps in Redeploying the Planning Application.
Deployment errors indicate ADF related error or libraries missing. Ensure that the managed server was created in a domain which is JRF enabled.
An error occurs while running applyJRF from command line wlst.sh. Type help('all') and make sure applyJRF is available.
Use the following:
$MIDDLEWARE_HOME\oracle_common\common\bin\wlst.sh