My Oracle Support Banner

R 12: A Script Is Needed To Identify Existing Projects With Enabled Checkbox "Automatically Update Task Transaction Dates" (Doc ID 2250177.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.


After upgrade to R12 a new checkbox appeared labeled "Automatically update task transaction dates".

If this checkbox is enabled when you add a new task on project, then transaction dates on task level are updated automatically with sysdate. It  seems that is has been enabled automatically during upgrade.

1. A script is needed in order to identify existing projects that are impacted by this configuration.

2. A script is needed in order to disable checkbox for "Automatically update task transaction dates" option.


The option " Automatically update task transaction dates" can be checked in frond end by following the below navigation steps:

1. Go in Projects Super User Responsibility > Projects: Delivery > Search Projects > Advanced Searched > search for your project.

2. Click on Project Name hyperlink > click Workplan tab > click Setup sub tab > click Workplan Information link > verify the option "Automatically update task transaction dates".


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

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

In this Document

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