Gateway for primavera ebs, Exercises of Construction

Download Gateway for primavera ebs and more Exercises Construction in PDF only on Docsity!

GGaatteewwaayy EE--BBuussiinneessss SSuuiittee SSeettuupp GGuuiiddee ffoorr OOnn--PPrreemmiisseess

VVeerrssiioonn^1188

AAuugguusstt^22001188

• Overview
• Setting Up the Integration Environment
• Integration Installation Prerequisites
• Managing Personally Identifiable Information....................................................................................
• Post-Installation Tasks
  • Configuring Gateway Domain for P6 Event Notification for On-Premises
  • Enabling Encryption Between Gateway and P6 Web Services
  • Setting Up EBS Connectivity through Web Services
    • Extending EBS WebLogic Domain for Web Services Connectivity
  • Setting up EBS Connectivity through RMI.................................................................................
  • Configuring the Primavera Gateway User Interface
    • Configuring Gateway Settings
    • Adding an EBS Application Deployment Connection
    • Adding an EnterpriseTrack Deployment Connection
    • Adding or Editing a P6 Deployment Connection
    • Adding or Editing a Prime Deployment Connection
    • Adding or Editing a Unifier Deployment Connection
    • Copying Provider Deployments
• Gateway Setup and Data Transfer Process Flow
• Working with Data Dictionaries
• Features of Provider Data Dictionaries
• Editing Objects and Fields in Data Dictionaries
• Deleting Fields from Data Dictionaries
• Defining Field-Mapping Templates
• Adding or Editing Field-Mapping Templates
• Copying Field-Mapping Templates
• Deleting Field-Mapping Templates......................................................................................................
• Defining Business Flows
• Adding Business Flows.........................................................................................................................
• Copying Business Flows
• Using Business Flows Delivered in Gateway
• Connecting with P6 EPPM....................................................................................................................
  • Master Data Flow Type
    • Business Objects Supported in Master Data Flow
    • Field Mapping Templates for Master Data Business Objects..........................................
    • Setting Provider-Specific Parameters
  • Project Data Flow Type
    • Business Objects Supported in Project Data Flow
    • Field Mapping Templates for Project Data Business Objects Gateway E-Business Suite Setup Guide for On-Premises
    • Setting Provider- Specific Parameters
• Connecting with Instantis EnterpriseTrack
  • Project Data Flow Type
    • Business Objects Supported in Project Data Flow
    • Field Mapping Templates for Project Data Business Objects
    • Setting Provider-Specific Parameters
• Connecting with Oracle Prime Projects
  • Master Data Flow
    • Business Objects Supported in Master Data Flow
    • Field Mapping Templates for Master Data Business Objects..........................................
    • Setting Provider-Specific Parameters
  • Project Data Flow
    • Business Objects Supported in Project Data Flow
    • Field Mapping Templates for Project Data Business Objects
    • Setting Provider-Specific Parameters
• Connecting with Unifier
  • Master Data Flow Type
    • Business Objects Supported in Master Data Flow
    • Field-Mapping Template for Master Data Business Objects
    • Setting Provider-Specific Parameters
  • Project Data Flow Type
    • Business Objects Supported in Project Data Flow
    • Field-Mapping Templates for Project Data Business Objects
    • Setting Provider-Specific Parameters
• Defining Synchronizations
• Master Data Synchronization
• Project Data Synchronizations.............................................................................................................
• Adding Synchronization Jobs
• Copying Synchronizations
• Using Synchronizations Delivered in Gateway....................................................................................
• Transferring Data between Applications: Example
• Appendix A: About Flow Steps
• Define the Flow Steps in a Flow
  • Flow Sequence When Using Master Data
  • Flow Sequence When Using Project Data.................................................................................
  • Flow Sequence When Using the Compare Step
  • Flow Sequence When Using External Custom Step
  • Flow Sequence When Using Internal Custom Step for On-Premises
• Appendix B: Fields Supported in Mapping Templates
• Fields Supported with P6 EPPM
  • Send EBS Actuals to P6
  • Send EBS Actual Progress to P6
  • Send EBS Cost Code Details to P6 Activity Expense................................................................ Contents
  • Send EBS Cost Code Details to P6............................................................................................
  • Send EBS Financial Elements to P6 Expense Category...........................................................
  • Send EBS Financial Period to P6 Financial Period
  • Send EBS Resource to P6 Resource.........................................................................................
  • Send EBS Resource Rates to P6 Resource Rates
  • Send EBS Role to P6 Resource
  • Send EBS Role to P6 Role
  • Send EBS Role Rates to P6 Role Rates
  • Send P6 Actuals to EBS
  • Send P6 Actual Progress to EBS .............................................................................................
  • Send P6 Cost Code Details at Activity Expense to EBS .........................................................
  • Send P6 Cost Code Details to EBS..........................................................................................
  • Send P6 EXP Actuals to EBS....................................................................................................
  • Sync EBS and P6 Activity .........................................................................................................
  • Sync EBS and P6 Activity Cost Budget ....................................................................................
  • Sync EBS and P6 Activity Forecast Budget.............................................................................
  • Sync EBS and P6 Activity Forecast Revenue ..........................................................................
  • Sync EBS and P6 Activity Revenue Budget ............................................................................
  • Sync EBS and P6 Financial Assignment Cost Budgets ..........................................................
  • Sync EBS and P6 Financial Assignment Revenue Budget ....................................................
  • Sync EBS and P6 Financial Assignment Forecast Budget .....................................................
  • Sync EBS and P6 Financial Assignment Forecast Revenue ..................................................
  • Sync EBS and P6 Financial Element Assignments ................................................................
  • Sync EBS and P6 Activity Relationships .................................................................................
  • Sync EBS and P6 Assignment Cost Budget ............................................................................
  • Sync EBS and P6 Assignment Forecast Budget .....................................................................
  • Sync EBS and P6 Assignment Forecast Revenue ..................................................................
  • Sync EBS and P6 Assignment Revenue Budget.....................................................................
  • Sync EBS and P6 Resource Assignments...............................................................................
  • Sync EBS and P6 Project Cost Budget ....................................................................................
  • Sync EBS and P6 Project Revenue Budget ............................................................................
  • Sync EBS and P6 Project Forecast Budget.............................................................................
  • Sync EBS and P6 Projects .......................................................................................................
  • Sync EBS and P6 Project Forecast Revenue ..........................................................................
  • Sync EBS and P6 WBS .............................................................................................................
  • Sync EBS and P6 WBS Cost Budget........................................................................................
  • Sync EBS and P6 WBS Revenue Budget ................................................................................
  • Sync EBS and P6 WBS Forecast Budget ................................................................................
  • Sync EBS and P6 WBS Forecast Revenue..............................................................................
• Fields Supported with Prime Projects ...............................................................................................
  • Send EBS Resource to Prime Resource .................................................................................
  • Send EBS Role to Prime Role ..................................................................................................
  • Send EBS Leaf Tasks to Prime Activity ................................................................................... Gateway E-Business Suite Setup Guide for On-Premises
  • Send EBS Project Data to Prime .............................................................................................
  • Send EBS Relationships to Prime ...........................................................................................
  • Send EBS Resource Assignments to Prime ............................................................................
  • Send EBS Top/Middle Tasks to Prime WBS ...........................................................................
  • Send Prime Activities to EBS ...................................................................................................
  • Send Prime Project Data to EBS .............................................................................................
  • Send Prime Relationships to EBS ...........................................................................................
  • Send Prime Resource Assignments to EBS ............................................................................
  • Send Prime WBS Data to EBS .................................................................................................
• Fields Supported with Instantis EnterpriseTrack..............................................................................
  • EnterpriseTrack Project Mapping ............................................................................................
  • EnterpriseTrack ProjectFinance Mapping...............................................................................
  • EnterpriseTrack ProjectFinanceElement Mapping .................................................................
• Fields Supported with Unifier ............................................................................................................
  • Send EBS Resource to Unifier Role.........................................................................................
  • Send EBS ContractHeader to Unifier PurchaseOrder ............................................................
  • Send EBS ContractDetail to Unifier PurchaseOrderDetail .....................................................
  • Send EBS CostBudgetDetails to Unifier BudgetApprovalDetail ............................................
  • Send EBS CostBudgetDetails to Unifier BudgetChangeDetail ..............................................
  • Send EBS CostBudgetHeader to Unifier BudgetApproval......................................................
  • Send EBS CostBudgetHeader to Unifier BudgetChange .......................................................
  • Send EBS Expenditure Item Detail to Unifier Payment Detail ...............................................
  • Send EBS Expenditure Item Header to Unifier Payments .....................................................
  • Send EBS FundHeader to Unifier FundAppropriation ............................................................
  • Send EBS FundDetail to Unifier FundAppropriationDetail.....................................................
  • Send EBS InvoiceHeader to Unifier Invoice ............................................................................
  • Send EBS InvoiceDetails to Unifier InvoiceDetails .................................................................
  • Send EBS RevenueBudgetHeader to Unifier BudgetApproval ..............................................
  • Send EBS RevenueBudgetHeader to Unifier BudgetChange ................................................
  • Send RevenueBudgetDetails to Unifier BudgetApprovalDetails ...........................................
  • Send EBS RevenueBudgetDetail to Unifier BudgetChangeDetail .........................................
  • Sync EBS and Unifier Projects .................................................................................................
  • Sync EBS WBS to Unifier CBS..................................................................................................
  • Send Unifier BudgetApproval to EBS CostBudgetHeader......................................................
  • Send Unifier BudgetApproval to EBS RevenueBudgetHeader ..............................................
  • Send Unifier BudgetApprovalDetail to EBS CostBudgetDetail ..............................................
  • Send Unifier BudgetApprovalDetail to RevenueBudgetDetails .............................................
  • Send Unifier BudgetChange to EBS CostBudgetHeader .......................................................
  • Send Unifier BudgetChange to EBS RevenueBudgetHeader ................................................
  • Send Unifier BudgetChangeDetail to EBS CostBudgetDetail ................................................
  • Send Unifier BudgetChangeDetail to EBS RevenueBudgetDetail .........................................
  • Send Unifier CBS to EBS WBS .................................................................................................
  • Send Unifier Contract to EBS ContractHeader ....................................................................... Contents
  • Send Unifier ContractDetail to EBS ContractDetail................................................................
  • Send Unifier FundAppropriation to EBS FundHeader ............................................................
  • Send Unifier FundAppropriationDetail to EBS FundDetail.....................................................
  • Send Unifier Payments to EBS Expenditure (Miscellaneous) ................................................
  • Send UnifierPaymentDetail to EBS Expenditure (Miscellaneous) .........................................
  • Send Unifier PurchaseOrder to EBS ContractHeader ............................................................
  • Send Unifier PurchaseOrderDetail to EBS ContractDetail .....................................................
• Appendix C: Supported Object Mappings
• P6 Business Objects Supported in Gateway for Event Notifications ..............................................
• EBS Business Objects Supported in Gateway ..................................................................................
• Legal Notices

Gateway E-Business Suite Setup Guide for On-Premises The Unifier provider enables you to share master data and project data related to project, WBS, activities, resources, roles, budgets and expenditure items data with E-Business Suite.

 File Provider

The File provider enables you to send and receive data to and from a file in either XML or CSV file formats. For more details on setting up an integration with the File provider, refer to the Primavera Gateway File Provider Setup Guide. This guide describes:

 How to setup the integration environment to enable data exchange between EBS and the

Primavera applications listed above.

 The available business objects, field mapping templates, source and destination application

parameters, business flows, and synchronizations, delivered out-of-the-box in the Gateway user interface. IT professionals or administration personnel who are responsible for setting up the integration environment, and Gateway developers responsible for creating field-mapping templates, and business flows in the Gateway user interface for your organization should use this guide.

Setting Up the Integration Environment

This section describes the how to setup the integration environment in Gateway.

In This Section

Integration Installation Prerequisites ........................................................................ 11 Managing Personally Identifiable Information .......................................................... 13 Post-Installation Tasks ............................................................................................ 13

Integration Installation Prerequisites

To set up an environment for data exchange through Primavera Gateway, download, install, and configure the following applications: EBS Integration with Oracle Prime Projects To connect with Oracle Prime Projects, install:

 E-Business Suite application

 Install the database scripts for the EBS provider. For detailed instructions, see the

EBSProviderR <version_number> \db folder of the EBS provider software download.

 Oracle Prime Projects

 Primavera Gateway application selecting the Prime and EBS providers.

 To use flexible object mapping in Primavera Gateway which allows you to create custom

business object mappings in Gateway and customize the EBS provider, use the gateway configuration utility to install the CustomizationXRef.xml file located in the <Primavera_Gateway_home>\providers\ebsprovider\data\moredata folder. For more details on flexible object mapping, see the Primavera Gateway Provider Customization Guide and the Online Help. EBS Integration with EnterpriseTrack To connect with Instantis EnterpriseTrack, install:

 E-Business Suite application

 Install the database scripts for the EBS provider. For detailed instructions, see the

EBSProviderR <version_number> \db folder of the EBS provider software download.

 Oracle Instantis EnterpriseTrack

 Primavera Gateway application selecting the EnterpriseTrack and EBS providers

 To use flexible object mapping in Primavera Gateway which allows you to create custom

business object mappings in Gateway and customize the EBS provider, use the gateway configuration utility to install the CustomizationXRef.xml file located in the <Primavera_Gateway_home>\providers\ebsprovider\data\moredata folder. For more details on flexible object mapping, see the Primavera Gateway Provider Customization Guide and the Online Help.

Setting Up the Integration Environment

 To use flexible object mapping in Primavera Gateway which allows you to create custom

business object mappings in Gateway and customize the EBS provider, use the gateway configuration utility to install the CustomizationXRef.xml file located in the <Primavera_Gateway_home>\providers\ebsprovider\data\moredata folder. For more details on flexible object mapping, see the Primavera Gateway Provider Customization Guide and the Online Help. EBS Integration with File Provider To connect with Primavera Gateway's File provider, install:

 E-Business Suite application

 Primavera Gateway application selecting the File and EBS providers

For more details, see the Primavera Gateway File Provider Setup Guide.

Managing Personally Identifiable Information

Consent notices enable you to convey to your users how personally identifiable information (PII) is collected, processed, stored, and transmitted, along with details related to applicable regulations and policies. Consent notices also alert users that the action they are taking may risk exposing PII. Primavera Gateway helps you to ensure that you have requested the appropriate consent to collect, process, store, and transmit the PII your organization holds as part of Primavera Gateway data. For more details on how to configure consent forms and manage PII data in Gateway, see Gateway Administration Guide.

Post-Installation Tasks

After completing all the prerequisites for setting up the integration environment, perform the following procedures outlined in this section.

Configuring Gateway Domain for P6 Event Notification for On-Premises

If you choose to use the P6 Event provider delivered in Gateway, then configure the Gateway WebLogic domain to consume P6 event messages as follows:

1. Ensure the Primavera Gateway domain is running.
2. Sign in to the WebLogic Administration Server Console for the Gateway domain: a. In a browser, enter the following location: http://:/console Where, hostname and port is the hostname and port of your Primavera Gateway domain in WebLogic. The default port is 7001. b. Enter the WebLogic administrator user name and password.
3. In the Change Center pane, select Lock and Edit before you make any changes to the domain.
4. Create a JMS server as follows:

Gateway E-Business Suite Setup Guide for On-Premises a. In the Domain Structure pane, expand Services, Messaging, JMS Servers. b. In the Summary of JMS Servers pane, select New. Note: Select Next on each screen to advance to the next step.

1. Enter a Name for the JMS Server. For example, Gateway JMS Server.
2. Select Create a New Store.
3. In the Type list, select File Store.
4. Enter a Name for the File Store.
5. Select the Target for the file store: For Admin server, select AdminServer. For Managed server, select GatewayCluster.
6. Enter the Directory of the physical location of the file store. For example, c:\JMSFilestore.
7. Select OK.
8. Select Finish.

5. Create a JMS module as follows: a. In the Domain Structure pane, expand Services, Messaging, and JMS Modules b. In the Summary of JMS Modules pane, select New.

1. Enter a Name for the JMS module.
2. Depending on your configuration, select the Target for the file store, as AdminServer, or GatewayCluster for a managed server.
3. Select Finish.

6. Create a Foreign Server in the JMS module as follows: a. In the Domain Structure pane, expand Services, Messaging, and JMS Modules. b. Select the JMS module created in step 5. c. On the Configuration tab of the Settings for pane, select New. d. Select Foreign Server. e. Enter a Name for the foreign server. f. Depending on the configuration, select the Target as AdminServer, or gatewayCluster for a Managed server. g. Select Advanced Targeting and then select Create a New SubDeployment. h. Enter a name for the subdeployment and then select OK. i. In the subdeployment list, select the created subdeployment. j. Depending on your configuration, select the Target as AdminServer, or gatewayCluster for a Managed server, and the JMS server created in step 4. k. Select Finish. l. Select Save to save the foreign server with a subdeployment.
7. Enter configuration settings for the foreign server created as follows: a. Select the foreign server created in step 6.

Gateway E-Business Suite Setup Guide for On-Premises

8. In the Change Center pane, select Activate Changes to enforce all the changes made to the domain.

Enabling Encryption Between Gateway and P6 Web Services

To ensure all requests and responses between Primavera Gateway and P6 Web Services are encrypted, you need a keystore file for encryption. There are several methods for generating a keystore file. You can use the following sequence to generate and use the same keystore file on all servers:

1. Create a Keystore file as follows: a. Create a folder, for example, C:\keystore. b. Use the Java keytool genkey command to create a keystore with the private key: From the command line, execute: keytool -genkey -alias <alias_name> -keyalg RSA -sigalg SHA1withRSA -keypass -storepass -keystore Where: is the key alias is the password of the private key is the password of the keystore For example: keytool -genkey -alias myAlias -keyalg RSA -sigalg SHA1withRSA -keypass myPassword -storepass myPassword -keystore c:\keystore\keystore.jks c. Enter information for each of the following questions:  What is your first and last name? Enter the Gateway host name.  What is the name of your organization?  What is the name of your city or locality?  What is the name of your state or province?  What is the two-letter country code for this unit? For example, US.  Is CN=, OU=, O=, L=, ST=, C= correct? Enter Y or N. Note: If P6 Web Services is deployed on other than a Gateway machine, then copy the keystore folder with keystore.jks to the P6 Web Services machine.
2. In the Gateway user interface, select the Configuration tab and enter deployment information for P6. For more details, see Adding or Editing a P6 Deployment Connection (on page 23).
3. In P6 EPPM administration application: a. Enter the keystore information that was entered in the keystore file. The values must be identical.

Setting Up the Integration Environment b. Modify the message protection node setting as follows:  Set the Require Timestamp value as True.  Set the Require Digital Signature for Incoming Messages value as True.  Set the Require Encryption for Incoming Messages value as True.  In the KeyStore Type field, enter JKS.  In the File Location field, enter the location of the .jks file. For example, c:\keystore\keystore.jks  In the KeyStore Password field, enter the password for the keystore file provided in keytool command.  In the Private Key Alias field, enter the alias name provided in keytool command.  In the Private Key Password field, enter the private key password for the keystore file provided in the keytool command.  Set the Encrypt Response value as True.  If the encryption is on in Primavera Gateway, then NONCE and CREATED are included in the header for UserName Token authentication. To enable this:  Set the NONCE value as True.  Set the CREATED value as True.

4. After encryption is set, restart P6 Web Services.

Setting Up EBS Connectivity through Web Services

To set up EBS connectivity through Web Services from Primavera Gateway:

1. Depending on the EBS release, setup the integrated SOA Gateway on EBS: For EBS 12.1.x, see Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12 (Doc ID 556540.1). For EBS 12.2.x, see Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1). Note: SOA connectivity to EBS through webservices supports Username Token and SAML (sender vouches) security policies as required by EBS integrated SOA gateway setup.
2. Apply the database schema using the database setup documentation provided with the EBS provider database code.
3. Manually generate and deploy the webservices wsdl for the EBS APIs. For more details, see Appendix A - Setting up SOA Web Services in the MD.120 P6_EBS_Integration guide delivered with the EBS provider in the media pack. Ensure that services generated and deployed using EBS Integrated SOA gateway have synchronous interfaces only. The current release of EBS provider does not support connecting to EBS via asynchronous service calls. Extending EBS WebLogic Domain for Web Services Connectivity Extend the WebLogic domain with JRF and OWSM for Primavera Gateway to connect to EBS using web services through SOA Gateway as follows:

Setting Up the Integration Environment

1. Generate a dbc (db connectivity) file in EBS specific to the Primavera Gateway IP. For detailed instructions refer to the following topics in the Oracle E-Business Suite Software Development Kit for Java Version 2.0.1 (includes AppsDataSource, Java Authentication and Authorization Service, session management) Readme: Patch 13882058 (Doc ID 974949.1):  Register the External Node and Generate the Desktop DBC File  Set Up Necessary Oracle E-Business Suite Users
2. Copy the generated dbc file from EBS to a Gateway server directory. Make a note of the Gateway server directory name and location. You will need this when adding an EBS deployment in the Gateway user interface.

Configuring the Primavera Gateway User Interface

Based on the application you plan to integrate EBS data with, configure Primavera Gateway and specify the connectivity to the corresponding applications. Configuring Gateway Settings Use the Settings dialog box to configure Gateway settings such as the Help location or whether to create new code values during synchronization. The settings available in this dialog box may vary depending on the specific providers Primavera Gateway is currently using. To configure Gateway application settings:

1. Select  and then select Settings.
2. Update the settings as necessary and select Save when finished. On the General tab:  Help URL : Enter the help system hosted by Oracle as http://docs.oracle.com/cd/E91470_01/help (On-premises only) If you deployed the local Help, then enter the default Help URL location as: http://:/gatewayhelp  Maximum number of job logs to display : Enter a value to control the number of logs displayed on the Monitoring page.  Auto delete job after XX days (0 turns off auto delete) : Enter the number of days that a job log can be retained before it is auto deleted. Enter 0 to turn off auto delete.  Maximum wait time for the parallel load/convert steps to complete (in minutes): Enter the number of minutes after which a synchronization job process is to be timed out. By default, the duration is set to 30 minutes. The job status of a timed-out synchronization is set to Failed.  Maximum concurrent jobs in a node: Enter the maximum number of jobs that can be executed concurrently at a node.  Job Polling Interval (in seconds): Enter the wait time interval in seconds to check the database if there are new jobs to run.  Job Timeout value (in minutes) : Enter the wait time interval in minutes to timeout a synchronization job.

Gateway E-Business Suite Setup Guide for On-Premises  Maximum File Size Limit (in MB) : Enter the maximum file size limit for uploading files from Gateway user interface or from external applications. The file size limit applies to all providers and all supported file formats: CSV, XML, XLS, and XLSX.  Maximum job log size for XML format (in MB) : Enter the maximum file size limit for job log size. Job log files over 10 MB are saved in JSON format by default.  Enable Configurable Consent Forms : Select this option to display the Consent Forms tab on the Configurations page in Gateway. If you enable this option and then proceed to configure and enable specific consent forms, your users will need to give their consent to gain full access to specific features and functions of Gateway.  Disable logging for Jobs : For integrations with Unifier, select this option to improve performance with large sets of earned value management data. If you choose to integrate with P6, enter the following information on the P6 tab:  Create new resource code values during synchronization to P6 : Select this option to enable the creation of new resource code values in the P6 EPPM resource code dictionary if these values do not already exist.  Create new project code values during synchronization to P6 : Select this option to enable the creation of new project code values in the P6 EPPM project code dictionary if these values do not already exist.  Create new activity code values during synchronization to P6 : Select this option to enable the creation of new global activity code values in the P6 EPPM activity code dictionary if these values do not already exist.  Include time zone when exporting from P6: Select this option to export P6 server time zone information along with P6 date and time fields. By default, this option is not selected, except for spread interval data in P6. Note: This time zone setting applies only for a P6 - Prime Projects integration.  Update activity resource assignments when assigned UDF values match : Enter the UDF code value that is assigned to resource assignments which you want to update during a synchronization. Use this to update the resource assignment with the matching UDF value when the assignment exists multiple times on an activity.  Maximum wait time for the summarizer to complete (in seconds) : Enter the amount of time in seconds to wait for the summarizer to complete before a warning is given. On the Mail Configuration tab:  SMTP Server : Enter the SMTP server address of your email server.  Port Number : Enter the port number of your email server.  Email Security : Select the applicable email security type. Choices include, SSL , TLS , and None.  Email Address : Enter the email address for the user who is to be notified.  Authorized User : Enter the user name for this email account.  Password : Enter the password for the authorized user.  Bounce Email Address : Enter an alternate email address to be used if mail fails to be delivered to the first email address. On the Server tab: