1. Defining and Managing Financial Projects
  2. Import Project Tasks

Import Project Tasks

The Import Project Tasks process creates project tasks from data loaded into the Oracle Fusion Project Tasks interface table. The process creates project tasks based on data from third-party applications you loaded into the open interface table.

Run the Import Project Tasks process from the Scheduled Processes page.

Before running this process, you must:

  • Define the projects for your tasks in Oracle Fusion Project Foundation.

  • Load import data to the PJF_PROJ_ELEMENTS_XFACE table. For more information about tables, see the Tables and Views for Oracle Project Portfolio Management Cloud guide.

    You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud. For more information about file-based data import, see the File Based Data Import guide for your cloud services.

You can update task details or remove tasks using the Import Project Tasks file-based data import process. For instance, you might want to extend task dates due to unforeseen circumstances. In such cases, enter Update as the processing mode and enter the project name, task name, and the new end date in the respective columns. To remove a task that’s no longer necessary, enter Delete as the processing mode and enter the project and task names.

Parameters

From Project Name

Beginning project name in a range of projects provided for importing project tasks.

To Project Name

End project name in a range of projects provided for importing project tasks.

Report Success Details

Option to provide details in the Import Project Tasks report for project tasks that imported successfully.

Import Project Tasks Report

The Import Project Tasks report summarizes the number of processed, accepted, and rejected tasks encountered when you imported the project tasks. The report contains details for all project tasks that generated errors during the import process.

Review the error message details for each task. Fix the errors in the source spreadsheet, and resubmit the Import Project Tasks process until you import all project tasks.