Three level Rowset Peoplecode

Here is a typical peoplecode example for reaching the level three reord using rowset peoplecode. 

/* Need to insert a row when a flag = ‘Y’ after graying all other fields in the row in correction mode */
PeopleCode Event : COMPONENT_NAME(Component).GBL.PostBuild(Component PeopleCode)

Local Rowset &TQ_Lvl0, &TQ_Lvl1, &TQ_Lvl2, &TQ_Lvl3;
Local number &insert_row, &lvl_1_row, &lvl_2_row, &lvl_3_row;

&TQ_Lvl0 = GetLevel0();
&TQ_Lvl1 = &TQ_Lvl0(1).GetRowset(Scroll.LEVEL1_SCROLL_NAME);
&insert_flag = “N”;

For &lvl_1_row = 1 To &TQ_Lvl1.ActiveRowCount
   &TQ_Lvl2 = &TQ_Lvl1(&lvl_1_row).GetRowset(Scroll.LEVEL2_SCROLL_NAME);
   For &lvl_2_row = 1 To &TQ_Lvl2.ActiveRowCount
      &TQ_Lvl3 = &TQ_Lvl2(&lvl_2_row).GetRowset(Scroll.LEVEL3_SCROLL_NAME);
      For &lvl_3_row = 1 To &TQ_Lvl3.ActiveRowCount
         &tq_adj_applied = &TQ_Lvl3(&lvl_3_row).LEVEL3_RECORD_NAME.FIELD_NAME.Value;
         If &tq_adj_applied = “Y” Then
            &TQ_Lvl3(&lvl_3_row).MPF_TINQ_LOG.EARNS_END_DT.Enabled = False;
            &TQ_Lvl3(&lvl_3_row).MPF_TINQ_LOG.MPF_ADD_SUBTRACT.Enabled = False;
            &TQ_Lvl3(&lvl_3_row).MPF_TINQ_LOG.MPF_HOURS_TYPE.Enabled = False;
            &TQ_Lvl3(&lvl_3_row).MPF_TINQ_LOG.MPF_HOURS_ADJ.Enabled = False;
            If %Mode = %Action_Correction Then
               &TQ_Lvl3.InsertRow(&TQ_Lvl3.ActiveRowCount);
            End-If;
         End-If;
      End-For
   End-For;
End-For;

PSAE and PSAESRV

PSAESRV is Application Engine server processes that handles Application Engine requests
PSAE is an executable that executes the application engine request.

PeopleSoft conducted a study and shown that PSAE is just as good as PSAESRV for most practical purposes. If you have an AE job that runs longer than 10 sec, PSAE is equivalent to PSAESRV. PSAE has the added advantage of being recycled at the end of each AE job, cleaning up any outstanding SQL cursors to the database that may have been left behind. Since PSAE recycles after each use, it does not has any possible memory leakage problem that may occupied the precious system memory. In short, PSAE is a cleaner workhorse.

To shutdown PSAESRV, when you configure the Process Scheduler, you can change the default of the PSAESRV instance to 0.
Values for config section – PSAESRV
Max Instances =0
Recycle Count=1000
Allowed Consec Service Failures=2

sa (system admin) password change

For security reasons, you may have to change sa password frequently in PeopleSoft application. Here are the two ways to change sa password. This change should be done when no users logged into the system. Apart from changing the password, no other configuration change is required in this regard.

1. Using Application Designer : Login to application designer and follow steps mentioned below.

• Select Tools > Miscellaneous Definitions > Access Profiles.
• The Access Profiles dialog appears.
• In the Access Profiles: list, highlight the profile that you want to modify, and click Edit.
• The Change Access Profile dialog appears.
• This dialog prompts you for the old password then to type and confirm the new password for the Access Profile.
• Enter and confirm the new a password.
• The Access Password is the password string for the ID. Confirm Password is a required field and its value must match that of Access Password.
• Click OK.

2. The manual steps are as given below

• Change the ‘sa’ password at database level.
• Login to Datamover in bootstrap mode and run the below script

For PeopleTool in 8.4x
  change_access_password sa1 NEW_SYSADM_PWD;
For lower PeopleTools version it could be
  set change_access_password sa1 NEW_SYSADM_PWD;

sa1 is the symbolic id for sa.