This chapter discusses how to configure and deploy the Oracle Project Portfolio Management Integration Pack for Primavera P6 and JD Edwards EnterpriseOne (Project Portfolio Management: Primavera P6-JDE E1 PIP).
This chapter includes the following sections:
Configuring and Deploying the Project Portfolio Management: Primavera P6 - JDE E1 PIP
Undeploying the Project Portfolio Mgmt: Primavera P6 - JDE E1 PIP
The DCW screens prompt you to enter the data required for successful configuration of the Project Portfolio Management: Primavera P6 - JDE E1 PIP. Enter the details of the Project Portfolio Management: Primavera P6 - JDE E1 PIP screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.
All artifacts associated with the PIP infrastructure components deploy to the PIP server. This screen contains the following fields:
Table 33-1 PIP Server Details Screen Fields
| Field | Description |
|---|---|
|
Admin Host Name |
Specifies where the admin server resides. This can be a remote server or the same system where the AIA Pre-Built Integrations Installer is launched. Example: The Admin Host Name is _________________________________ |
|
Admin Port |
This is the port number on which the Weblogic Admin server is started. To find this value contact the WebLogic administrator. Example: The Admin Port is _____________________________________ |
|
Domain Name |
This is WebLogic server domain corresponding to the Admin Server. Example: The Domain Name is _______________________________ |
|
Admin User |
This value is the WebLogic admin user name. To find this value contact your WebLogic administrator. The Admin User is __________________________________ |
|
Admin Password |
This value is the WebLogic admin password. To find this value contact your WebLogic administrator. The password is _____________________________________ |
|
Managed Server |
After you enter the Admin Host Name, Admin Port and Admin User, this field populates with managed servers for the domain. Select the managed server from the list. If you are deploying the PIP to a SOA cluster, you should select the cluster name in this field. The Managed Server is _______________________________ |
|
Managed Port |
This field is automatically updated after you select the managed server. If you have configured a SOA Cluster, the SOA Cluster port appears in the list. |
Use this screen to enter details related to your JD Edwards EnterpriseOne business services.
The screen contains the following fields:
Table 33-2 JD Edwards EnterpriseOne Business Services Screen Fields
| Field | Description |
|---|---|
|
Web Services Platform |
This value is the web services platform that is used by EnterpriseOne. Valid platforms include Oracle WebLogic Server (WLS) and WebSphere Application Server (WAS). This value can be WLS or WAS. Select the appropriate platform from the menu. Example: Web Services Platform is ____________________________ |
|
Web Service Server URL |
This value is the location of the EnterpriseOne business service server. This value should contain the entire path, including the trailing slash, but not contain the name of the particular web service. Example: Web Service URL is _________________________________ |
|
Environment |
This is the environment that the integration proxy user accesses during sign on. To find this value, contact your administrator. Example: Environment is _________________________________ |
Table 33-3 Primavera P6 Server Details Screen Fields
| Field | Description |
|---|---|
|
P6 Webservice host url |
This value is the url of the P6 Webservice host, and must contain either http:// or https:// as part of the url." Example: P6 Webservice host url is ____________________________ |
|
P6 Webservice port |
This value is the P6 Webservice port number. To find this value, contact your administrator. Example: P6 Webservice port is ______________________ |
|
Username |
This value is the user name of a P6 user with rights to all of the operations that are supported by the AIA integration effort. To find this value, contact your administrator. Primavera P6 Username is _____________________ |
|
Password |
This value is the password that is associated with the Primavera P6 user name that you specify. The user name associated with this password should have access to P6 web services. To find this value, contact your administrator. Primavera P6 Password is ___________________ |
|
Currency Code |
This value is the currency code in which the P6 server is currently operating. To find this value, contact your administrator. Currency Code is ______________________ |
This section discusses the PIP configuration and deployment process. There are two steps:
Configure your PIP using the deployment DCW.
Deploy the PIP to the Fusion Middleware server.
The screens that appear prompt you to enter the data that is required for successful configuration of the Project Portfolio Management: Primavera P6 - JDE E1 PIP. Keep the completed worksheets of the Project Portfolio Management: Primavera P6 - JDE E1 PIP screens ready before you launch the DCW.
Note:
If you are harvesting content to OER, perform the first three steps. Else start from step 4.To configure the Project Portfolio Management: Primavera P6 - JDE E1 PIP:
Navigate to /slot/emsxxxx/oracle/Middleware/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.
Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".
Restart the server.
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.
At the command line prompt, enter chmod 777 aiaconf.sh to change the mode of file so that it is executable.
Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh for Linux based systems and aiaconfig.bat for Microsoft Windows.
This launches the AIA DCW.
Click Next.
Select the Project Portfolio Management: Primavera P6 - JDE E1 PIP
Click Next.
To specify PIP Server details:
Enter information related to your PIP server in the PIP Server Details screen.
Click Next.
To specify JD Edwards EnterpriseOne Business Services Information details:
Enter information about your JD Edwards EnterpriseOne installation on the EnterpriseOne Business Services Information screen.
Click Next.
To specify Primavera P6 server details:
Enter information about your Primavera P6 installation in the Primavera P6 Server Details screen.
Click Next.
Review the configuration information on the Configuration Summary screen.
Note:
If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the PIP. You can configure using the steps described in Configuring using the Response File. Click Save Response File and save the response file with the name and location of your choice.
Click Configure to accept the configuration.
The system displays progress of the configuration in the Configuration Progress screen.
The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in Configuration Progress screen.
When the configuration process completes without errors, the AIA DCW displays the Configuration Complete screen.
Click Finish to close the DCW.
To configure using the response file:
Open the response file.
When you create a response file through OUI, passwords get stored as <SECURE>.
Replace the password fields with actual passwords in the response file.
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.
Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name> for Linux based systems and aiaconfig.bat <Response File Location and Name> for Microsoft Windows.
To deploy the PIP to Fusion Middleware server:
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.
Run the command for your platform.
Note:
When you copy and paste the command in the command line, ensure that there is space between .xml and -. Ensure that there is space between these two when you run undeployment command too.Table 33-4 Deployment Commands for the Project Portfolio Management: Primavera P6 - JDE E1 PIP
| Platform | Deployment Command |
|---|---|
|
Linux Solaris SPARC IBM AIX Based Systems. HP-UX |
ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DDeploymentPlan=<AIA_HOME>/pips/JDEE1toP6EPPM/DeploymentPlans/JDEE1toP6EPPMDP.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml -DDeploymentPolicyFile=<AIA_HOME>/pips/JDEE1toP6EPPM/DeploymentPlans/JDEE1toP6EPPMConditionalPolicy.xml -l <AIA_HOME>/pips/JDEE1toP6EPPM/DeploymentPlans/JDEE1toP6EPPMDP.log |
|
Microsoft Windows |
ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DDeploymentPlan=<AIA_HOME>\pips\JDEE1toP6EPPM\DeploymentPlans\JDEE1toP6EPPMDP.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml -DDeploymentPolicyFile=<AIA_HOME>\pips\JDEE1toP6EPPM\DeploymentPlans\JDEE1toP6EPPMConditionalPolicy.xml -l <AIA_HOME>\pips\JDEE1toP6EPPM\DeploymentPlans\JDEE1toP6EPPMDP.log |
Note:
In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the PIPs are not displayed.Review the log file in the location specified in the command to verify successful deployment.
Oracle AIA ships artifacts in AIA Lifecycle Workbench which can be used in your integrations. These artifacts are created using FMW technologies such as BPEL and Mediator and are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator, AIA Deployment Driver (ADD). These are called native artifacts and they include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These artifacts can be modified or new natively supported artifacts can be added using the AIA Lifecyle Workbench and a BOM.xml file can be generated.
AIA PIP development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require artifacts such as, Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.
For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".
If you have installed the 2.5 release of this PIP, and are now installing the 11.5 release, you must migrate data from 2.5 to 11.5. PIP specific data is stored in the projectTemplates.xml file in the config directory of your 2.5 installation.
Ignore this task if this is the fresh installation of the PIP.
Copy the projectTemplates.xml file from 2.5 installation directory. For example: <aia_2.5_home>\config\
Paste the file in 11.5 installation directory. For example: <aia_11.5_home>\config\
Note:
The locations specified here is just an example. The actual location of the config directory is specified by the following properties in the AIAconfigurationproperties.xml file:
<ServiceConfigurationserviceName="{http://xmlns.oracle.com/ABCSImpl/P6EPPM/Core/ProjectTemplateUtility/V1}ProjectTemplateUtility">
…
<Propertyname="TemplateFileLocation">/slot/ems1099/oracle/AIAHome/config</Property>
…
</ServiceConfiguration>
For more information about configuration properties, see the Oracle Project Portfolio Management Integration Pack for Primavera P6 and JD Edwards EnterpriseOne Implementation Guide, "Implementing the Project Management:Primavera - JDE E1 PIP", Setting Configuration Properties.
To verify the Project Portfolio Management: Primavera P6 - JDE E1 PIP deployment:
Open the log files from the following location and look for warnings and error messages:
For Linux, Solaris SPARC, HP-UX and IBM AIX Based Systems: Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify that the PIP is successfully installed.
For Microsoft Windows: Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify that the PIP is successfully installed.
From Enterprise Manager 11g console, expand the SOA folder, then expand the appropriate SOA server, and verify that these items appear under Default:
ProjectEBSV1
ProjectExtractJDEE1Consumer
ProjectLabExpItemListEBSV1
ProjectListP6EPPMJMSConsumer
ProjectListSplitter
ProjectResourceRateScheduleEBSV1
ProjectResourceSetEBSV1
ProjectTemplateUtility
ResourceAvailabilityCalendarEBSV1
ResourceAvailabilityCalendarExtractJDEE1Consume
ResourceRateExtractJDEE1Consumer
ResourceSetExtractJDEE1Consumer
SyncProjectListJDEE1ProvABCSImpl
SyncProjectListJDEE1ReqABCSImpl
SyncProjectListP6EPPMProvABCSImpl
SyncProjectListP6EPPMReqABCSImpl
SyncProjectResourceRateScheduleListJDEE1ReqABCSImpl
SyncProjectResourceRateScheduleListP6EPPMProvABCSImpl
SyncProjectResourceSetListJDEE1ReqABCSImpl
SyncProjectResourceSetListP6EPPMProvABCSImpl
SyncProjLabExpendItemListJDEE1ProvABCSImpl
SyncProjLabExpendItemListP6EPPMReqABCSImpl
SyncResourceAvailabilityCalendarListJDEE1ReqABCSImpl
SyncResourceAvailabiltiyCalendarListP6EPPMProvABCSImpl
If you have selected Websphere Application Server (WAS) for your JD Edwards EnterpriseOne web services platform, you should also verify that these items appear under default:
BatchTimeSheetJDEE1WASConnector
ProjectJDEE1WASConnector
When the PIP installation is complete, Oracle recommends that you restart the admin and soa servers. If you are using the file adaptor within the ResourceRateExtractJDEE1Consumer, this restart is required.
All SOA composites are protected by Global Policies provided by Foundation Pack as defined in the Security section of the Developer Guide. Additionally individual services for this PIP have locally attached security policies.
To validate locally attached security policies:
Log in to Oracle Enterprise Manager Fusion Middleware Control.
Navigate to WebLogic Domain, soa_domain, Web Services, Policies.
Verify Service Policy attachment.
Find the service policy in the list of policies.
Click the number in Attachment Count column.
This opens Usage Analysis screen.
Change the Subject Type list box to SOA Service.
Validate that all the composites are listed with local attachment to this service policy.
Verify Client Policy attachment
Navigate back to Policies screen and find the client policy
Click the number in Attachment Count column.
This opens Usage Analysis screen.
Change the Subject Type list box to SOA Reference.
Validate that all the composites are listed with local attachment to this client policy and attached to the correct references.
Table 33-5 Service Policy Attachments for Project Portfolio Mgmt: Primavera P6 - JDE E1 PIP
| Composite | Service Policy |
|---|---|
|
ProjectTemplateUtility |
oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON |
|
ProjectJDEE1WASConnector (WAS Install Only) |
oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON |
|
ProjectSplitter |
oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON |
|
BatchTimeSheetJDEE1WASConnector (WAS Install Only) |
oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON |
Table 33-6 Wss User Name Client Policy Attachments for Project Portfolio Mgmt: Primavera P6 - JDE E1 PIP
| Composite | Reference | Client Policy |
|---|---|---|
|
ProjectJDEE1WASConnector (WAS Install Only) |
ProjectManagerWAS |
oracle/wss_username_token_client_policy |
|
BatchTimeSheetJDEE1WASConnector (WAS Install Only) |
BatchTimeSheetWAS |
oracle/wss_username_token_client_policy |
|
SyncProjectListJDEE1ProvABCSImpl |
ProjectManager |
oracle/wss_username_token_client_policy |
|
SyncProjLabExpendItemListJDEE1ProvABCSImpl |
BatchTimeSheetManager |
oracle/wss_username_token_client_policy |
Table 33-7 No Authentication Client Policy Attachments for Project Portfolio Mgmt: Primavera P6 - JDE E1 PIP
| Composite | Reference | Client Policy |
|---|---|---|
|
SyncProjectListP6EPPMProvABCSImpl |
SyncService |
oracle/no_authentication_client_policy |
|
SyncProjectListP6EPPMProvABCSImpl |
EPSService |
oracle/no_authentication_client_policy |
|
SyncProjectListP6EPPMReqABCSImpl |
SyncService |
oracle/no_authentication_client_policy |
|
SyncProjectListP6EPPMReqABCSImpl |
UDFTypeService |
oracle/no_authentication_client_policy |
|
SyncProjLabExpendItemListP6EPPMReqABCSImpl |
TimesheetService |
oracle/no_authentication_client_policy |
|
SyncProjLabExpendItemListP6EPPMReqABCSImpl |
ActivityService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
ExpenseCategoryService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
UnitOfMeasureService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
WBSCategoryService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
RoleService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
ResourceRateService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceSetListP6EPPMProvABCSImpl |
ResourceService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceRateScheduleListP6EPPMProvABCSImpl |
ResourceRateService |
oracle/no_authentication_client_policy |
|
SyncProjectResourceRateScheduleListP6EPPMProvABCSImpl |
RoleRateService |
oracle/no_authentication_client_policy |
|
SyncResourceAvailabilityCalendarListP6EPPMProvABCSImpl |
CalendarService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
UDFValueService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
SyncService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
ProjectCodeAssignmentService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
ProjectCodeTypeService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
UDFTypeService |
oracle/no_authentication_client_policy |
|
ProjectTemplateUtility |
ProjectCodeService |
oracle/no_authentication_client_policy |
For more information about security validation, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Working with Security."
For PIP implementation, see Oracle Project Portfolio Management Integration Pack for Primavera P6 and JD Edwards EnterpriseOne Implementation Guide.
To undeploy the PIP from Fusion Middleware Server:
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.
Run the command for your platform.
Table 33-8 Undeployment Command for the Project Portfolio Mgmt: Primavera P6 - JDE E1 PIP
| Platform | Undeployment Command |
|---|---|
|
Linux Solaris SPARC IBM AIX Based Systems. HP-UX |
ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>/pips/JDEE1toP6EPPM/DeploymentPlans/JDEE1toP6EPPMUndeployDP.xml -l <AIA_HOME>/pips/JDEE1toP6EPPM/DeploymentPlans/JDEE1toP6EPPMUndeployDP.log |
|
Microsoft Windows |
ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>\pips\JDEE1toP6EPPM\DeploymentPlans\JDEE1toP6EPPMUndeployDP.xml -l <AIA_HOME>\pips\JDEE1toP6EPPM\DeploymentPlans\JDEE1toP6EPPMUndeployDP.log |
Restart the SOA server.
Uninstall the PIP following the instructions in Chapter 36, "Uninstalling Oracle AIA".