PeopleSoft NA Payroll or HCM Functional Training:

PeopleSoft NA Payroll or HCM Functional Training:

Please send email to nandu.peoplesoft@gmail.com for enrolling the course or call me @8897575066. Please see below HCM Functional training AGENDA.

Payroll for North America training AGENDA.

This is an online Functional Training. Training goes through webex and explain you with real time execution of processes with examples. Recordings and documentation will be given once the training is done.

Saturday, November 23, 2013

Delete Obsolete PeopleSoft Time and Labor Template Build Rules - Posted by mybasicknowledge

At times we need to delete obsolete time and labor rule that are not in used. We have to use backend tools (App Designer, SQL PLUS) to delete them
1.  Following is the list of SQL statements to remove obsolete Time and Labor rules.

DELETE  FROM PS_TL_RULE_CONDS WHERE TL_RULE_ID=OLD RULE ID
DELETE  FROM PS_TL_RULE_DEFN WHERE TL_RULE_ID=OLD RULE ID
DELETE  FROM PS_TL_RULE_STEPS WHERE TL_RULE_ID=OLD RULE ID
DELETE  FROM PS_TL_RULE_TMPLT WHERE TL_RULE_ID=OLD RULE ID
DELETE  FROM PS_TL_TMPLT_RULE2 WHERE TL_RULE_ID=OLD RULE ID
DELETE  FROM PS_TL_TMPLT_RULE WHERE TL_RULE_ID=OLD RULE ID
2.  Remove an old rule from an existing rule program
DELETE FROM PS_TL_RULE_PGM_DTL WHERE TL_RULE_ID =OLD RULE ID
3.  For deleting the AE sections
Open AE program TL_TA_RULES and manually delete the appropriate sections containing old rules and Save.
TL_TA_RULES program is generated automatically during the Save event (i.e. when User tries to save the rule).
So, basically TL_TA_RULES program is a big library of all Customer rules. If Customers do not want to use one or another rule they can just remove the rule from the rule program and TA will not execute this rule.  Personally, they do not recommend removing it, as they do not need to look into TL_TA_RULES that often, if at all.  But you can do so by deleting the appropriate section from TL_TA_RULES & then press Save.