This chapter covers the following topics:
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:
Create new report in OBIEE Answers.
Expand Columns > Facts > Forecasting.
See reporting currency value columns are show correctly (such as "Budget (CAD)" etc.).
To set up RPD translated messages, it requires user to have the following:
Connection information of EBS database.
APPS access to EBS database.
XDK TransX tool (such as Oracle client with XDK option).
Stop all OBIEE services.
Unzip $MSC_TOP/patch/115/obiee/apcc-obiee-en.zip.
Locate appc_en.dlf file extracted.
Run following as APPS database user:
delete from msc_translated_message where lang_id='en'; commit;
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
Check msc_translated_message is populated from appc_en.dlf.
select count(*) from msc_translated_message where lang_id='en';
Start all OBIEE services.
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.
This topic provides information about using Webcenter with APCC.
Verify that weblogic/webcenter/soa components are installed by following the My Oracle Support note 1074345.1.
Verify UCM is installed and configured properly [optional].
Verify that VCP 12.1.3 patch [9482453:R12.SCP_PF.B] or later is installed.
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 and Edit > Goto Domain Structure.
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.
After this finishes deployment to the managed server, click the Release Configuration.
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.
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 button Lock & Edit.
Click Deployments, select webcenter, click Stop, select option Force Stop Now, and answer Yes to the confirmation question.
Re-select 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 the 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 the Add [+] icon, 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 [http://rws60212rems:8877/webcenter/] and log in.
Create a blank group space, edit page, 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.
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.
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.
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.
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.
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.
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.
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.
You can deploy and configure SOA BPEL flows using the one of the options below.
Option A: BPEL Deployment for EBS 12.1.3
Uptake 9499809:R12.TXK.B.
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.
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
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.
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.
Deploy msc_ws_bpelprocess_ws.ear (from $MSC_TOP/patch/115/ear/soa11j) under <SOA_DOMAIN>selecting Application Deployments, Context root - MSC-WS-BPELSeedUtil
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.
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:
sca_check_Dematra_Workflow_Process_Status.jar
sca_checkProcessStatus.jar
sca_Approve_Consensus_Demand_Process.jar
sca_ASCP_Collections_Process.jar
sca_Demantra_Collections_Process.jar
sca_Upload_Forecast_Process.jar
sca_Run_Supply_Plan_Process.jar
sca_Review_Supply_Plan_Process.jar
sca_Review_Process.jar
sca_Forecast_Inventory_SupplyPlan_Process.jar
sca_Sales_And_Operations_Planning_Process.jar
sca_MscReceiveUpdateFromOtm.jar
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.
Run the Planning Process Activities concurrent process.
Log in to http://rws60018rems.us.oracle.com:7004/em using the WebLogic admin user.
Navigate to SOA > soa-infra.
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.