HRMS Store Scripts

HRMS PRODUCT's STORE*.DMS SCRIPTS:

PeopleTools
%PS_HOME%\src\cbl\base\STOREPT.DMS

HR Common%PS_HOME%\src\cbl\base\STOREHRM.DMS

Benefits Admin%PS_HOME%\src\cbl\base\STOREBAS.DMS
Note: If you have this module, always run this one LAST

Pension%PS_HOME%\src\cbl\base\STOREPEN.DMS

Payroll
%PS_HOME%\src\cbl\base\STOREPAY.DMS

Time & Labor%PS_HOME%\src\cbl\base\STORETL.DMS

Payroll Interface
%PS_HOME%\src\cbl\base\STOREPYI.DMS

GL Interface%PS_HOME%\src\cbl\base\STOREJG.DMS

Apply Bundles Manually-Without ChangeAssistant

For yes, CA is a great tool to apply bundles, software updates etc., however at times we may need not to use CA to perform this task. Everyone who is aware of bundle stuff, knows where to find the documentation regarding any bundle and how to use the same to apply bundles manually. I am just collecting the task list and I am taking an example of GP Bundles here.

This is a general record sheet for the tasks involved in GP bundles which needs to be applied in instances. This sheet contains tasks and activities involved in one bundle.

-- Task: Apply Non Managed MetaData
-- Task: Apply Project
-- Task: Deploy Files
-- Task: Build and Alter
-- Task: Reapplying Customizations
-- Task: Execute Data Mover script(s)
-- Task: Apply GP Packages
-- Task: Additional Steps
-- Task: Update Package Prerequisites


Apply Non Managed MetaData

Import Tree Definitions etc. According to the requirement, you may cancel the steps if you don't require for any other language (like Dutch etc...).

Apply Project

Depends if you want to copy from file OR migrate from other instance.

Deploy Files

Below are the locations where files needs to be deployed...

MAINT ----- PS_HOME\maint
DATA ------- PS_HOME\data
SCRIPTS ---- PS_HOME\scripts
CLASS -------PS_HOME\class\
CLASSES ---- PS_HOME\classes\
SQR --------- PS_HOME\sqr
CRW ---------PS_HOME\crw\
COBOL ------ PS_HOME\src\cbl\base

Build and Alter

Run Create Tables Script
Run AlterTables Script
Run Create Trigger Script
Run Create View Script
Run Create Index Script

Reapplying Customizations

Depends on setup.

Execute Data Mover script(s)

Additional scripts which have been provided within the bundles.

Apply GP Packages

Depends on country extensions. For some country extensions, there are no non-rule packages. In HR bundles, this steps is not there. For more details of rule and non-rule packages, please refer my other blog "Global Payroll -- Rule and Non-Rule packages".

Additional Steps

Depends per bundle. Some bundles provides additional scripts to clean audit reports, XMLP errors etc...some bundles doesn't have this step.

Update Package Prerequisites

In the end, CA runs a script "prereqs_i.dms" to update the DB about the prerequisite info. You need to run this script manually. SQL statement in this script is like below:

DELETE FROM PSPROJECTDEP WHERE PROJECTNAME=PRJXXXXX
INSERT INTO PSPROJECTDEP VALUES (PRJXXXXX,'XXXXX');

where XXXXX is your Bundle ID/Update ID. Remember, if you are applying multilingual bundle (for unicode database), then in inset statement, first value precedes with ML, but second value will not. For example, if you are applying Bundle '12345', Delete and insert statement would be like:

DELETE FROM PSPROJECTDEP WHERE PROJECTNAME=PRJ12345ML
INSERT INTO PSPROJECTDEP VALUES (PRJ12345ML,'12345');