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.