Advanced Planning Command Center

This chapter covers the following topics:

Setting Translated Messages

Due to enhancements related to RPD translation compatibility, Both English-only and non-English users are required to setup RPD translated as documented in readme of 8629912:R12.MSC.B APCC TRANSLATION ONE-OFF FOR 12.1. The following is extracted from that readme.

To verify whether RPD translated messages is setup properly, user may:

To set up RPD translated messages, it requires user to have the following:

Setting Up RPD Translated Messages

Perform the procedure below.

  1. Stop all OBIEE services.

  2. Unzip $MSC_TOP/patch/115/obiee/apcc-obiee-en.zip.

  3. Locate appc_en.dlf file extracted.

  4. Run following as APPS database user:

    delete from msc_translated_message where lang_id='en';
    commit;
  5. Import appc_en.dlf into database.

    transx "(connection_string)" apps (password) (path)\appc_en.dlf
    %XDK_HOME%\bin\transx "rws60050rems:1617:ma0dv211" apps apps D:\appc_en.dlf
  6. Check msc_translated_message is populated from appc_en.dlf.

    select count(*) from msc_translated_message where lang_id='en';
  7. Start all OBIEE services.

Troubleshooting

If TransX doesn't run due to missing classes, it's most likely that class path is not set properly. Following sample shows setting CLASSPATH variable for Windows 10g client with XDK option:

    set XDK_HOME=D:\Oracle\product\10.2.0\client_1
    set CLASSPATH=%XDK_HOME%\LIB\xmlparserv2.jar;
                %XDK_HOME%\LIB\xsu12.jar;%XDK_HOME%\LIB\oraclexsql.jar;
                %XDK_HOME%\LIB\transx.zip;%XDK_HOME%\jdbc\lib\classes12dms.jar;
                %XDK_HOME%\jdbc\lib\ojdbc14.jar;
                %XDK_HOME%\LIB\servlet.jar;
                %XDK_HOME%\RDBMS\jlib\xdb.jar;%CLASSPATH%

For more XDK information, refer to Oracle XDK documentation.

Using Webcenter for APCC

This topic provides information about using Webcenter with APCC.

Prerequisites

Verify the information below.

  1. Verify that weblogic/webcenter/soa components are installed by following the My Oracle Support note 1074345.1.

  2. Verify UCM is installed and configured properly [optional].

  3. Verify that VCP 12.1.3 patch [9482453:R12.SCP_PF.B] or later is installed.

Configuring Webcenter

To configure Webcenter for Oracle Advanced Planning Command Center perform the following:

  1. Deploy and configure the spaces servlet.

  2. Deploy and configure the BPM Tasklist.

  3. Deploy and configure the group space Template.

  4. Deploy and configure the application links [Optional].

  5. Deploy and configure the SOA BPEL flows.

  6. Set up profile options.

  7. Compile MscWCRedirect.jsp.

  8. Run the Planning Process Activities concurrent process.

  9. Change the Webcenter application name.

Deploy and Configure the Spaces Servlet

Perform the procedures below to deploy and configure the spaces servlet.

  1. Obtain file mscspacesservlet.ear from $MSC_TOP/patch/115/ear/mscspacesservlet.ear.

  2. Copy it to your local directory in Linux Session.

  3. Open the Webcenter Console for the Webcenter domain.

  4. Log in to the Webcenter Console.

  5. Click Lock and Edit > Goto Domain Structure.

  6. Click Deployments.

  7. Click Install.

  8. Click link upload your file(s).

  9. Search for your .ear file in the deployment archive and select the .ear file to deploy.

  10. Click Next, select Managed Server WLS_Spaces, deploy .ear file, and click Finish.

  11. After this finishes deployment to the managed server, click the Release Configuration.

  12. If the state of deployment of mscspacesservlet is Prepared, click Lock and Edit > Deployments, select deployment mscspacesservlet, click Start, click Servicing all requests, click Release Configuration. Verify that the deployment status of mscspacesservlet changes to Active.

  13. To generate Java keystore in the Webcenter instance, go to JDK_HOME/jdk/bin and open a command prompt.

  14. Execute the following keytool run commands to generate keystore producer.jks:

    keytool -genkeypair -keyalg RSA -dname "cn=producer,dc=example,dc=com" -alias producer -keypass welcome1 -keystore /scratch/dumakant/keystore/samedomain/producer.jks -storepass welcome1 -validity 365
            keytool -exportcert -v -alias producer -keystore /scratch/dumakant/keystore/samedomain/producer.jks -storepass welcome1 -rfc -file producer.cert
            keytool -importcert -alias webcenter_spaces_ws -file producer.cert -keystore /scratch/dumakant/keystore/samedomain/producer.jks -storepass welcome1
    

    /scratch/dumakant/keystore/samedomain/ can be your local Linux home path.

    Set the value of recipient key alias in profile option MSC: APCC Webcenter Spaces Recipient Key Alias.

  15. Connect to the Webcenter server using telnet.

  16. Execute the following command:

    cd /slot/ems2995/appmgr/Oracle/Middleware/user_projects/
    domains/wc_domain/config/fmwconfig/
    
  17. Copy producer.jks to this location.

  18. Open jps-config.xml.

  19. Change serviceInstance as follows:

    serviceInstance name="keystore" provider="keystore.provider" location="./default-keystore.jks" to location="./producer.jks"
  20. Run command wlst.

  21. Connect to the Webcenter using the following command line:

    connect('weblogic','welcome1', 'Webcenter host:port')

    For example, for Webcenter host:port, use dadvmi0029.us.oracle.com:7060.

  22. Back up cwallet.sso.

  23. Execute the following:

    createCred(map="oracle.wsm.security",key="enc-csf-key",user="producer",password="welcome1",desc="Enc Password")
     createCred(map="oracle.wsm.security",key="sign-csf-key",user="producer",password="welcome1",desc="Enc Password")
     createCred(map="oracle.wsm.security",key="keystore-csf-key",user="keystore-csf-key",password="welcome1",desc="Keystore password")
    
  24. Restart the Webcenter servers.

Deploy and Configure the BPM Tasklist

Perform the following procedures to deploy and configure the BPM Tasklist.

Create a Directory and Set a Path

  1. Create directory /tmp/tasklist and set path as follows:

    /Oracle/Middleware/jdk160_11/bin/:$PATH

Update and Copy the .war File to the Webcenter Home

  1. Get file msc_custom_spaces.zip from ARU and unzip it to obtain custom.webcenter.spaces.war. Then, unjar it. Execute the following:

    cd /tmp/tasklist;
            unzip msc_custom_spaces.zip
            cd /tmp/tasklist;
            jar xvf custom.webcenter.spaces.war;
    
  2. Go to WEB-INF/lib/ and unjar wf_client_custom.jar. Execute the following:

    cd /tmp/tasklist/WEB-INF/lib;
    mkdir temp;
    cp wf_client_custom.jar temp/
    cd temp;
    jar xvf wf_client_custom.jar
    
  3. Open wf_client_config.xml and provide your soa server URL for tagsserverURL and rootEndPointURL.

  4. Update wf_client_custom.jar with the updated wf_client_config.xml. Execute the following:

    cd /tmp/tasklist/WEB-INF/lib/temp;
    jar uvf wf_client_custom.jar wf_client_config.xml
    
  5. Copy file wf_client_custom.jar to WEB-INF/lib/. Execute the following:

    cp /tmp/tasklist/WEB-INF/lib/temp/wf_client_custom.jar ../
    cd /tmp/tasklist/WEB-INF/lib/;
    rm -rf temp;
    
  6. Update custom.webcenter.spaces.war with updated file WEB-INF/lib/wf_client_custom.jar and all other files that were part of custom.webcenter.spaces.war. After executing these commands, there is updated custom.webcenter.spaces.war at /tmp/:

    cd /tmp/tasklist;
    jar uvf custom.webcenter.spaces.war WEB-INF/lib/wf_client_custom.jar
    
  7. To back up, execute the following:

    /slot/ems4372/appmgr/oracle/middleware/Oracle_WC1/webcenter/
    modules/oracle.webcenter.spaces_11.1.1/
    custom.webcenter.spaces.war
    cd /slot/ems4372/appmgr/oracle/middleware/Oracle_WC1/
    webcenter/modules/oracle.webcenter.spaces_11.1.1/
    cp custom.webcenter.spaces.war custom.webcenter.spaces.war.orig
    
  8. Copy custom.webcenter.spaces.war. Execute the following:

    /slot/ems4372/appmgr/oracle/middleware/Oracle_WC1/webcenter/
    modules/oracle.webcenter.spaces_11.1.1/
    cd /slot/ems4372/appmgr/oracle/middleware/Oracle_WC1/webcenter/
    modules/oracle.webcenter.spaces_11.1.1/
    cp /tmp/custom.webcenter.spaces.war
    

Update Deployments

  1. Navigate to http://rws60212rems:7004/console/ using weblogic/welcome1 and click button Lock & Edit.

  2. Click Deployments, select webcenter, click Stop, select option Force Stop Now, and answer Yes to the confirmation question.

  3. Re-select webcenter, click Delete, and answer Yes to the confirmation question.

  4. Select custom.webcenter.spaces, click Update, click Next, click Next, and click Finish.

  5. Click Install. Select path as follows:

    /slot/ems4372/appmgr/oracle/middleware/Oracle_WC1/archives/applications, and file as webcenter.ear

    Deploy it on managed server WLS_Spaces.

  6. Click Deployments, select webcenter, click Start, select option Start servicing all requests, and answer Yes to the confirmation question.

Set extendApp to true in setDomain.sh.

  1. Open /slot/ems4372/appmgr/oracle/middleware/user_projects/domains/wc_domain/bin/setDomainEnv.sh and add the following:

    EXTRA_JAVA_PROPERTIES="-Doracle.webcenter.spaces.extendApp=true ${EXTRA_JAVA_PROPERTIES}"
    export EXTRA_JAVA_PROPERTIES
    
  2. Restart managed server WLS_Spaces.

Create a New View in Oracle BPM Worklist

  1. Navigate to the BPM worklist [http://rws60212rems:8880/integration/worklistapp] and log in using admin credentials.

  2. Click the Add [+] icon from section Worklist Views.

  3. Select Create View, select name APCC Shared View, select Add to Standard Views. Navigate to Add Condition drilldown and select State. Click the Add [+] icon, select Assignees who can share this view.

  4. Select Display tab, then select these columns in the left side of the window:

    • Title: BPEL process name that you created in the Scenario Manager

    • Due Date

    • Application Context: BPEL Activity Name

    • Identifier: Plan name

    • State: Worklist task state--Assigned, Deleted, Suspended

    • Category: BPEL Activity Status - In progress, Not Started, Error or Completed

    • Created: Date

    • Creator: User

  5. Click OK.

Test the Tasklist

  1. Navigate to Webcenter [http://rws60212rems:8877/webcenter/] and log in.

  2. Create a blank group space, edit page, click add content. The Catalog opens.

  3. Click open on APCC Custom Folder, move to Task List, and click Add.

  4. Verify that it is added to the Tasklist.

Deploy and Configure the Group Space Template

  1. Get file msc_apcc_gs_template.ear from ARU.

  2. Copy it to your local directory.

  3. Open the Webcenter Spaces URL.

    http://rws60212rems.us.oracle.com:8877/webcenter
  4. Log in to the Webcenter Spaces URL.

  5. Navigate to the Webcenter Administrator.

  6. Click the Manage Group Spaces and Group Space Templates. Manage Group Spaces opens.

  7. Click the Templates subtab. The Manage Group Space Templates window opens.

  8. Click the Import option. The Import Archive Name window opens.

  9. Select Option Archive Located on Local File System, specify local directory as the EAR file location, and click the Import button. This completes the group space template import.

  10. Log in to the Webcenter Spaces URL.

  11. Click Group Spaces.

  12. Click Create Group Space.

  13. Enter Group Space Name, enter Description, and select group space template name.

  14. Click Create. This creates a group space with group space name given.

  15. Click Group Space Name tab.

  16. Navigate to Setting > Custom Attributes.

  17. Select custom attribute FND_OBIEE_URL.

  18. Navigate to Actions, and select Edit Attribute.

  19. Enter your OBIEE URL.

    http://adc60069fems.us.oracle.com:9799/
  20. Click OK.

  21. Select custom attribute APPS_SERVLET_AGENT.

  22. Navigate to Actions, and select Edit Attribute.

  23. Enter Apps Servlet URL.

    http://rws60147rems.us.oracle.com:8034/OA_HTML
  24. Click OK.

  25. Select custom attribute MSC_SCN_SERVICE_ENDPOINT.

  26. Navigate to Actions, and select Edit Attribute.

  27. Enter the BPM Worklist URL.

    http://rws60018rems.us.oracle.com:8880
  28. Click OK.

  29. Navigate to the home page, click Edit Page, delete the worklist component from top of the page, and place APCC Custom Folder > Tasklist at the same location. This replaces a worklist component with a tasklist component.

  30. Navigate to the Setting tab, and then navigate to the General tab.

  31. Click Save as Group Space Template. The Save as Group Space Template window opens.

  32. Enter Template Name, enter Description, and check Publish.

  33. Click Save. This creates the template.

  34. Enter the template name in MSC: APCC Webcenter Group Space Template Profile.

Deploy and Configure Application Links [Optional]

This configures e-Business Suite functions as external applications in the Webcenter Personal Sidebar; the user can navigate to e-Business Suite from Webcenter.

Group space also contains application links with context-like group space names, but application Links defined in Webcenter Personal Sidebar do not pass context information to e-Business Suite applications.

  1. Open enterprise manager [http://host:port/em] and log in as administrator [weblogic/welcome1].

  2. Expand Webcenter, expand Webcenter spaces, select webcenter (WLS Spaces), right-click Settings, and click Service Configuration.

  3. Select External Applications.

  4. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: Scenarios

    • Display Name: Scenarios

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/OA_HTML/MscObieeSrvlt?ParamType=Name&FROM_NODE=WC&TO_NODE=SCN
    • Find the values for the host and port from the value of profile option Apps Servlet Agent.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  5. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: Supply Chain Analyst Dashboard

    • Display Name: Supply Chain Analyst Dashboard

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/OA_HTML/MscObieeSrvlt?ParamType=Name&FROM_NODE=WC&TO_NODE=SCA

      Find the values for the host and port from the value of profile option Apps Servlet Agent.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  6. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: Sales and Operations Planning Analyst Dashboard

    • Display Name: Sales and Operations Planning Analyst Dashboard

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/OA_HTML/MscObieeSrvlt?ParamType=Name&FROM_NODE=WC&TO_NODE=SOP

      Find the values for the host and port from the value of profile option Apps Servlet Agent.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  7. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: Simulation Planner Workbench

    • Display Name: Simulation Planner Workbench

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/OA_HTML/MscObieeSrvlt?ParamType=Name&FROM_NODE=WC&TO_NODE=rp

      Find the values for the host and port from the value of profile option Apps Servlet Agent.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  8. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: Demand Management Workbench

    • Display Name: Demand Management Workbench

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/OA_HTML/MscObieeSrvlt?ParamType=Name&FROM_NODE=WC&TO_NODE=DEMANTRA

      Find the values for the host and port from the value of profile option Apps Servlet Agent.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  9. Click the Add icon, input values for these entities, and click OK.

    Some of these are sample values:

    • Application Name: BPM Worklist

    • Display Name: BPM Worklist

    • Enable Automatic Login: Selected

    • Login URL:

      http://host:port/integration/worklistapp

      Find the values for the host and port from the value of profile option MSC: Scn Service End Point.

    • HTML User ID Field Name: usernameField

    • HTML User Password Field Name: passwordField

    • Authentication Method: Post

    • Enable Shared Credentials: Selected

    • User Name: TEST

    • Password: TEST

  10. Open Webcenter spaces [http://host:port/webcenter] and log in as administrator [weblogic/welcome1].

  11. Navigate to the top menu, select the Administration, and click Integrate Existing Applications.

  12. Expand Applications Node, select Scenarios, and click Edit. For each application, change Open Behavior to the Webcenter tab, and click OK.

Deploy and Configure SOA BPEL Flows

You can deploy and configure SOA BPEL flows using the one of the options below.

Option A: BPEL Deployment for EBS 12.1.3

  1. Uptake 9499809:R12.TXK.B.

  2. In WebLogic Administration Console create a JDBC Data Source connection, name it CustomerDBConnection, and, for Database Driver, select Oracle's Driver (Thin) for Instance Connections; Version:9.0.1,9.2.0,10,11. Click Next. Clear Supports Global Transactions option, and then click Next. For JNDI Name, use jdbc/CustomerDBConnectionDS. Provide all the database information required, set Initial Capacity to 0 and click Next. Test your connection, and on the next page, select soa_server1.

  3. Follow MSC flow deployment steps in My Oracle Support note 1070257.1.

Option B: BPEL Deployment for VCP 12.1.3/VCP 12.1.2

  1. In the WebLogic Administration Console, create a JDBC Data Source connection, name it CustomerDBConnection, and, for Database Driver, select Oracle's Driver (Thin) for Instance Connections; Version:9.0.1,9.2.0,10,11. Click Next. Clear Supports Global Transactions option, then click Next. For JNDI Name, use jdbc/CustomerDBConnectionDS. Provide all the database information required, set Initial Capacity to 0, and click Next. Test your connection, and on the next page, select soa_server1.

  2. In the WebLogic Administration Console, navigate to soa_server1 > Deployments. From the list, click DbAdapter. Navigate to Configuration > Outbound Connection Pool, and create a New connection pool using javax.resource.cci.Coonectionfactory as Outbound Connection Groups , use eis/DB/CustomerDBConnection for the JNDI Name , then click Finish. Open the Connection (eis/DB/CustomerDBConnection) and set DataSourceName to jdbc/CustomerDBConnectionDS (the data source created before).

    • If SSO is enabled on WebLogic, EBS users will get authenticated on WebLogic.

    • If the SSO is not enabled on WebLogic, please create EBS users who will create/start the BPEL flows on the WebLogic side.

    • Deploy file msc_ws_todoworklist_ws.ear (from $MSC_TOP/patch/115/ear/soa11j) on the soa server and set Context Root to MSC-WS-TODOWORKLIST.

  3. Deploy msc_ws_bpelprocess_ws.ear (from $MSC_TOP/patch/115/ear/soa11j) under <SOA_DOMAIN>selecting Application Deployments, Context root - MSC-WS-BPELSeedUtil

  4. Move all files sca_*.jar and file MscJarBuild.xml file under the same directory and execute the following:

         ant -buildfile MscJarBuild.xml
                    -DnewDbConnName=<DB CONNECTION NAME>
                    -DnewDwURL=<DEMANTRA WORKFLOW URL>
                    -DnewSoaURL=<SOA SERVER URL>

    <DB CONNECTION NAME> is CustomerDBConnection

    <DEMANTRA WORKFLOW URL>is the Oracle Demantra Workflows Web service end point. For example, http://ap7001dma.us.oracle.com/mz121ut1.

    <SOA SERVER URL> is WebLogic soa component URL.

    http://rws60018rems.us.oracle.com:8880

    An example of the command appears below.

         ant -buildfile MscJarBuild.xml
                    -DnewDbConnName=CustomerDBConnection
                    -DnewDwURL=http://ap7001dma.us.oracle.com/mz121ut1
                    -DnewSoaRL=http://rws60018rems.us.oracle.com:8880
    

    After the ant command finishes successfully, verify that there is a new directory EbsModifiedBpelJars and that it contains the modified BPEL jar files.

    This example shows how to set up the ant command on a Linux machine with Oracle Middleware installed:

    • Go to the same directory as all bpel JAR files and MscJarBuild.xml.

    • Create a script a.sh according to the example below:

      export WL_HOME=/slot/ems2995/appmgr/Oracle/Middleware
      export JDK_HOME=/slot/ems2995/appmgr/Oracle/Middleware/jdk160_11
      export ANT_HOME=$WL_HOME/modules/org.apache.ant_1.7.0
      export JAVA_HOME=/slot/ems2995/appmgr/Oracle/Middleware/jdk160_11
      export BEA_HOME=/slot/ems2995/appmgr/Oracle/Middleware
      export PATH=/slot/ems2995/appmgr/oracle/produc/11.1.1/as_1/bin:$WL_HOME/modules/org.apache.ant_1.7.0/bin:$PATH
      ant -f MscJarBuild.xml  -DnewDbConnName=CustomerDBConnection -DnewDwURL=http://rws60051rems.us.oracle.com:7870/mz1dv220 -DnewSoaURL=http://
      rws60018rems.us.oracle.com:8880
      
    • Change all the environment variables to correspond to your environment setting, and then run the script.

  5. In the WebLogic Enterprise Manager window, right-click <SOA_DOMAIN> and select SOA Deployment > Deploy.

    Deploy all the .jar files from directory ../EbsModifiedBpelJars directory in the following order:

    1. sca_check_Dematra_Workflow_Process_Status.jar

    2. sca_checkProcessStatus.jar

    3. sca_Approve_Consensus_Demand_Process.jar

    4. sca_ASCP_Collections_Process.jar

    5. sca_Demantra_Collections_Process.jar

    6. sca_Upload_Forecast_Process.jar

    7. sca_Run_Supply_Plan_Process.jar

    8. sca_Review_Supply_Plan_Process.jar

    9. sca_Review_Process.jar

    10. sca_Forecast_Inventory_SupplyPlan_Process.jar

    11. sca_Sales_And_Operations_Planning_Process.jar

    12. sca_MscReceiveUpdateFromOtm.jar

Set Up Profile Options

Perform the procedure below to set up your profile options.

  1. Navigate to your e-Business Suite environment.

  2. Select responsibility System Administrator.

  3. Navigate to Profiles > System.

  4. Verify or set values for the profile options as displayed in the table below.

    Profile Options
    Number / Owner System Profile Name User Profile Name Valid Values / Set To Comments
    1 MSC_WC_ENABLED MSC: APCC Webcenter Enabled Yes/No -
    2 MSC_WC_SPACES_MEMBERROLE MSC: APCC Webcenter Spaces Member Role Viewer Or Participant Members added to the webcenter group space can be either viewers or participants.
    3 MSC_WC_SPACES_TEMPLATE MSC: APCC Webcenter Group Space Template Webcenter Group Space Template Name

    Basic

    4 MSC_WC_SPACES_RECIPIENTKEYALIAS MSC: APCC Webcenter Spaces Recipient Key Alias Recipient Key Alias

    Producer

    5 MSC_WC_SPACES_SAMLISSUERNAME MSC: APCC Webcenter Spaces Saml Issuer Name Saml issuer name of Webcenter

    www.oracle.com

    6 MSC_WC_SPACES_PORT MSC: APCC Webcenter Spaces Port Webcenter Spaces managed server Port

    8877

    7 MSC_WC_URL MSC: APCC Webcenter URL Webcenter URL
    http://rws60018rems.us.oracle.com/webcenter/wcAuthentication/?login=true&success_url=/spaces
    Replace your host and keep the other things same. Then, you skip the Webcenter welcome/login screen when navigating from e-Business Suite to Webcenter.
    8 MSC_SCN_SERVICE_ENDPOINT MSC: BPEL End Point URI WebLogic Soa server url
    http://rws60212resm.us.oracle.com:8880
    8880 is the soa_server1 port number.
    9 MSC_SCN_BPEL_DOMAIN MSC: BPEL Domain Name soa-infra For example, soa-infra.
    10 MSC_WS_WEBLOGIC_USERNAME MSC: APCC WebLogic Username Oracle BPM worklist admin user

    weblogic_admin

    This user should be admin for OID and Webcenter.
    11 MSC_WS_WEBLOGIC_PASSWORD MSC: APCC WebLogic Password Oracle BPM worklist admin password.

    welcome1

    12 MSC_WC_WEBLOGIC_USERNAME MSC: APCC WebLogic Console Username WebLogic admin user

    weblogic

    This user should be the admin user for Weblogic.
    13 MSC_WC_WEBLOGIC_PASSWORD MSC: APCC WebLogic Console Password Set it to WebLogic admin password.

    welcome1

Compile MscWCRedirect.jsp

Perform the procedure below to compile the MscWCRedirect.jsp file.

  1. Log in to the middle tier where $APPL_TOP resides as an appmgr user

  2. Execute the following command:

    cd $FND_TOP/patch/115/bin;
  3. Compile and flush as follows:

    perl ojspCompile.pl --compile -s 'MscWCRedirect.jsp' –flush
  4. Restart the middle tier as follows:

    cd $ADMIN_SCRIPTS_HOME;
    adoacorectl.sh stop;
    adoacorectl.sh start;
    adoacorectl.sh status;
    

Run the Planning Process Activities Concurrent Process

Perform the procedure below to run the Planning Process Activities concurrent process.

  1. Run the Planning Process Activities concurrent process.

  2. Log in to http://rws60018rems.us.oracle.com:7004/em using the WebLogic admin user.

  3. Navigate to SOA > soa-infra.

  4. Click Deployed Composite. Verify that there is a green dot before each flow name and that there is a green up arrow in each status. If there is not, undeploy the flow, restart the server, deploy the flow, and check it again.

  5. Select responsibility Advanced Planning Scenario Manager.

  6. Run concurrent process Planning Process Activities concurrent process. This populates the Oracle 11g BPEL flows into the MSC tables.

Change the Webcenter Application Name

Perform the procedure below to change the Webcenter application name.

  1. Log in to Webcenter using administrator.

  2. Click the Administration link at the top of the page.

  3. Select the General tab.

  4. Change Application Name to Value Chain Planning.

  5. Click Apply.