EPC- Why DTTM_STAMP of source transactions (i.e. GLE, GLE, ACT) are being updated when PC_BI_TO_PC are being run?
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.
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:
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms