This chapter covers the following topics:
This section is about setting up Advanced Planning Command Center (APCC) reports and dashboards.
Before performing Advanced Planning Command Center Planning (APCC) installation and setup procedures, verify these application prerequisites:
If you plan to integrate Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle E-Business Suite (EBS) using single sign-on (SSO), your EBS and OBIEE servers must be in the same domain and use the same security protocol.
For Release ... | Install ... |
---|---|
EBS 12.2.2 | Oracle Business Intelligence Enterprise Edition 11 (OBIEE 11.1.1.6.0) |
EBS 12.2.3 | Oracle Business Intelligence Enterprise Edition 11 (OBIEE 11.1.1.6.0) |
EBS 12.2.4 | Oracle Business Intelligence Enterprise Edition 11 (OBIEE 11.1.1.7.0) |
VCP 12.2.4.1 | Oracle Business Intelligence Enterprise Edition 11 (OBIEE 11.1.1.9.0). APCC is certified with OBIEE 11.1.1.9.0. Refer to My Oracle Support, Document 2010017.1, OBIEE 11g: OBIEE 11.1.1.9.0 is Available for Download, for information on applying patch set updates. |
VCP 12.2.5.1 | Oracle Business Intelligence Enterprise Edition 11 (OBIEE 11.1.1.9.0). APCC is certified with OBIEE 11.1.1.9.0. Refer to My Oracle Support, Document 2010017.1, OBIEE 11g: OBIEE 11.1.1.9.0 is Available for Download, for information on applying patch set updates. |
EBS 12.2.6 | Oracle Business Intelligence Enterprise Edition 12c (OBIEE 12.2.1.1) |
Copy files mscrpd.zip and mscwebcat.zip to a temporary directory. You will place them in directory $MSC_TOP/patch/115/obiee , .
For WebCenter and SOA BPEL flows, see Using WebCenter for APCC .
Set the ORACLE_HOME environment variable to the directory where you have installed either
OBIEE 11g, for example, export ORACLE_HOME=/u01/oracle/OBIEE11g
OBIEE 12c, for example, export ORACLE_HOME=/u01/oracle/OBIEE12c
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))).
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:
Unzip mscwebcat.zip to the OBIEE server ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/.
Unzip mscrpd.zip and place file AdvancedPlanning.rpd in a temporary location.
Open Fusion Middleware control using URL http://hostname.domain:port/em.and:
Log in with the WebLogic user and password.
In left tree structure, select Business Intelligence > coreapplication > tab Overview.
Click Stop. All services stop.
Remain in the Fusion Middleware control and:
In left tree structure, select Business Intelligence > coreapplication > tab Deployment > tab Repository.
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.
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.
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:
Enable Connection Scripts for MSC_Conn and MSC_INIT_Conn.
Set the translations initialization variables:
Navigate to Manage > Variables > Session > Initialization Blocks.
Enable Manage Translation and Set Translation.
Disable Set Translations without SSO.
Save your changes.
If you are not setting up a single sign-on environment:
Disable Connection Scripts for MSC_Conn and MSC_INIT_Conn.
Set the translations initialization variables:
Navigate to Manage > Variables > Session > Initialization Blocks.
Disable Manage Translation and Set Translation.
Enable Set Translations without SSO.
Save your changes.
Return to the Fusion Middleware control using URL http://hostname.domain:port/em.and:
Log in with the WebLogic user and password.
In left tree structure, select Business Intelligence > coreapplication > tab Deployment > tab Repository.
Navigate to section upload BI Server Repository.
Browse to its temporary location and select AdvancedPlanning.rpd.
Enter the password.
Click Apply.
Click Activate Changes at top of page.
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:
Unzip mscwebcat.zip to the OBIEE server ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content.
Unzip mscrpd.zip and place file AdvancedPlanning.rpd in a temporary location.
Stop services.
cd ORACLE_HOME /user_projects/domains/bi/bitools/bin
./stop.sh
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:
Enable Connection Scripts for MSC_Conn and MSC_INIT_Conn.
Set the translations initialization variables:
Navigate to Manage > Variables > Session > Initialization Blocks.
Enable Manage Translation and Set Translation.
Disable Set Translations without SSO.
Save your changes.
If you are not setting up a single sign-on environment:
Disable Connection Scripts for MSC_Conn and MSC_INIT_Conn.
Set the translations initialization variables:
Navigate to Manage > Variables > Session > Initialization Blocks.
Disable Manage Translation and Set Translation.
Enable Set Translations without SSO.
Save your changes.
Perform file upload
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
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
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.
Unzip the language file, for example, apcc-obiee-ja.zip, to a temp directory. This generates the directory apcc.
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 ):
Set ORACLE_HOME to the database ORACLE_HOME.
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
Set CLASSPATHJ and export.
CLASSPATHJ=$ORACLE_HOME/jdbc/lib/ojdbc6_g.jar export CLASSPATHJ
Set JAVA_HOME and export.
JAVA_HOME=$ORACLE_HOME/jdk export JAVA_HOME
Option #2 (from uour Windows client):
On Windows and Windows XP clients, right-click My Computer and select Properties. On Windows 7 clients, right-click Computer and select Properties.
On Windows and Windows XP clients, navigate to System Properties and select tab Advanced.. On Windows 7 clients, select Advanced System Settings.
Click Environment Variables to set CLASSPATH, CLASSPATHJ, JAVA_HOME, ORACLE_HOME, and other variables.
Set ORACLE_HOME.
set ORACLE_HOME=D:\Oracle\Database\Client\product\11.2.0\client_2
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%
Set CLASSPATHJ.
set CLASSPATHJ=C:\Apps\db\oracle102\jdbc\lib\classes12.zip;C:\Apps\db\oracle102\jdbc\lib\nls_charset12.jar
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.
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.
Verify the seeding data is correctly uploaded in MSC_TRANSLATED_MESSAGE.
select lang_id, count(*) from msc_translated_message group by lang_id;
SKIP THIS STEP FOR ENGLISH.
Confirm directories on your OBIEE manchinecoreapplication_obips1\msgdb\l_ja\captions.
Note: Confirm that the captions folder uses a lower case c.
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>.
Restart OBIEE services.
If you are using OBIEE 11g:
Open Fusion Middleware control using URL http://hostname.domain:port/em.
Log in with the WebLogic user and password.
In the left tree structure, select Business Intelligence > coreapplication > Overview tab.
Click Restart to restart all services.
Verify that all services are running.
If you are using OBIEE 12c:
cd ORACLE_HOME /user_projects/domains/bi/bitools/bin
./stop.sh
./start.sh
./status.sh
Verify that all services are running.
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.
Set the URL for profikle option FND: Oracle Business Intelligence Suite EE base URL. The URL uses the following format:
http://machine:port
Perform the following procedure to add a session cookie for Single Sign-On deployments.
Stop all OBIEE services.
cd ORACLE_HOME /user_projects/domains/bi/bitools/bin
./stop.sh
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
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:
Find the following element:
<AuthenticationSchema name="EBS-ICX"
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" />
Do not update the RequestVariable source="url" sub-element.
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.
Find the following element:
<SchemaKeyVariable source="cookie"
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" />
Save and close the file.
Perform the following to instanceconfig.xml file in ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obipsn directory:
Example:
Locate the Authentication element.
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.
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).
Start all OBIEE services.
cd ORACLE_HOME /user_projects/domains/bi/bitools/bin
./stop.sh
./start.sh
./status.sh
Verify that all services are running.
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.
This topic provides information about using WebCenter with APCC.
Verify that WebLogic/WebCenter/SOA components are installed properly. Refer to My Oracle Support note 1074345.1.
Verify UCM is installed and configured properly [optional].
To configure WebCenter for Oracle Advanced Planning Command Center perform the following:
Perform the procedures below to deploy and configure the spaces servlet.
Obtain file mscspacesservlet.ear from $MSC_TOP/patch/115/ear/mscspacesservlet.ear.
Copy it to your local directory in Linux Session.
Open the WebCenter Console for the WebCenter domain.
Log in to the WebCenter Console.
Click Lock & Edit.
From the Domain Structure region, click Deployments.
Click Install.
Click link upload your file(s).
Search for your EAR file in the deployment archive and select the EAR file to deploy.
Click Next, select Managed Server WLS_Spaces, deploy .ear file, and click Finish.
When deployment to the managed server is complete, click the Release Configuration.
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.
To generate Java keystore in the WebCenter instance, go to JDK_HOME/jdk/bin and open a command prompt.
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".
Connect to the WebCenter server using telnet.
Execute the following command:
cd /slot/ems2995/appmgr/Oracle/Middleware/user_projects/ domains/wc_domain/config/fmwconfig/
Copy producer.jks to this location.
Open jps-config.xml.
Change serviceInstance as follows:
serviceInstance name="keystore" provider="keystore.provider" location="./default-keystore.jks" to location="./producer.jks"
Run command wlst.
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.
Back up cwallet.sso.
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")
Restart the WebCenter servers.
Perform the following procedures to deploy and configure the BPM Tasklist.
Create a Directory and Set a Path
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
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;
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
Open wf_client_config.xml and provide your soa server URL for tagsserverURL and rootEndPointURL.
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
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;
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
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
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
Navigate to http://rws60212rems:7004/console/using weblogic/welcome1 and click Lock & Edit.
Click Deployments, select webcenter, click Stop, select option Force Stop Now, and answer Yes to the confirmation question.
Reselect webcenter, click Delete, and answer Yes to the confirmation question.
Select custom.webcenter.spaces, click Update, click Next, click Next, and click Finish.
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.
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.
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
Restart Managed Server WLS_Spaces.
Create a New View in Oracle BPM Worklist
Navigate to the BPM worklist [http://rws60212rems:8880/integration/worklistapp] and log in using admin credentials.
Click Add [+] icon from section Worklist Views.
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.
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
Click OK.
Test the Tasklist
Navigate to WebCenter (for example, http://rws60212rems:8877/webcenter/) and log in.
Create a blank group space, edit page, and click add content. The Catalog opens.
Click open on APCC Custom Folder, move to Task List, and click Add.
Verify that it is added to the Tasklist.
Perform these steps for all WebCenter Portal versions.
Get file msc_apcc_gs_template.ear from ARU.
Copy it to your local directory.
Open the WebCenter Spaces URL.
http://rws60212rems.us.oracle.com:8877/webcenter
Log in to the WebCenter Spaces URL.
Navigate to the WebCenter Administrator.
Perform these steps for WebCenter Portal versions below version 11.1.1.7.
Click the Manage Group Spaces and Group Space Templates. Manage Group Spaces opens.
Click the Templates subtab. The Manage Group Space Templates window opens.
Click the Import option. The Import Archive Name window opens.
Perform these steps for WebCenter Portal versions 11.1.1.7 and higher.
Click Administration.
Navigate to tab Portal Templates.
Select option Import, browse for file msc_apcc_gs_template.ear, and import it.
Perform these steps for all WebCenter Portal versions.
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.
Log in to the WebCenter Spaces URL.
Click Group Spaces.
Click Create Group Space.
Enter Group Space Name, enter Description, and select group space template name.
Click Create. This creates a group space with group space name given.
Click Group Space Name tab.
Navigate to Setting > Custom Attributes.
Select custom attribute FND_OBIEE_URL.
Navigate to Actions, and select Edit Attribute.
Enter your OBIEE URL.
Example:
http://adc60069fems.us.oracle.com:9799/
Click OK.
Select custom attribute APPS_SERVLET_AGENT.
Navigate to Actions, and select Edit Attribute.
Enter Apps Servlet URL.
Example:
http://rws60147rems.us.oracle.com:8034/OA_HTML
Click OK.
Select custom attribute MSC_SCN_SERVICE_ENDPOINT.
Navigate to Actions, and select Edit Attribute.
Enter the BPM Worklist URL.
Example:
http://rws60018rems.us.oracle.com:8880
Click OK.
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.
Navigate to the Setting tab, and then navigate to the General tab.
Click Save as Group Space Template. The Save as Group Space Template window opens.
Enter Template Name, enter Description, and check Publish.
Click Save. This creates the template.
Enter the template name in MSC: APCC Webcenter Group Space Template Profile.
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.
Open enterprise manager [http://host:port/em] and log in as administrator [weblogic/welcome1].
Expand Webcenter, expand Webcenter spaces, select webcenter (WLS Spaces), right-click Settings, and click Service Configuration.
Select External Applications.
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
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
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
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
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
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
Open WebCenter spaces [http://host:port/webcenter] and log in as administrator [weblogic/welcome1].
Navigate to the top menu, select the Administration, and click Integrate Existing Applications.
Expand Applications Node, select Scenarios, and click Edit. For each application, change Open Behavior to the Webcenter tab, and click OK.
To deploy and configure SOA BPEL flows, if you are integrating with SOA Suite:
11g: Refer to My Oracle Support Document 1584883.1: Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 11g
12c: Refer to My Oracle Support Document 1951625.1: Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 12c
Perform the procedure below to set up your profile options.
Navigate to your E-Business Suite environment.
Select responsibility System Administrator.
Navigate to Profiles > System.
Verify or set values for the profile options as displayed in the table below.
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=/spacesReplace 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:88808880 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 |
Perform the procedure below to compile the MscWCRedirect.jsp file.
Log in to the middle tier where $APPL_TOP resides as an appmgr user
Execute the following command:
cd $FND_TOP/patch/115/bin;
Compile and flush as follows:
perl ojspCompile.pl --compile -s 'MscWCRedirect.jsp' –flush
Restart the middle tier as follows:
cd $ADMIN_SCRIPTS_HOME; adoacorectl.sh stop; adoacorectl.sh start; adoacorectl.sh status;
Perform the procedure below to run the Planning Process Activities concurrent process.
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.
Select responsibility Advanced Planning Scenario Manager.
Run concurrent process Planning Process Activities concurrent process. This populates the Oracle 11g BPEL flows into the MSC tables.
Perform the procedure below to change the WebCenter application name.
Log in to WebCenter using administrator.
Click the Administration link at the top of the page.
Select the General tab.
Change Application Name to 'Value Chain Planning".
Click Apply.