Import Fails With Insufficient Privilege Or Constraint Violations Due To Creation Date. Getting Error: Change of the attribute Create Date to null is not allowed because of insufficient privilege or constraint violations

(Doc ID 2331007.1)

Last updated on DECEMBER 06, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Import fails with the Creation Date on an item.

ERROR
The cover page, p2, p3 attributes of the object(<object number>) are not updated. Get exception during process: Change of the attribute Create Date to null is not allowed because of insufficient privilege or constraint violations.

STEPS
The issue can be reproduced at will with the following steps:
1. Login to webclient
2. Export an exist item into an excel file
3. Update the excel file with the values needed
4. Log back into the Web Client > Run Import
5. Use the newly updated excel file and an existing mapping file and select Item only, enter the existing item number and run the import

Messages The cover page, p2, p3 attributes of the object(01-000041) are not updated. Get exception during process: Change of the attribute Create Date to 2010-03-10 18:55:00 is not allowed because of insufficient privilege or constraint violations.

Changes

 Upgraded from Agile 9.3.1 to Agile 9.3.6

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