Auto Approve Rules / Invoice Approval
Running OTM v6.2
I've assigned an Auto Approval rule to my user, and I still can't approve invoices.
Log Viewer reveals the following:
SELECT rpd.auto_approve_rule_gid FROM
auto_approve_rule_profile_d rpd, gl_user gu, auto_approve_rule ar WHERE
gu.gl_user_gid = ? AND gu.auto_approve_rule_profile_gid =
rpd.auto_approve_rule_profile_gid AND rpd.auto_approve_rule_gid =
ar.auto_approve_rule_gid AND (ar.rule_type = ? or ar.rule_type = ?) AND (?
between NVL(ar.effective_date,?) and NVL(ar.expiration_date,?)) order by
rpd.auto_approve_rule_seq_no asc; [EBSU11I.LEEDYD, NON-CONSOLIDATED, BOTH, null,
null, null] [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default
(self-tuning)']
0