My Oracle Support Banner

Change Create Date Gets Modified to Import/Upgrade Date After Running Datapump Import or DB Upgrade (Doc ID 1158684.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.0 to 9.3.0.1 [Release 9.3]
Information in this document applies to any platform.

Symptoms

Actual Behavior

The Date Originated on all ECOs are updated to the date which is the date database import was performed or the date database upgrade was performed.
The actual Date Originated of ECO is not different.

Expected Behavior

Date Originated of ECO to retain the original creation date even after performing database upgrade or database import

Steps

The issue can be reproduced at will with the following steps:
1. On production instance, run agile9expdp to export the DB
2. On test instance, run recreateagile to refresh the DB
3. Run agile9impdp to import the production DB
4. Start Agile Application Server
5. Login to Web Client, and search for all ECO
6. Check the create date. See the date is all updated to the date of import

Also there is case reported that same symptom happens when upgrading from AA to 9.3.0.1.
In this case the issue happens even datapump import was not used.

Changes

The issue can be caused by either of the below changes:
1) Ran recreateagile and datapump import
2) Upgraded from AA 2006 to A 9.3.0.1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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