Advanced Planning Command Center

This chapter covers the following topics:

Setting Up Advanced Planning Command Center Reports and Dashboards

This section is about setting up Advanced Planning Command Center (APCC) reports and dashboards.

Installation Prerequisites

Before performing Advanced Planning Command Center Planning (APCC) installation and setup procedures, verify these application prerequisites:

Set ORACLE_HOME

Set the ORACLE_HOME environment variable to the directory where you have installed either

Configuring the tnsnames.ora File

Configure file tnsnames.ora so the BI Server can connect to the database.

In OBIEE 11g, the software itself contains database client. When you connect to the database through the Repository or BI Server, it locates the tnsnames.ora entry in the Oracle Client of OBIEE 11g instead of your database.

The tnsname.ora file is in location MW_HOME/Oracle_BI1/network/admin/tnsnames.ora.

Note: If file does not exist, create a new one. The file entry format is not fixed, but follows standard Oracle tnsnames.ora format.

The file format is <addressname>=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)HOST=<hostname>)(PORT=<port>))(CONNECT_DATA=(SID=<sid>))).

For example, mz1dv220=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rws60147rems.us.oracle.com)(PORT=1524))(CONNECT_DATA=(SID= mz1dv220))).

Configuring and Deploying RPD and Webcat Files

Download file mscrpd.zip, file mscwebcat.zip, and the language file that you need to set up from $APPL_TOP to a temporary directory. For example, apcc-obiee-ja.zip for Japanese.

This table associates the language files and their languages.

File Name Language
apcc-obiee-ar.zip Arabic
apcc-obiee-cs.zip Czech
apcc-obiee-da.zip Danish
apcc-obiee-de.zip German
apcc-obiee-el.zip Greek
apcc-obiee-en.zip English
apcc-obiee-es_ES.zip Spanish
apcc-obiee-fi.zip Finnish
apcc-obiee-fr.zip French
apcc-obiee-he.zip Hebrew
apcc-obiee-hr.zip Croatian
apcc-obiee-hu.zip Hungarian
apcc-obiee-it.zip Italian
apcc-obiee-ja.zip Japanese
apcc-obiee-ko.zip Korean
apcc-obiee-nl.zip Dutch
apcc-obiee-no.zip Norwegian
apcc-obiee-pl.zip Polish
apcc-obiee-pt.zip Portuguese
apcc-obiee-pt_BR.zip Brazilian Portuguese
apcc-obiee-ro.zip Romanian
apcc-obiee-ru.zip Russian
apcc-obiee-sk.zip Slovak
apcc-obiee-sv.zip Swedish
apcc-obiee-th.zip Thai
apcc-obiee-tr.zip Turkish
apcc-obiee-zh_CN.zip Simplified Chinese
apcc-obiee-zh_TW.zip Traditional Chinese

If you are using OBIEE 11g:

  1. Unzip mscwebcat.zip to the OBIEE server ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/.

  2. Unzip mscrpd.zip and place file AdvancedPlanning.rpd in a temporary location.

  3. Open Fusion Middleware control using URL http://hostname.domain:port/em.and:

    1. Log in with the WebLogic user and password.

    2. In left tree structure, select Business Intelligence > coreapplication > tab Overview.

    3. Click Stop. All services stop.

  4. Remain in the Fusion Middleware control and:

    1. In left tree structure, select Business Intelligence > coreapplication > tab Deployment > tab Repository.

    2. In Presentation Service Repository, verify the absolute path for the PlanningAnalytics directory. For example, <CatalogPath>/slot/ems1395/fmw/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/PlanningAnalytics.

    3. If you need to change the path, navigate to the top of the page and click Lock & Edit Configuration. Remain at the top of the page, change the catalog path, click Apply, and click Activate Changes.

  5. From the Windows client, Oracle Business Administration Tool, open AdvancedPlanning.rpd. In Physical, Planning Analytics, change the database connection information in MSC_Conn and MSC_INIT_Conn.

    If you are setting up a single sign-on environment--the most common setup:

    1. Enable Connection Scripts for MSC_Conn and MSC_INIT_Conn.

    2. Set the translations initialization variables:

      • Navigate to Manage > Variables > Session > Initialization Blocks.

      • Enable Manage Translation and Set Translation.

      • Disable Set Translations without SSO.

    3. Save your changes.

    If you are not setting up a single sign-on environment:

    1. Disable Connection Scripts for MSC_Conn and MSC_INIT_Conn.

    2. Set the translations initialization variables:

      • Navigate to Manage > Variables > Session > Initialization Blocks.

      • Disable Manage Translation and Set Translation.

      • Enable Set Translations without SSO.

    3. Save your changes.

  6. Return to the Fusion Middleware control using URL http://hostname.domain:port/em.and:

    1. Log in with the WebLogic user and password.

    2. In left tree structure, select Business Intelligence > coreapplication > tab Deployment > tab Repository.

    3. Navigate to section upload BI Server Repository.

    4. Browse to its temporary location and select AdvancedPlanning.rpd.

    5. Enter the password.

    6. Click Apply.

    7. Click Activate Changes at top of page.

  7. Refresh GUIDs using the procedure in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1.3.0) > Refresh the User GUIDs.

If you are using OBIEE 12c:

  1. Unzip mscwebcat.zip to the OBIEE server ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content.

  2. Unzip mscrpd.zip and place file AdvancedPlanning.rpd in a temporary location.

  3. Stop services.

    1. cd ORACLE_HOME /user_projects/domains/bi/bitools/bin

    2. ./stop.sh

  4. Copy AdvancedPlanning.rpd to a Windows machine. From the Windows client, Oracle Business Administration Tool 12c, open it. In Physical, Planning Analytics, change the database connection information in MSC_Conn and MSC_INIT_Conn.

    If you are setting up a single sign-on environment--the most common setup:

    1. Enable Connection Scripts for MSC_Conn and MSC_INIT_Conn.

    2. Set the translations initialization variables:

      • Navigate to Manage > Variables > Session > Initialization Blocks.

      • Enable Manage Translation and Set Translation.

      • Disable Set Translations without SSO.

    3. Save your changes.

    If you are not setting up a single sign-on environment:

    1. Disable Connection Scripts for MSC_Conn and MSC_INIT_Conn.

    2. Set the translations initialization variables:

      • Navigate to Manage > Variables > Session > Initialization Blocks.

      • Disable Manage Translation and Set Translation.

      • Enable Set Translations without SSO.

    3. Save your changes.

  5. Perform file upload

    1. Copy the modified rpd to a temporary location on the linux server where you installed OBIEE 12c.

      ORACLE_HOME/user_projects/domains/bi/bitools/bin

    2. Upload rpd.

      ./data-model-cmd.sh uploadrpd -I AdvancedPlanning.rpd -W {rpd password} -U {OBIEE user} -P {OBIEE password} -SI ssi -N 9502

      For example, ./data-model-cmd.sh uploadrpd -I AdvancedPlanning_ma1yd226_SSO.rpd -W welcome1 -U weblogic -P weblogic1 -SI ssi -N 9502

  6. Do not refresh GUIDs.

    User names replace GUIDs. Users authenticate by user ID and have the access permissions associated with their user ID. When a user leaves the system, your administrator must completely remove their user ID from Oracle Business Intelligence.

    See Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition 12.2.1.1.0 > User GUIDs Removed.

Loading Foreign Language Files

  1. Unzip the language file, for example, apcc-obiee-ja.zip, to a temp directory. This generates the directory apcc.

  2. Confirm that your environment setting is correct to use the TransX utility.

    See XML Developer's Kit Programmer's Guide, Using the TransX Utility,.

    For more information about Java technologies, tips for developing in the Java programming language, and various ways you can leverage the Java platform, see the New to Java Programming Center, Get Started.

    Perform either Option #1 from your database machine with XDK installed or Option #2 from your Windows client.

    Option #1 (from your database machine with XDK installed ):

    1. Set ORACLE_HOME to the database ORACLE_HOME.

    2. Set CLASSPATH and export.

          CLASSPATH=$ORACLE_HOME/lib/xmlparserv2.jar:
    $ORACLE_HOME/lib/xschema.jar:
    $ORACLE_HOME/lib/xsu12.jar:
    $ORACLE_HOME/lib/oraclexsql.jar:
    $ORACLE_HOME/lib/classgen.jar:
    $ORACLE_HOME/lib/transx.zip:
    $ORACLE_HOME/jdbc/lib/ojdbc6dms.jar:
    $ORACLE_HOME/jdbc/lib/ojdbc6.jar:
    $ORACLE_HOME/rdbms/jlib/servlet.jar:
    $ORACLE_HOME/rdbms/jlib/xdb.jar:
    $ORACLE_HOME/oc4j/lib/dms.jar
   export CLASSPATH

    3. Set CLASSPATHJ and export.

          CLASSPATHJ=$ORACLE_HOME/jdbc/lib/ojdbc6_g.jar
    export CLASSPATHJ

    4. Set JAVA_HOME and export.

          JAVA_HOME=$ORACLE_HOME/jdk
    export JAVA_HOME

    Option #2 (from uour Windows client):

    1. On Windows and Windows XP clients, right-click My Computer and select Properties. On Windows 7 clients, right-click Computer and select Properties.

    2. On Windows and Windows XP clients, navigate to System Properties and select tab Advanced.. On Windows 7 clients, select Advanced System Settings.

    3. Click Environment Variables to set CLASSPATH, CLASSPATHJ, JAVA_HOME, ORACLE_HOME, and other variables.

    4. Set ORACLE_HOME.

            set ORACLE_HOME=D:\Oracle\Database\Client\product\11.2.0\client_2

    5. Set CLASSPATH.

             set CLASSPATH=%ORACLE_HOME%\LIB\xmlparserv2.jar;
       %ORACLE_HOME%\LIB\xsu12.jar;
       %ORACLE_HOME%\LIB\oraclexsql.jar;
       %ORACLE_HOME%\LIB\transx.zip;
       %ORACLE_HOME%\jdbc\lib\classes12dms.jar;
       %ORACLE_HOME%\jdbc\lib\ojdbc5.jar;
       %ORACLE_HOME%\LIB\servlet.jar;
       %ORACLE_HOME%\RDBMS\jlib\xdb.jar;
       %CLASSPATH%

    6. Set CLASSPATHJ.

             set
CLASSPATHJ=C:\Apps\db\oracle102\jdbc\lib\classes12.zip;C:\Apps\db\oracle102\jdbc\lib\nls_charset12.jar

    7. Set JAVA_HOME.

             set JAVA_HOME=D:\jdk1.5.0_09

    Note: The path value setting is different due to different installation paths. Confirm that all .jar files are located in appropriate directories, or you receive errors while running the TransX utility. Confirm that the path values are on one line so that all the referenced directories add to the environment variables properly.

  3. Use TransX to upload the dlf file, for example, apcc_ja.dlf, to directory apcc\OracleBI\repository. Provide username, password, and database connection SID.

    transx "hostname:port:sid" username password filename

    For example, \transx "rws60147rems:1524:mz1dv220" apps apps d:\apcc\OracleBI\repository\apcc_ja.dlf.

  4. Verify the seeding data is correctly uploaded in MSC_TRANSLATED_MESSAGE.

    select  lang_id, count(*)
from msc_translated_message
group by lang_id;

  5. SKIP THIS STEP FOR ENGLISH.

    1. Confirm directories on your OBIEE manchinecoreapplication_obips1\msgdb\l_ja\captions.

      Note: Confirm that the captions folder uses a lower case c.

    2. Copy files sopcaptions.xml, sppcaptions.xml, scacaptions.xml, and scrmcaptions.xml from your temp directory to either:.

      • If you are using OBIEE 11g: ORACLE_HOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_ja\cations

      • If you are using OBIEE 12c: ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/msgdb

      Note: Inside the XML files, confirm that the text tag is all upper case, for example, <TEXT>.

  6. Restart OBIEE services.

    If you are using OBIEE 11g:

    1. Open Fusion Middleware control using URL http://hostname.domain:port/em.

    2. Log in with the WebLogic user and password.

    3. In the left tree structure, select Business Intelligence > coreapplication > Overview tab.

    4. Click Restart to restart all services.

    5. Verify that all services are running.

    If you are using OBIEE 12c:

    1. cd ORACLE_HOME /user_projects/domains/bi/bitools/bin

    2. ./stop.sh

    3. ./start.sh

    4. ./status.sh

    5. Verify that all services are running.

Configuring Single Sign-on

Perform the subsequent procedures to configure Single Sign-On (SSO) for your APCC installation.

Note: Make sure your EBS and OBIEE servers are in the same domain and use the same security protocol.

Setting Up the OBIEE Profile

Set the URL for profikle option FND: Oracle Business Intelligence Suite EE base URL. The URL uses the following format:

http://machine:port

Add Session Cookie for Single Sign-On

Perform the following procedure to add a session cookie for Single Sign-On deployments.

  1. Stop all OBIEE services.

    1. cd ORACLE_HOME /user_projects/domains/bi/bitools/bin

    2. ./stop.sh

  2. Run the SQL statement below to get cookie_name. This will be the cookie_name for nameInSource param.

    select app_session.GET_ICX_COOKIE_NAME from dual

  3. Add the following to the file authenticationschemas.xml in the ORACLE_INSTANCE/bifoundation/web/display directory:

    For more information, refer to Integrating with Oracle E-Business Suite Security from the Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition, 12c (12.2.1) in the link below:

    http://docs.oracle.com/middleware/1221/biee/BIEIT/ebs_actions.htm#BIEIT1321

    Example 1:

    1. Find the following element:

      <AuthenticationSchema name="EBS-ICX"

    2. Locate the subelement RequestVariable source="cookie" and change the value of the nameInSource attribute from ICX_SESSION to the name of the EBS ICX authentication cookie prefix.

      Example 2:

      <RequestVariable source="cookie" type="auth" nameInSource="VIS" biVariableName="NQ_SESSION.ICX_SESSION_COOKIE" />

    3. Do not update the RequestVariable source="url" sub-element.

    4. In the same entry (RequestVariable source="cookie"), ensure that the value of the biVariableName attribute is the same as the value you entered as part of the connection script when you created the connection pool for the Oracle E-Business Suite database.

      See Section 9.1, Creating a Database Object and Connection Pool for the Oracle E-Business Suite Database for more information.

    5. Find the following element:

      <SchemaKeyVariable source="cookie"

    6. Change the value of the nameInSource attribute from ICX_SESSION to the name of the EBS ICX authentication cookie prefix (often VIS).

      Example:

      <SchemaKeyVariable source="cookie" nameInSource="VIS" forceValue="EBS-ICX" />

    7. Save and close the file.

  4. Perform the following to instanceconfig.xml file in ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obipsn directory:

    Example:

    1. Locate the Authentication element.

    2. Include EBS-ICX in the list of enabled schemas as shown below:

      <EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap,EBS-ICX</EnabledSchemas>

      Note: Ignore the comment in instanceconfig.xml that says this setting is centrally managed. EBS-ICX must be manually added to the EnabledSchemas element.

    3. Save and close the file.

    For more information, refer to Section 9.2.2, Updating instanceconfig.xml from the Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition, 12c (12.2.1).

  5. Start all OBIEE services.

    1. cd ORACLE_HOME /user_projects/domains/bi/bitools/bin

    2. ./stop.sh

    3. ./start.sh

    4. ./status.sh

    5. Verify that all services are running.

Troubleshooting

If TransX does not run due to missing classes, it is most likely that classpath is not set properly. Following sample shows setting CLASSPATH variable for Windows 11g client with XDK option:

   set ORACLE_HOME=D:\Oracle\Database\Client\product\11.2.0\client_2 

   set CLASSPATH=%ORACLE_HOME%\LIB\xmlparserv2.jar;
           %ORACLE_HOME%\LIB\xsu12.jar;
        %ORACLE_HOME%\LIB\oraclexsql.jar;
        %ORACLE_HOME%\LIB\transx.zip;
           %ORACLE_HOME%\jdbc\lib\classes12dms.jar;
        %ORACLE_HOME%\jdbc\lib\ojdbc5.jar;
   %ORACLE_HOME%\LIB\servlet.jar;
   %ORACLE_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 properly. Refer to My Oracle Support note 1074345.1.

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

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 & Edit.

  6. From the Domain Structure region, 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. When deployment to the managed server is complete, click the Release Configuration.

  12. If the state of deployment of mscspacesservlet is "Prepared", click Lock & Edit > Deployments, select deployment mscspacesservlet, click Start, click Servicing all requests, and then 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 Lock & Edit.

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

  3. Reselect 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 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 Add [+] icon, and 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 (for example, http://rws60212rems:8877/webcenter/) and log in.

  2. Create a blank group space, edit page, and 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

Perform these steps for all WebCenter Portal versions.

  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.

Perform these steps for WebCenter Portal versions below version 11.1.1.7.

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

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

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

Perform these steps for WebCenter Portal versions 11.1.1.7 and higher.

  1. Click Administration.

  2. Navigate to tab Portal Templates.

  3. Select option Import, browse for file msc_apcc_gs_template.ear, and import it.

Perform these steps for all WebCenter Portal versions.

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

  2. Log in to the WebCenter Spaces URL.

  3. Click Group Spaces.

  4. Click Create Group Space.

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

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

  7. Click Group Space Name tab.

  8. Navigate to Setting > Custom Attributes.

  9. Select custom attribute FND_OBIEE_URL.

  10. Navigate to Actions, and select Edit Attribute.

  11. Enter your OBIEE URL.

    Example:

    http://adc60069fems.us.oracle.com:9799/

  12. Click OK.

  13. Select custom attribute APPS_SERVLET_AGENT.

  14. Navigate to Actions, and select Edit Attribute.

  15. Enter Apps Servlet URL.

    Example:

    http://rws60147rems.us.oracle.com:8034/OA_HTML

  16. Click OK.

  17. Select custom attribute MSC_SCN_SERVICE_ENDPOINT.

  18. Navigate to Actions, and select Edit Attribute.

  19. Enter the BPM Worklist URL.

    Example:

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

  20. Click OK.

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

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

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

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

  25. Click Save. This creates the template.

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

To deploy and configure SOA BPEL flows, if you are integrating with SOA Suite:

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

  2. Select responsibility Advanced Planning Scenario Manager.

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