Update Project Error In Projects (Doc ID 1566034.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Public API's

While using 'pa_project_pub.update_project' to update a project,the Start_date of the project is not updated updated (e.g the Start_date in the API is '2012-01-01', the start_date in the pa_projects_all table is '2011-01-01', after called API, the start_date in the pa_projects_all table not changed), Then when you use the 'pa_project_pub.update_task' to update the task to the same start_date, the 'pa_project_pub.update_task' API get error:

 

'The date you entered is outside the project effective date range'.


A. The Project is created with Product Code = MSPROJECT. These projects are currently active and working.

B. For projects belonging to 2 different Countries the projects are created with Product Code = XXXXXX, but for other Countries the product code still remains MSPROJECT.
-OU for both MSPROJECT and XXXXXX is still same (OU Name = A001).
-Country is stored in Classification for distinction.

C. Also the product code for the projects of 2 Countries was updated from MSPROJECT to XXXXXX

D. Problem - when we use UPDATE_PROJECT API to update the project dates having
i. Product Code = MSPROJECT -- then project dates DO NOT get updated , no error.
ii. Product Code = XXXXXX -- then project dates get update.

E. The project setup for projects of "2 Countries" & "Other Countries" is slightly different
i. For 2 Countries - Both Workplan and Finplan are enabled and the structure is Shared.
ii. For Other Countries except the 2 - Only Finplan is enabled.

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