EPC: PC_INTF_GEN.25000000.UPD_STD Update Start Date In PS_PROJECT Incorrectly (Doc ID 2077693.1)

Last updated on NOVEMBER 13, 2015

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

The PS_PROJECT START_DT looks to be incorrectly updated with the PS_PROJ_ACTIVITY START_DT because the criteria that does the update uses a SQL below that does not consider the BU, PROJECT_ID in the criteria when selecting the MIN(START_DT):

PC_INTF_GEN.25000000.UPD_STD:

UPDATE PS_PROJECT
SET START_DT = (
SELECT MIN(START_DT)
FROM PS_INTFC_ACT_TAO
WHERE PS_INTFC_ACT_TAO.PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)
AND PS_PROJECT.BUSINESS_UNIT = PS_INTFC_ACT_TAO.BUSINESS_UNIT
AND PS_PROJECT.PROJECT_ID = PS_INTFC_ACT_TAO.PROJECT_ID )
WHERE EXISTS (
SELECT 1
FROM PS_INTFC_ACT_TAO
WHERE PS_INTFC_ACT_TAO.PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)
AND PS_PROJECT.BUSINESS_UNIT = PS_INTFC_ACT_TAO.BUSINESS_UNIT
AND PS_PROJECT.PROJECT_ID = PS_INTFC_ACT_TAO.PROJECT_ID
AND PS_PROJECT.START_DT > (
SELECT MIN(START_DT)
FROM PS_INTFC_ACT_TAO))

As a result, in a scenario where the project start date is 7/1 and minimum activity start date is 5/1 (for all the activities in the INTFC_ACT_TAO - it is common in our process to have multiple projects inserted in the same run) it will satisfy the min start date criteria. Even if the minimum activity start date for that BU and Project is 8/1.

Replication steps:
1. Load entries in the PC staging tables for multiple projects.
2. Have entries where the project is different than the activity date.
3. Have one of the activity date for one project be earlier than the start dates for the other projects.

Impact:
it prevents users from updating the projects

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