How to find which user modified the a particuler Record.Field.Event Peoplecode?

By mymithraa -
Run the following SQL in database of the instance in which you want to find which user modified the a particuler Record.Field.Event Peoplecode


SELECT objectvalue1 record_name, objectvalue2 field_name,
       objectvalue3 peoplecode_event, lastupddttm, lastupdoprid
  FROM pspcmprog
 WHERE objectvalue1 = :record_name
   AND objectvalue2 = :field_name
   AND UPPER (objectvalue3) = UPPER (:peoplecode_event);

Comments

Post a Comment

Popular posts from this blog

How to Bulk Delete Messages from Message/Service Operation Monitor in Error Status

By -
The following is how to delete messages in Error status by a delivered way. 1. Run messaging achieve process at PeopleTools>Integration Broker>Service Operation Monitor>Monitoring>Archive Monitor Data. This will archive all the service operations in Done or Cancel status. 2. Run appmsgpurgelive.dms to delete all the service operations in status other than "Done" or "Cancel" including Error. WORKAROUND: You can customize PSAPMSPURGELIVE.DMS. Set where clause in every delete statement at PSAPMSPURGELIVE.DMS. "where IBTRANSACTIONID in (Select IBTRANSACTIONID from PSAPMSGPUBHDR where PUBSTATUS=0 AND PUBLISHTIMESTAMP " " Now you can run the appmsgarch process. =============================================================================== In PT8.48 or above, You can actual use the filter in the service operation monitor to identify service operations in ERROR status. You need to go to the operation instance, publication contract and subcontrac...
Read more

Peoplesoft SFTP

By -
Image
Transferring a file using SFTP to specified target location: (Thanks to Jawahar who helped me in this article) A lot has been mentioned about sFTP support in PT 8.51. Below gives clear idea on SFTP. Are there any specific pre-requirements for using file transfer protocols? Yes. Though FTP can be used directly by giving the URL as a string to the peoplecode method, other protocols (ftps, sftp, http and https) require the URL to be passed as a URL identifier only. When an URL identifier is created, URL properties link on the page gets enabled. Users need to provide the URL properties specific to the protocol they are using on this "URL properties" page. The URL properties differ based on the protocol choosen. Once URL Identifier is ready, it can be used in any of the file attachment peoplecode methods just like the existing way.   What are the authentication methods supported for sftp? Password and Public Key authentication are supported. ...
Read more

How to program the Application Engine to return warning status to process scheduler?

By mymithraa -
To program the Application Engine to return warning status to process scheduler:- Perform the below to set the AE_APPSTATUS field properly, in order to return the warning status to process scheduler after the AE finish. 1. Create an AET record for your application engine (AE) program if it does not have any, set it as primary state record 2. Add the field AE_APPSTATUS to the primary state record for your application engine program 3. In the AE program, create a peoplecode action, use the below code to set and return the warning status back to process scheduler accordingly. rem set to 1 to return warning, 0 to return success. AET_RECORD.AE_APPSTATUS = 1;
Read more