Monday, February 18, 2013

Implementing Supplier Bank Account Approval in Oracle 11i


Employees who have access to Bank Account form can deliberately assign suppliers to a bank account for one’s advantage. Implementing Supplier Bank Account Approval process can eliminate fraud.

Business Need
  • Supplier Bank Account setup should be temporarily end dated after new supplier assignment or change in existing supplier assignment. No further changes should be allowed for submitted supplier assignment until approval (refer Figure 1 and 2).
  • Approver should be notified by email for changes in supplier assignment (Figure 3).
  • Approver can either approve or reject
    • After Approve, supplier assignment should become active.
    • After Reject, it should be on hold, but submitter should be allowed further changes.