Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations Release 11.4 Part Number E37608-03 |
|
|
PDF · Mobi · ePub |
This chapter discusses how to configure and deploy the Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite (LSP Driver Mgmt: OTM - EBS PIP).
This chapter includes the following sections:
Section 32.2, "Configuring and Deploying the LSP Driver Mgmt: OTM - EBS PIP"
Section 32.5, "Undeploying the LSP Driver Mgmt: OTM - EBS PIP"
The DCW screens prompt you to enter the data required for successful configuration of the LSP Driver Mgmt: OTM - EBS PIP. Enter the details of the LSP Driver Mgmt: OTM - EBS 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 32-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 Oracle E-Business Suite server instance.
The screen contains the following fields:
Table 32-2 Oracle E-Business Suite Server Details Screen Fields
Field | Description |
---|---|
E-Business Suite Host Name |
Specifies the fully qualified system name of the Oracle E-Business Suite application. Example: E-Business Suite Host Name is ___________________________ |
E-Business Suite Port |
This value is the Oracle E-Business Suite application port. To find this value, contact your administrator. Example: E-Business Suite Port is _______________________________ |
E-Business Suite User Name |
To find this value, contact your administrator. E-Business Suite User Name is ___________________________ |
E-Business Suite Password |
To find this value, contact your administrator. E-Business Suite Password is ____________________________ |
Workflow Business Event System Name |
This is the Workflow Business Event System Name of E-Business Suite Server. For example: Workflow Business Event System Name is __________________ |
E-Business suite version |
This is the version of the E-Business Suite Application. Valid value is |
Use this screen to enter details related to your Oracle E-Business Suite database instance.
The screen contains the following fields:
Table 32-3 Oracle E-Business Suite Database Details Screen Fields
Field | Description |
---|---|
E-Business Suite Database Host |
Specifies the system name. To find this value, contact the database administrator. Example: E-Business Suite Database Host is ________________________ |
E-Business Suite Database Port |
To find this value, contact the database administrator. Example: E-Business Suite Database Port is _____________________ |
E-Business Suite Database Username |
To find this value, contact the database administrator. Example: E-Business Suite Database Username is ___________________ |
E-Business Suite Database Password |
To find this value, contact the database administrator. E-Business Suite Database Password is ___________________ |
E-Business Suite Database SID (System ID) |
To find this value, contact the database administrator. Example: E-Business Suite Database SID is ________________________ |
Database Schema |
To find this value, contact the database administrator. Example: Database Schema is __________________________________ Note: All the database credentials are used for creating the connection pool URL and data source URLs. |
Use this screen to enter details related to your OTM server instance.
The screen contains the following fields:
Table 32-4 Oracle OTM Server Details Screen Fields
Field | Description |
---|---|
OTM Host name |
Specifies the system name of the OTM application. For example: OTM Host name is _________________________________ |
OTM Http Port |
This value is the OTM Web Service port. For example: OTM Port is _________________________________ |
OTM User Name |
This is the user name for OTM application. To find the value, contact your administrator. OTM Username is _________________________________ |
OTM Password |
This is the password for OTM application. For example: OTM Password is ________________________________ |
OTM System Name |
This is the system name for the OTM application. To find the value, contact your administrator. For example: OTM System Name is __________________ |
OTM System Version |
This is the version of the OTM Application like 5.5,6.0. OTM System Version is ________________ |
Use this screen to enter details related to your OTM database instance.
The screen contains the following fields:
Table 32-5 Oracle OTM Database Details Screen Fields
Field | Description |
---|---|
OTM Database Host |
Specifies the system name. For example: OTM Database Host is ______________________________ |
OTM Database Port |
This is the Database port for OTM application. For example: OTM Database Port is ______________________________ |
OTM Database Username |
This is the Database user name for OTM application. For example: OTM Database Username is _______________________ |
OTM Database Password |
This is the password for Database Password user. For example: OTM Database Password is _________________________ |
OTM Database System ID (SID) |
This is the Database SID for OTM application. For example: OTM Database SID 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 LSP Driver Mgmt: OTM - EBS PIP. Keep the completed worksheets of the LSP Driver Mgmt: OTM - EBS 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 LSP Driver Mgmt: OTM - EBS PIP:
Navigate to <MiddleWare_HOME>/user_projects/domains/<soa_domain_name>/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.
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 LSP Driver Mgmt: OTM - EBS 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 Oracle E-Business Suite Server details:
Enter information about your E-Business Suite Server in the E-Business Suite Server Details screen.
Click Next.
To specify Oracle E-Business Suite Database details:
Enter information about your E-Business Suite Database in the E-Business Suite Database Details screen.
Click Next.
To specify Oracle OTM Server details:
Enter server information about Oracle OTM in the Oracle OTM Server Details screen.
Click Next.
To specify Oracle OTM Database details:
Enter information about your Oracle OTM Database in the Oracle OTM Database 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 Section 32.2.2, "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 32-6 Deployment Commands for the LSP Driver Mgmt: OTM - EBS PIP
Platform | Deployment Command |
---|---|
Linux Solaris SPARC IBM AIX Based Systems. HP-UX |
ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagementDP.xml -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagementSupplementaryDP.xml -DDeploymentPolicyFile=<AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagementConditionalPolicy.xml -l <AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagement.log |
Microsoft Windows |
ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagementDP.xml -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagementSupplementaryDP.xml -DDeploymentPolicyFile=<AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagementConditionalPolicy.xml -l <AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagement.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".
This section discusses post deployment configurations for LSP Driver Mgmt: OTM - EBS PIP. The section includes:
To configure time zone property:
Open <AIA_INSTANCE>/AIAMetaData/config/AIAConfigurationProperties.xml
Navigate to property EBIZ_01.SERVER_TIMEZONE under the module 'Ebiz'
Set it to appropriate value, for example PST or IST.
Possible values:
PST, IST and so on. (OR)
-07:00, +05:30 and so on.
Update MetaData.
Reload from the AIA page (http://< server name >: < port number >/AIA).
If you are migrating from an earlier version to 11.4, then ensure the following:
The last number value for the sequence DR_CAL_EVENT_ID created in "<AIA_INSTANCE>_AIA" database user in the 11.4 version should be set to the same value as in the 10g version. In 10g, this sequence is available in the "aia" database user. This can be done using the following commands:
Execute select dr_cal_event_id.nextval from Dual
in the 10g database.
Execute alter sequence dr_cal_event_id increment by <nextval from 10g>
in the 11g database
You can edit existing csf-key or create new csf-key and configure flows to use the modified/new csf-key.
To edit existing csf-key or create new csf-key:
Log in to Oracle Enterprise Manager Fusion Middleware Control (http://<server_host>:<server_port>/em).
Right click WebLogic Domain and navigate to <your_domain>, Security, and select Credentials.
Expand oracle.wsm.security and click OTM_DOMAIN.
Edit existing csf-key credentials or create new csf-key with new credentials.
To configure flows to use new csf-key:
Log in to Oracle Enterprise Manager Fusion Middleware Control (http://<server_host>:<server_port>/em).
Click the process name which is invoking OTM Webservice based on the flow.
Click the corresponding Reference under Services and References section. (use the security exceptions table in the Section 32.4.1, "Validating Security Policies" section to find the References)
Click the Policies and select oracle/wss_http_token_client_policy.
Update the csf-key value under Security Configuration Details tab and save the changes.
To verify the LSP Driver Mgmt: OTM - EBS 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.
Confirm that JMS Queues are created:
Log in to the WLS Console: http:// name>:<port number>/console/
Log in with the server admin user name. For access details, contact the system administrator
Navigate to Services, Messaging, JMS Modules, AIAJMSModule and verify that the following queue names exist.
AIA_EbizTrainingCalendarJMSQueue
AIA_EbizAbsenceCalendarJMSQueue
AIA_EbizWorkerJMSQueue
AIA_EbizLocationJMSQueue
Confirm that the LSP Driver Mgmt: OTM - EBS PIP services were installed.
Navigate to the Oracle Enterprise Manager Fusion Middleware Control (http://<server name>:<port number>/em/).
Log in with the server admin user name. For access details, contact the system administrator.
Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:
CalculateDriverIncentiveCompensationListEbizAdapter
CalculateDriverIncentiveCompensationListEbizProvABCSImpl
CalculateDriverIncentiveCompensationListLogisticsAQConsumer
CalculateDriverIncentiveCompensationListLogisticsReqABCSImpl
CreateAbsenceAttendanceEbizAdapter
CreateDelegateBookingEbizAdapter
CreateLocationListEbizAdapter
DeleteAbsenceAttendanceEbizAdapter
DeleteDelegateBookingEbizAdapter
LocationEBS
LocationResponseEBS
PayableInvoiceEBS
PayableInvoiceResponseEBS
ResourceCalendarEntryEBS
ResourceCalendarEntryResponseEBS
SyncAbsenceCalendarListEbizJMSConsumer
SyncAbsenceCalendarListEbizJMSProducer
SyncAbsenceCalendarListEbizReqABCSImpl
SyncAbsenceCalendarListInitialLoadDBAdapter
SyncAbsenceCalendarListProcess
SyncLocationListEbizGetABM
SyncLocationListEbizJMSConsumer
SyncLocationListEbizJMSProducer
SyncLocationListEbizReqABCSImpl
SyncLocationListInitialLoadDBAdapter
SyncLocationListLogisticsProvABCSImpl
SyncResourceCalendarEntryListLogisticsProvABCSImpl
SyncTrainingCalendarListEbizJMSConsumer
SyncTrainingCalendarListEbizJMSProducer
SyncTrainingCalendarListEbizReqABCSImpl
SyncTrainingCalendarListInitialLoadDBAdapter
SyncTrainingCalendarListProcess
SyncWorkerListBPELAggregator
SyncWorkerListEbizAggrEventConsumer
SyncWorkerListEbizEventAggregator
SyncWorkerListEbizGroupEventAdapter
SyncWorkerListEbizInitialLoad
SyncWorkerListEbizJMSConsumer
SyncWorkerListEbizJMSProducer
SyncWorkerListEbizReqABCSImpl
SyncWorkerListLogisticsProvABCSImpl
UpdateAbsenceAttendanceEbizAdapter
UpdateClassScheduleEbizAdapter
UpdateDelegateBookingEbizAdapter
UpdateLocationEbizAdapter
UpdateLocationListEbizAdapter
UpdateTrainingCenterandLocationEbizAdapter
WorkerEBS
WorkerResponseEBS
LSP Financial Mgmt: OTM - EBS PIP and LSP Driver Mgmt: OTM - EBS PIP use same PayableInvoiceEBS and PayableInvoiceResponseEBS.
When you install Fleet PIPs, if LSP Driver Mgmt: OTM - EBS PIP is installed after LSP Financial Mgmt: OTM - EBS PIP, routing rules pertaining to WorkInvoice flow of LSP Driver Mgmt: OTM - EBS PIP do not appear in Oracle Enterprise Manager Fusion Middleware Control for PayableInvoiceEBS and PayableInvoiceResponseEBS. In this case, routing rules pertaining to CalculateDriverIncentiveCompensationListEbizProvABCSImpl of WorkInvoice flow of LSP Driver Mgmt: OTM - EBS PIP have to be added manually to PayableInvoiceEBS and routing rules pertaining to CalculateDriverIncentiveCompensationListLogisticsReqABCSImpl of WorkInvoice flow of LSP Driver Mgmt: OTM - EBS PIP have to be added manually to PayableInvoiceResponseEBS and deployed on server.
For more information on manual deployment of routing rules, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Creating Routing Rules".
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.
Note:
The default csf-key for all the flows is OTM_DOMAIN. This is created in server automatically as a part of PIP installation.
Table 32-7 Service Policy Attachments for LSP Driver Mgmt: OTM - EBS PIP
Composite | Service | Service Policy |
---|---|---|
SyncLocationListLogisticsProvABCSImpl |
TransmissionReport |
oracle/wss_http_token_service_policy |
SyncResourceCalendarEntryListLogisticsProvABCSImpl |
TransmissionReport |
oracle/wss_http_token_service_policy |
SyncWorkerListLogisticsProvABCSImpl |
TransmissionReport |
oracle/wss_http_token_service_policy |
Table 32-8 Wss Http Token Client Policy Attachments for LSP Driver Mgmt: OTM - EBS PIP
Composite | Reference | Client Policy |
---|---|---|
CalculateDriverIncentiveCompensationListLogisticsReqABCSImpl |
LogisticsWebService |
oracle/wss_http_token_client_policy |
SyncLocationListLogisticsProvABCSImpl |
LogisticsWebService |
oracle/wss_http_token_client_policy |
SyncResourceCalendarEntryListLogisticsProvABCSImpl |
LogisticsWebService |
oracle/wss_http_token_client_policy |
SyncWorkerListLogisticsProvABCSImpl |
LogisticsWebService |
oracle/wss_http_token_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 Application Integration Architecture Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite 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 32-9 Undeployment Command for the LSP Driver Mgmt: OTM - EBS 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>/config/AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagementUndeployDP.xml -l <AIA_HOME>/pips/FleetDriverManagement/DeploymentPlans/FleetDriverManagementUndeployDP.log |
Microsoft Windows |
ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagementUndeployDP.xml -l <AIA_HOME>\pips\FleetDriverManagement\DeploymentPlans\FleetDriverManagementUndeployDP.log |
Restart the SOA server.
Uninstall the PIP following the instructions in Chapter 37, "Uninstalling Oracle AIA".