Home

Top PeopleSoft Jobs

Monday, April 9, 2012

Question: How do you delete a time and labor template built rule?

Answer:

If you are working on Time and Labor Template Built rule and if you happen to create a rule by mistake or realizethat you did not want the rule
to be in specific name and want to create a new one, there is no option in PeopleSoft Time and Labor to delete the Rule that you just created using the
Templates. The only way would be using the backend method.

Below are the Time and Labor Tables that you will use to delete the rule using a SQL Editor.

DELETE FROM PS_TL_TMPLT_RULE WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_TMPLT_RULE2 WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_TMPLT WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_DEFN WHERE TL_RULE_ID = 'Rule Name';

DELETE FROM PS_TL_RULE_STEPS WHERE TL_RULE_ID = 'Rule Name';

Also, go to TL_TA_RULES Application Engine Program and delete the section of the template rule.