Import Project Progress

Import published progress and update draft progress for projects and tasks from third-party applications into Oracle Project Control by using the Import Project Progress Excel workbook template and running a few scheduled processes.

The Excel template is part of the External Data Integration Services for Oracle Cloud feature. For more information about the Import Project Progress Excel workbook template, see the File-Based Data Import (FBDI) for Project Management guide.

To import the project progress:

1. Prepare your data in the Import Project Progress macro-enabled Excel workbook template.

2. Click Generate CSV File in the template to create a comma-separated values file of project progress.

3. Navigate to the Scheduled Processes page.

4. Submit the Load Interface File for Import process to load the progress data from your CSV file into the applications related open interface tables.

5. Submit the Import Project Progress process to bring the data into Project Control from the open interface tables.

Parameters for Load Interface File for Import Process

You can specify the range of projects for which you want to import or update progress data by using the following parameters.

From Project Name

Beginning project name in a range of projects, from the PJO_PROJ_PROGRESS_XFACE table, provided for importing project progress versions.

To Project Name

Ending project name in a range of projects, from the PJO_PROJ_PROGRESS_XFACE table, provided for importing project progress versions.

Project Progress Upload Error Report

Review the output reports and repeat the following steps until you import all the required progress data successfully:

• Correct the errors in the Import Project Progress Rejections report.

• Generate CSV file for the corrected progress.

• Upload the CSV file into the open interface tables.

• Submit the Import Project Progress process.