Monday, November 9, 2009

Oracle doesn't have a clue - take 3... workflow history

Well.... Interesting day for Oracle users as Oracle cuts over to the new "My Oracle Support" portal. Another great technology snafu by Oracle. Kinda reminds me of Microsoft. They just can't seem to prevent screwing up customer's days...

One of the other great 'features' of the EBS suite is the workflow history purge process. If you are an 11i client, if you want to purge workflow notifications, you also will be purging workflow approvals. The retention of workflow approvals (e-mails that indicate 'approval' of a workflow process such as journal approvals) is critical to have audit history related to automated controls. Failure to retain an audit history of workflow approvals could mean an external auditor would not allow reliance on automated controls under the AS5 standard.

Your organization needs to build a custom retention process to store this data for at least 15 months (check your org's data retention policy before purging...) in order to support audit requirements.

If this 'feature' is news to you, contact me for more details at I can provide some tips (provided to be my Karen Brownfield of Solution Beacon) on how to build a custom archive process for retaining such data.

Good luck to all of you trying to new Oracle's new Metalink replacement!

Jeffrey T. Hare, CPA CISA CIA