Journey on Peoplesoft

Below is the sample code to send multiple attachment in mail using MCF Send() mail method. Local any &FromURL = "record://PV_ATT_DB_SRV/" ; Local string &FILENAME; Local Rowset &rwln1 = CreateRowset(Record.PV_ATTACHMENTS); Local SQL &Sql1 = CreateSQL( "select attachsysfilename from PS_PV_ATTACHMENTS a,ps_SPF_RESUME_ATT b where a.scm_attach_id=b.scm_attach_id and b.person_id=:1" , "000000000000025" , &FILENAME); While &Sql1.Fetch(&FILENAME) &attach = create PT_MCF_MAIL:MCFBodyPart(); Local string &ToFile = "C:/user/" | &FILENAME; Local any &errorCode = GetAttachment(&FromURL, &FILENAME, &ToFile); If &i = 1 Then &multiattach = CreateArray(&attach); &multiattach [&i] = &attach; Else &multiattach [&i] = &attach; End-If; &multiattach [&i].SetAttachmentContent(&ToFile, %FilePath_Absolute, &FILENAME,...

Below is the smart SQL to find out the Navigation for the given Component. (This Works only on Oracle DB) Enter the Component Name in the below SQL SELECT DISTINCT rtrim(reverse (sys_connect_by_path(reverse (portal_label), ' > ')), ' > ') path FROM SYSADM.PSPRSMDEFN WHERE portal_name = 'EMPLOYEE'   AND portal_prntobjname = 'PORTAL_ROOT_OBJECT' START WITH portal_uri_seg2 = ‘<COMPONENT Name>’ CONNECT BY   PRIOR portal_prntobjname = portal_objname

Did you hear the BIG news in the world of PeopleSoft?  During a May 2014 PeopleSoft Talk, Marc Weintraub, PeopleSoft Senior Director, interviewed Paco Aubrejuan, Sr VP PeopleSoft Development, who highlighted two main aspects of PeopleSoft’s newest Delivery Model.  Before version 9.2, PeopleSoft delivered a new release; offering tax updates, minor product enhancements and fixing bugs using software bundles delivered every 10 - 12 weeks or so. During the same time, PeopleSoft developers were working on a NEW release and thus working on two code lines (actually 3 since they were supporting multiple previous versions and developing on the next version). It took years to get the major product enhancements to market and often years more for the average customer to perform an expensive application upgrade. Most PeopleSoft customers admit that they are not on the current version of the product. The PeopleSoft Update Manager (PUM) offered with release 9.2 allows the ability to deliver...

Most of the Peoplesoft developers love to install PS on their own Machine (Desktop/Laptop). Till some time back it is very difficult (becoz of Huge Space and other reasons) Recently, Oracle has come up with Virtual Machine which makes the life very simpler. You just need to import the virtual machine in the Virtual Box. This is certainly very fast way to get PeopleSoft working on your machine but if you run into some issues, this is difficult to debug. For a single application as HCM you need a minimum of 4 GB of ram of which you can assign 2.5 to 3 GB to the virtual machine. The ideal RAM allotted to virtual machine should be 6 GB . In order to run the virtual machine, you need to have  VirtualBox  running. If you do not have it installed yet, download and install it. The PUM home page consists links of all the applications: HCM, ELM, FSCM and CRM. You may click on the application you want to install. Below is the PUM Home page https://support....

Some Basic Pointers for ExcelToCI: Not all CIs are suitable for ExcelToCI. The SOAPTOCI Peoplecode sets the CI properties in the same order in which they appear in Application Designer.  This will be a problem in cases where properties need to be set out of sequence in order for Peoplecode validations to work correctly. Avoid using large complex CIs.  However, if you elect to use them, send them in smaller chunks to avoid running into problems such as timeouts, and to improve the application server throughput. Ensure that you use a copy of the ExcelToCI workbook found in <PS_HOME>\excel for the PeopleTools release you’re on.  Also, make sure you don’t open multiple Excel workbooks at the same time, either multiple ExcelToCI workbooks or a combination of ExcelToCI workbooks and other Excel workbooks to avoid seeing strange behavior.  Note the following about the Excel spreadshe...

The encryption and decryption takes place at the database level, and we do not need to write any special code or sql in our application to encrypt or decrypt the data when we do a INSERT, UPDATE or SELECT on that data.  The only thing that must happen is that when a table is created, it must use the ENCRYPT keyword in the table DDL for the column that is to be encrypted (PS: when app designer or maintenance/upgrades generates alter or create scripts, that these scripts will have to be manually edited to add the support for SQL Server encryption.). Once we do that, we do not have to worry about how to retrieve or place the encrypted data in the database - the encryption and decryption procedure is done by the database.  The PeopleSoft application does not need to know that a field is encrypted and nor does the application need to know how to retrieve the data and decrypt it.

Below are instructions on enabling both the Developer tab and VB macros when using Excel 2007.  Additionally, attached is a Word document with screenshots showing the same basic steps, providing the reader with a better visual representation of what the steps look like. A. Enabling the Developer Menu in Microsoft Excel 2007 - The Developer menu in Microsoft Excel contains options to work with Microsoft Visual Basic, macros, sheet properties, and so on. In Microsoft Excel 2007 the Developer menu is not automatically enabled and does not appear on the menu ribbon in the default view of the Excel workspace. In prior versions of Microsoft Excel supported for use with the ExcelToCI utility, and the Developer menu appears by default. To use the Excel to Component Interface utility you need access to some of the features accessed through the Developer menu, and therefore you must enable the menu. Once enabled, the Developer menu appears on the far right on the menu ribbon. To ena...

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 bee...

How and when Temporary Tables are Re-used Concurrent Runs of the same Application Engine (AE) program will have different Parameters and each will use it's own respective set of Dedicated Temporary Tables  - If a dedicated set is available. If no dedicated set of temp tables are available, then the Base Table is used, as long as the Program Properties are set to 'Continue', not 'Abort' in Application Designer for the specific AE program. Any AE that goes No Success keeps it's dedicated set of Tempoary Tables locked and unavailable for subsequent use until the original AE has either been Restarted and has run to Success, or if the row is deleted from Process Monitor. If the AE program was run outside of the Process Scheduler at command prompt, then the navigation of; PeopleTools, Application Engine, Manage Abends can be used to free up (delete) the set of dedicated temp tables. How to manually remove Temporary Tables Occasionally it is not poss...

Make sure that web.xml file has a line for .7z file extension with correct mime type as below.. Mime Types:, application/stuffit, application/x-7z-compressed

How to delete a field that is auto-populated using PTF? Use #NOTHING on that field.