Audit Policy Records all Changes in the Database Table when no Fields are Defined or when only Some are Defined

When an audit policy is configured it is noted that it will track all changes in the table regardless of what audit fields are defined for that table.
The Audit Tables tab has a check box under the Table Details section for "1 record/field". If this is unchecked, the values will show on the Data Activity Auditing Report, but it will track all of the fields changed on the profile. If the 1 record/field box is checked, the values will show on the User Activity Auditing Report. Unfortunately, it will track all of the fields, not just the ones you designate.

The reports pull from different tables in FIMS based on what box is checked and typically everything is tracked especially for funds and profiles. Depending on your box selection this will determine what report should be run. This is a Progress feature that was enabled for FIMS use and as such you may want to review the Progress documentation on this feature.

Potentially at your discretion you could choose to delete or disable all of the audit policies in FIMS and setup auditing directly in Progress as it may give you more control over what data is tracked. It is recommended that you test any auditing in your Demo database first.

Progress documentation on Audit policies:

On the bottom of the article above it indicates to go to Start>Programs >OpenEdge > Help > Application Help on the server where Progress is installed to get to the Audit Policy Maintenance help where there is further documentation:

User-added image

Progress documentation on setting up auditing in OpenEdge:

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.




Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.