Actuals Import and Export as One Time But Display in P6 as a Different Time (Doc ID 2863251.1)

Last updated on APRIL 18, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Actuals import and export as one time but display in P6 as different time
The timestamp is showing as 7:59am and 4:59pm but was imported in and exports back out as 8:00am and 5:00pm.


EXPECTED BEHAVIOR
-----------------------
Actuals should import with the correct Timestamp

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Excel Export is created from an empty P6 project template in which to be imported.
2. An excel export of MS Project data is created of a project to be moved to P6.
3. The codes and fields we want to import from the project file are normalized.
4. The wanted data is added to the excel file to be imported, removing any unneeded columns (This is where the date formatting would occur)
5. Save the file and import
6. After Import the Timestamp on the Actuals in P6 showed as 7:59am and 4:59pm even though the Timestamp in the imported spreadsheet says 8:00am and 5:00pm

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import Actuals correctly.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.