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.