To export project data from P6 to E-Business Suite, you can use the following default templates in the Gateway user interface. You can also create your own if these templates don't fit your needs.
Use the Export Project from P6 default business flow to export the following objects from P6 EPPM with the appropriate default field mapping template after the name:
The following source parameters are available by default. Users with the Gateway administrator, role can access and view all hidden parameters. You can also change these settings.
Note: Unless specified in parentheses, all parameters listed below are hidden from a non-administration user.
Use this setting to specify the object, fields, and values to be exported from P6. Field options include, Project IDs, EPS IDs, Project Code Type Name, and Project Code Value.
Use this setting to specify the object, fields, and values to be exported from P6. Field options include, Activity IDs, Activity Status, Activity Type, Activity Code.
Use this setting to specify the object, fields, and values to be exported from P6. Field options include, Resource IDs, and Resource Type.
Use this setting to select the default spread period type to be exported from P6. Options include, Week, Month, Day, and Financial Period.
Use this setting to specify multiple baseline IDs to be exported from P6 as comma-separated values.
Use this setting to determine whether to summarize the projects before synchronizing the data from P6.
Use this setting to select WBS Hierarchy from the list which needs to be synchronized from P6. Options include: Complete, Partial, and Levels.
The following destination application parameters are available by default. Users with the Gateway administrator role can access and view all hidden parameters. You can also change these settings.
Note: Unless specified in parentheses, all parameters listed below are hidden from a non-administration user.
Use this setting to determine whether to save the data in EBS with errors.
Use this setting to determine whether data that no longer exists in the source application can be deleted.
Use this setting to select the project plan. Options include, Work Plan and Financial Plan.
Use this setting to determine whether the activities can be exported as leaf level tasks or top level tasks in EBS.
Use this setting to specify the Project Calendar working hours per day in the Primavera application.
Use this setting to specify the existing project or project template number only while creating a new project in EBS from P6.
Use this setting to specify project organization name only while creating a new project in EBS from P6.
Use this setting to specify the planning resource list name while synchronizing resource assignments from P6, and if the project has been created in P6.
Use this setting to specify a budget type or financial plan type as per EBS Project Accounting to transfer budgets from P6 to EBS.
Use this setting to specify a budget entry methods budgets are created in project costing from P6 to EBS.
Legal Notices
Copyright © 2013, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Tuesday, May 31, 2016