Journey on Peoplesoft

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.

Consume a 3rd party web service: Navigate to Main Menu -> PeopleTools -> Integration Broker -> Web Serives -> Consume Webservices There are various Delivered steps involved: 1) Input the 3rd Party WSDL: (Here we tested with : http://www.gama-system.com/webservices/servertime.asmx?WSDL ) (Ensure that you uncheck Build Document Messages if u r going to use non rowset messages) Refer:  Build Document Messages 2) Click on Next and Check related WSDL Service 3) Select Appropriate Service with relevant Port  4) Click on Service Operation we are going to use 5) Click on Next 6) Click on Next 7) click on Finish 8) Click on View Consumed Service or Navigate to Main Menu -> PeopleTools -> Integration Broker ->Integration Setup -> Services 9) Click on Service Operation (GETDATE) 10) Provide Appropriate Security (Permission List) by clicking Service Operation Security Use Below Code to invoke the Service Operation Thr

For any tools version greater than 8.50, while consuming web services (in first page) we can see one Option ‘Build Document Messages’. This option is checked by Default.  Use this to build document type messages for the consumed service. Clear the box to build nonrowset-based messages for the consumed service.

When we try to test input message (request XML) using service operation tester we faced below error. The same XML worked in SOAPUI successfully. The we realized we need to add <?xml version="1.0" ?>  before the XML request. Then we got the appropriate response.

What is 'Import Only' Program Type in Application Engine ? This is a specific program type, that only get set when your generated an Application Engine program from a File Layout. This is a program type for a simple peoplesoft import job only. After the Application Engine program was generated or modified, it is recommended to change the type back to Normal, not using the 'Import only'.  But so far, we don't see any big difference for sample File layout import job when using this Application Engine program type and the Normal type. Does it affect commit points, and if so, how? No, it work the same as Normal Application Engine program type. How would a program inserting rows into a table, and reading them from a flat file be affected? As explained earlier, this program type is only set when using File Layout to generated AE automatically in app designer, the generated AE should be strictly used from this purpose, it would affect the other program.

There are Restrictions on Use of the Exec() Funtion in PeopleCode Events - and there is also a Restriction in Application Engine (AE) programs.  This is based on whether the execute of the external program is Synchronous, or Asynchronous.   If Asynchronous execution is selected - the execution is not 'tied' directly to the continuing execution of the running AE program, so no Think-time error results from this choice. With Synchronous execution it is different - the AE program will wait for the exectution of the command before continuing with the current process.  In order for this to work with no error - a Commit has to happen before the Exec takes place. If the AE was written to be Restartable, then just make sure that the previous step has been committed before the step with the Exec.  And if the AE has the Disable Restart checked, then a CommitWork() will need to be inserted into the PeopleCode step, so that this Commit takes place. Once a commit has been done, th

The difference between a public PeopleSoft query and a private PeopleSoft query is the population of the OPRID field on the following tables: PSQRYDEFN PSQRYSELECT PSQRYRECORD PSQRYFIELD Update Statements Below: UPDATE PSQRYDEFN SET OPRID = '' WHERE QRYNAME = 'QUERY_NAME'; UPDATE PSQRYSELECT SET OPRID = '' WHERE QRYNAME = ' QUERY_NAME'; UPDATE PSQRYRECORD SET OPRID = '' WHERE QRYNAME = ' QUERY_NAME'; UPDATE PSQRYFIELD SET OPRID = '' WHERE QRYNAME = ' QUERY_NAME';