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

Last updated on NOVEMBER 19, 2016

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

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 hundreds of Community platforms