My Oracle Support Banner

How To Create An Audit Report On AME Rules Usages (Doc ID 466816.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Approvals Management - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Goal

When using AME for Purchase Requisition Approval, the user wants to create an Audit Report
describing employees, jobs, and approval limits and Rules and all of their contents (conditions,
actions, attributes).

In the ame_rules table there is an action_id column. This column is non-mandatory and does not
contain any action_id. Therefore, we cannot obtain the actions that drive the approvals for each
rule, and also users cannot tie rules to the Approval Authority column in the per_jobs table which
user need dto do.

The user would like a solution that will populate the action_id column in the ame_rule table both
for existing data and any new rules that are created.




Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.