Top PeopleSoft Jobs

Deleting Time and Labor Template Built Rule

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 realize that 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.

1 comments:

subbu July 22, 2012 at 10:52 PM  

Dear all i am learner in peoplesoft can you post some project descriptions and real time tasks to subbumymail@gmail.com

Thanks in advance

Post a Comment

About This Blog

Have you got a PeopleSoft Question? Post it in the forums section or in your preferred place or in comments section, so that we can answer it for you in detail with screen shots;

Learn PeopleSoft functionality and how to use the setups and process flow offered in different modules;

Hope this would give you some ideas...

Blog Archive

  © Blogger template On The Road by Ourblogtemplates.com 2009

Back to TOP