Row Traversing

&LEVEL0 = GetLevel0();                                               --level zero rowset

&LEVEL0_ROW = &LEVEL0(1);                                            --Level Zero Row

&LEVEL1 = &LEVEL0_ROW.GetRowset(SCROLL.EMPL_CHECKLIST);              --level1 Rowset

For &I = 1 to &LEVEL1.ActiveRowCount                                 --for loop to get all the values till current row

   &LEVEL1_ROW = &LEVEL1(&I);

   &LEVEL2 = &LEVEL1_ROW.GetRowset(SCROLL.EMPL_CHKLST_ITM);

   For &J = 1 to &LEVEL2.ActiveRowCount

        &LEVEL2_ROW = &LEVEL2(&J);

        &LEVEL3 = &LEVEL2_ROW.GetRowset(SCROLL.EMPL_CHKLST_ITM_1);

        For &k = 1 to &LEVEL3.ActiveRowCount

                &LEVEL3_ROW = &LEVEL3(&k);

               &RECORD = &LEVEL3_ROW.EMPL_CHKLST_ITM_1;              --get record

               &Emplid = &RECORD.emplid.value;                       --get value

               Winmessage(“Employee ID: “|&Emplid);                  --to display all retrieved employee IDs online

        End-For;

   End-For;

End-For;

In this case for suppose we have 1 row in EMPL_CHECKLIST, 5 rows in EMPL_CHKLST_ITM, 10 rows in EMPL_CHKLST_ITM_1 for the same employee ID, then we will get 10 messages when the system executes given code.

Some more Row Traversing functions:

CurrentRowNumber(1);

Issue: Not Able to create an employee with Employee Record '0'

Issue: Some times in Peoplesoft system we can not create a new employee with Employee Record zero. In 'Organizational Relationships' page 'Empl Rcd' will be defaulted to '1'. Even if we try to overwrite it with '0' it will through the error: 'This Empl_rcd is already in use for this person in PER_ORG_ASGN. Choose a diffrent EMPL_RCD.' as in the following screen shot.
This happens because there is a row in database with Employee ID :'NEW'. Peoplsoft system shoould not allow to create an Employee with Empl ID 'NEW', because of some descripancies in the system Empl ID 'NEW' will be created.
Even in the same instance this issue can not be replicated. We can not use 'ID Delete' component to delete this Empl ID, because we can not get emplid in prompt table.

We can not find Empl ID 'NEW' in ID Dlelete Component. It is because Empl ID 'NEW' is not there in 'PERS_SRCH_ALL' View and Undelying Tables.

Resolution: Insert dummy row with Empl ID with 'NEW' into all the underlying records of the View 'PERS_SRCH_ALL' which are 'PS_PERSON', 'PS_PERS_DATA_EFFDT' and 'PS_NAMES'. Then proceed to run ID Delete process with emplid 'NEW'.

PeopleSoft Viewlets

This could be helpful.

Download from: http://download.oracle.com/peopletools/viewlets.html

I will update this blog with my understandings on Viewlets.

Applying Country Extension and Bundles

This Blog is regarding the steps to be followed while applying Country extensions and GP Bundles #8 and #9 in UAT and PROD instances considering the china Bolton issue encountered in DEV and DMO instances.
UAT and PROD are now at MP6 ML stage, Country extensions followed by GP Bundle #8 and #9 has to be applied. Following are the steps to be followed to apply Country extensions and GP Bundles in UAT and PROD instances:

1. Run SYSAUDIT and DDDAUDIT reports and make sure that they are clean.

2. Refer: 1-7,1-10 and 1-11 in “Installing_HRMS_Campus_Solutions_9[1].0_Applications.pdf”.

Note: This step may include bouncing application server regarding which CHRIS team has to be informed 2 Hrs prior to the action.

3. For country extensions, follow “HC9_MP6_GP_ML.pdf”. Please maintain a copy of all the log files.

4. China Bolt-on is prerequisite for China Country Extension. Follow “GP_China_bolton.pdf” for China Bolton. It is suggested not to use the record structure in China Bolton, as suggested in SR 3-970069241. Because China Bolt-on, which was released before GP Bundle 4, is having older version of Record Structures compared to MP6 ML. Instead skip the Project download step in China Bolton and proceed with Rule and Non Rule packages steps Page 22 “Installing Global Payroll for China Extensions” and page 26 “Installing the Global Payroll for China Extensions Multilingual Portion”.
HC9_MP6_GP_ML.pdf will be present in MP6 zip file. Unzip MP and follow the path: “MP6\HC9_MP6_ML\Cumulative\upd774233ml\upd774233_install_ml”.
China Bolt-on and China Bolt-on ML Zip folder and Installation guide can be found in Shared folders “\HRIS_HRMS\hcm9phase2\2000-Implement\070-Patches\China Bolt-on”

a. While Applying Non-Rule Package "CNSYS" as part of China Bolt-on, CNSYS_RECORDS_IMP.DMS throws Error: "SQL duplicate rows in SET_CNTRL_REC 1". Resolution would be to execute “DELETE FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = 'CHN' AND SETID <> 'CHN' “ followed by commit and rerun CNSYS_RECORDS_IMP.dms.

b. We will encounter error in “cnsyszhs_records_imp.dms” as part of Non-Rule Package “CNSYSZHS”. The error will be because of the mismatch in the record structure of “GPCN_PSLP_LANG”. The Script “cnsyszhs_records_imp.dms” will be looking for only 5 fields in the record whereas system will have 11 Fields.
Resolution would be:

i. In App designer record GPCN_PSLP_LANG will have 11 fields. Delete all the 6 fields GPCN_LBL_ACUM1 to GPCN_LBL_ACUM6.

ii. Alter the Table (with Build and Execute Option) and rerun “cnsyszhs_records_imp.dms”. Complete the China Bolt-on Rule and Non-Rule packages.

iii. in App designed add all 6 deleted fields in the record GPCN_PSLP_LANG, Alter the Table (with Build and Execute Option). Continue with the steps specified for China Country Extension.

5. Run DDDAUDIT and SYSAUDIT reports and make sure that both are clean.

6. Apply Bundle #8 and #9 after country extensions. Zip folders can be found in shared folders “\HRIS_HRMS\hcm9phase2\2000-Implement\070-Patches\Bundles\Bundle Zip folders”
GP Bundle #8: upd734686.zip
GP Bundle #9: upd765610.zip

a. We will encounter one more issue while applying GP Bundle #9. “Createviews.sql” throws error while attempting to create view “PS_GPFR_DA_SIT_VW”. It is because the view “PS_GPFR_DA_SIT_VW“ will be built on one of the non existing Records “PS_GPFR_AF_EE_SIT” in the system. We can ignore this View as it is related to Country France Global Payroll. Resolution would be to delete the steps related to the view “PS_GPFR_DA_SIT_VW” in “Createviews.sql” and run the script for the remaining views.

7. Run DDDAUDIT and SYSAUDIT reports and make sure that both are clean.

8. In DDDAUDIT report records with name PS_GPDE_SI_ACCDT will appear in database and Application Designer. This record is supposed to be deleted in GP Bundle 9 both from Database and application designer. But in application designer it is deleted but not from Database (we got the same record in all the instances in which Bundle 9 is applied). Drop the table from database. After deleting the table, make sure that DDDAUDIT is clean.

Error: The database is at release 8.48. The PeopleTools being run require databases at release 8.49

Error While loading application designer: The database is at release 8.48. The PeopleTools being run require databases at release 8.49.

Scenario: even though the PTDDL.SQL being run on Database is from 8.49 CD, we get this error.

Root cause: All Apps (Version 9) till date have been made on 8.48 tools...So as part of the installation process one needs to run the release script for 849 based on the kind of DB they have ... This is as per design ..
for further information refer: http://forums.oracle.com/forums/thread.jspa?threadID=863896&tstart=45

PeopleSoft Processes and Job Servers

The server in which this job runs will be independent of servers selected for individual processes, and will run on the server selected for job (if it is blank, default server for job will be selected).

China Bolt-on

In our project HRMS 9.0 was being implemented and as client was multinational company, we had to implement country extension to many countries, including China. In Oracle PeopleSoft document for China country Extension, it was suggested to install China Bolt-on as prerequisite to China country extension. China Bolt-On being released after GP Bundle #3, all the definitions included in China Bolt-on was as in GP Bundle #4. As our system was already on MP 6 which was including till GP Bundle #7, while installing China Bolt-on we got error in one of the DMS scripts which lead us to raise an SR in Metalink and we got to know all these information. Resolution for the issue was to implement MP6 on the system again. SR ID being 3-970069241 and China Bolton information is in 3-947771311.