Sometime back, I had this question from my team mentioning – How do we determine when and who had customized this particular Record PeopleCode? The compare report showed that the PeopleCode was customized but there were no comments (bad practice!) in the code to show who touched it last.
In Application Designer the properties button is grayed out when you open the peoplecode. Also, the properties at the record level will not answer this question. Here is the SQL you can use to determine who last updated the code and when.

SELECT A.OBJECTVALUE1 RECORD, A.OBJECTVALUE2 FIELD, A.OBJECTVALUE3 EVENT, TO_CHAR(A.LASTUPDDTTM,’YYYY-MM-DD-

HH24.MI.SS.”000000″‘),

A.LASTUPDOPRID

FROM PSPCMPROG A

WHERE A.OBJECTVALUE1 = ‘&RECNAME’

AND OBJECTVALUE2 = ‘&FIELDNAME’

AND UPPER(OBJECTVALUE3) = UPPER(‘&EVENTNAME’)

/

RECORD FIELD EVENT TO_CHAR(A.LASTUPDDTTM,’YYY LASTUPDOPRID

——— ————— ——— ————————– ————

VOUCHER BUSINESS_UNIT RowInit 2006-11-13-18.25.23.000000 PPLSOFT

VOUCHER BUSINESS_UNIT RowInit 2006-11-13-18.25.23.000000 PPLSOFT

Posted by Nitin Pai
Comments (0)
September 11th, 2007

Comments (0)