EPC- Why DTTM_STAMP of source transactions (i.e. GLE, GLE, ACT) are being updated when PC_BI_TO_PC are being run? (Doc ID 2185284.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Goal

Qn1: Would like to inquire why DTTM_STAMP of source transactions (i.e. GLE, GLE, ACT) are being updated when PC_BI_TO_PC are being run. Is there a reason behind why there's a need to update the source data instead of the BIL rows only?

Application Engine Name: PC_BI_TO_PC Section: UPDATE Step: PAYROW Action: SQL

App Engine SQL:
UPDATE PS_PROJ_RESOURCE
  SET BI_DISTRIB_STATUS = %Bind(PC_STD_AET.AE_SW2), DTTM_STAMP = %CurrentDateTimeIn
 WHERE (%Sql(PC_BI_TO_PC_PAY, PRT_BI_TAO, TAO, PS_SET_CNTRL_REC, REC, NOQUOTES))
 
Qn2:Can you please let us know the patch that introduced this change so that we analyze and find out if we need to retain this or it?
 

Solution

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